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

Hi pal,

1) I am a bit confused. I wonder why you said "Looks good" on point no. 2 in my previous message? The output of "OPTIMIZE TABLE page" command says:

Did the "OPTIMIZE TABLE page" command gave expected output? If the above is expected and output of success of command, should I go ahead and use the "OPTIMIZE TABLE" command on all the tables in database?

2) Thanks a ton for the mysqldump --opt command. I have a question about this command. I want to understand what exactly this command does:

i) does it apply all the said options (like --add-drop-table, --add-locks etc.) only on backup? OR ii) does it apply all the said options first on the live database and then takes a backup? iii) can application of all these options (like --add-drop-table, --add-locks etc.) on live database be helpful in solving the "slow while writing" problem?

3) Could you please share any other database maintenance stuff that you regularly do with your MW database? There are a few scripts in MW (like rebuildall) -do you run these scripts regularly?

Thank you!