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

Hello everyone,

My MediaWiki site is extremely slow and goes down due to congestion several times a day. I have tried almost all help that I could find on Internet but the site is still very very very slow. Please help! Here are the details:

I setup this site in 2006 using MW 1.14 (if I remember correctly)… I have changed three servers since then.

Total pages: 60,000 Charset: Unicode (Hindi Devanagari) Current config: MW 1.20.3 ; MySql 5.1.68; PHP 5.3.23 Server: it's a VPS on which I have complete access ; 1800 MB is available RAM Traffic: close to 1.5 million page views per month… 1,25,000 visits per month

I believe that it is the database that is causing problem because I have thousands of entries in slow-query-log but I don't know what to do with this information. Am I supposed to go into the core MW files and do tweaking with SQL queries?

When I try to OPTIMIZE TABLE through phpMyAdmin –it says that the table are not optimizable.

What database maintenance tasks I need to perform regularly to keep the database in good shape?

Please help. I shall be grateful.