Jump to content

Optimizing the database


Recommended Posts

Hello ! ^_^

My database is 12 Gb big and the engine is Innodb. I have two questions about optimization.

I was told I should optimize my database and I'm asking myself :

- how long will it take (approximately) ?

- since I constantly have new content published in my database (on my board), will this new content be lost after the optimize or does this operation take into account the fact that the database is constantly updated ?...

Thank you ! ^_^

Link to comment
Share on other sites

Optimization must be done on the system and on my.cnf file that holds the info on how your database will work....

After finding the correct values for your system/database then you only need to restart your database.....

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...