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

Thanks for your continued support buddy!

1) While I was getting ready to use OPTIMIZE TABLE on database tables, I put MW in ReadOnly mode. And I noticed a thing. When I put database in ReadOnly mode -performance of my website increases many times.

2) When I used this command "OPTIMIZE TABLE page" ; I got the following results:

I get the same result in case of all the tables in database.

3) I asked my host to take backup of database using --opt option. But I guess they simple used cPanel to take backup. Could you please tell me the full command to take backup with --opt option?

4) Also, could you please explain what exactly this --opt option does? Does the use of this option optimizes database automatically?

5) I will request my host to install APC.

Thank you. With your help, I have already discovered that ReadOnly mode can increase performance. I am feeling that I am nearing the solution I need for this problem that has been nagging me for more than two years!

Lalit