My Joomla mysql database has about 3.4 million rows in content table. It is just static article. Very slow and often use out of resources. To speed up it, I segmented it into 6 sub-tables and added many indexes.
However, the problem still there and some times more serious. Current situation: Memory used out, could not connect to database, table locked 500 and 404 errors reported by Google webmaster tool 16000 times per day, Some pages load quickly but some pages load slow or not show(query long time, 10 minutes, or 30 minutes more)
My VPS is host gator level 7.
Please give me some advices on how to change the situation.