I have a website that serves about 130k pages per day from a mysql database. I tried the optimization scripts and they actually slowed down performance. I found after a few days load averages on server would go up to 8 or 10 and eventually 50 and the site would essentially be down it was running so slow. I discovered a trick I have never read about. If I exported the database and then created a new database and imported the data, the site would run great for a few days. I found no talk of this on the internet (very strange). Anyway, so I did that daily, but as site popularity has gone up it is simply not enough.
The above was all one an 8 core high end box with 4 gig of ram.
So I got a separate 16 core computer for running mysql ONLY. It has bought me a little time, but its still browning out in peak times.
I need somebody experienced in php - mysql to optimize it so I can continue. I just don’t get how mysql on a super powerful computer isn’t enough.
If you can help me. Please email me at my gmail acount: doug99collins (not writing email in usual format to prevent getting spammed).
I am willing to pay a fair wage to get someone to optimize this.