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

Hi Lalit,

What do you have in the slow-query-log? Always the same few queries, which are slow? Or many many different queries, which are slow? And what is the average time they need?

Which table engines are you using in MySQL? InnoDB is recommended (only a few tables have to be MyISAM). However, both InnoDB and MyISAM should be optimizable. Maybe optimizing works better, when you do not use PHPMyadmin (which might run into a PHP timeout), but when you optimize the tables from the commandline with something like "mysqldump --opt". This is also something which I am doing regularly: Keeps the DB in good shape and gives me a backup. ;-)

Other ideas: When you say charset "Unicode" that is fine. Do you have the PECL extension for PHP installed? It might give you better performance with regards to UTF-8 conversions. Make sure that really everything in your wiki is UTF-8. DB server, DB setting, tables, columns, frontend output... Are you using an opcode cache? You might get better performance when you use one.

Generally MediaWiki should be working with your amount of page views. Wikipedia uses the release versions (with a few minimal changes) and they are running fine as well. So I would say that you do not have to modify the MW source code in order to get better results.