Thread:Project:Support desk/Very slow MW website, possibly due to database/reply (7)

Hi Lalit,

1) What output you get from OPTIMIZE ... depends on your table engine. For InnoDB it is normal that the table will be recreated. The command ran successfully.

2) That depends: Some only make sense in the backup file (like the DROP TABLE IF EXISTS command). But as far as I know, it applies optimization to the DB itself. Optimizing tables can help to defragment the table data and in so far make the DB a bit faster. But it surely will not make it 5 or even 10 seconds faster when writing things. So: No, this alone will not solve your writing slowness.

3) There are a few tuning scripts in the internet, e.g. called "MySQLTuner.pl" or "Tuning-Primer.sh". They might give you first ideas of what to change. Note, however, that not everything, what these scripts propose, _must_ make sense in your case. For example adjusting "innodb_buffer_pool_size" might make sense. E.g. increase it to 80% of the memory of your dedicated host.