Optimizing Databases?


#1

Over time, do we need to be doing anything to maintain our mysql databases?

Is there some type of optimization or compact type of service we should be running on them?

I am especially thinking about busy phpbb forum dbs.


#2

No. There are steps to improve efficiency, which is more important. Support may help with a reindex, but that’s only if they see your database under a heavy load.

phpbb3 has built in caching which helps ease the database server. If the db server is getting hammered, Support will let you know and you can adjust some limits in phpbb3’s Load settings.

-Scott