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

Thanks a bunch buddy!

1) slow-query-log shows a vast variety of queries. So, I guess it is not a particular query that is taking the whole site down.

2) In the same context, I have a curiosity. If there is a particular query that is taking forever -what would you have done? Would you have optimize it and change it in core MW files? I wonder, if that is the case, don't all the MW sites would face the problem due to that unoptimized query (for it is part of the core MW software)?

3) All tables are InnoDB except a few, which are MyISAM.

4) In last seven years of my site's running I have NEVER optimized tables because I always try to do so via phpMyAdmin and it says tables are not optimizable. That could be the reasons behind this mess. I will try to optimize tables from command line now. And will get back to you with the results.

5) I don't know if PHP has PECL extension. Will ask the host about it.

6) By opcode cache, do you meaning setting MW to use FileCache?

Thanks once again for your great support. I just hope optimization of tables work and make MW performance better.