mySQL bogging down

We're running phpAdsNew on our sites. A couple weeks ago our sites got hacked, and subsequently, they rebuilt the adServer box.

Since then we have been having horrible problems with the mySQL bogging down and timing out. We are running the latest version of mySQL and php.

Our adServer currently feed approximately 500,000 ads daily to our 2 websites.

I need to be able to tell my admin what could be causing these problems and what configuration issues to target his search towards.

Any help?

Thanks.

Ron Phillips

Did you optimize your queries? (eg add an index to your table for WHERE query match)

You should look at your select statements with the EXPLAIN (just add this in front of your select statement and run the query).

You could use a heap table, which takes up a lot of RAM, but is wicked fast.

You might also want to run myisamchk -r tablename (or OPTIMIZE TABLE tablename😉. There are other MySQL optimizations available with myisamchk...

Not sure if it applies in your case, but Zend has an accelerator (Zend Accelerator 2.0) which ups performance significantly.

Thanks for your input. I don't think it is a programming issue as these problems only occured after my admin reloaded the mySQL.

I'll let him know about the Zend Accelerator, see if that is an option.