[TriLUG] need consulting for LAMP server

[Craig Cook via TriLUG]

Sounds like high CPU usage for MySQL.  Last I checked, MySQL is single threaded.  What queries are running during your slowness?  e.g. if you have enough really slow queries it could slow down your overall response time.

Take a look at innotop as a good tool.

"show engine innodb status"

may also be a useful command to run in the DB.

Investigate your slow query log as well.

Craig