Hi Greg, You could try turning on the slow query log ( http://dev.mysql.com/doc/refman/5.4/en/slow-query-log.html ) and see if it has anything to say. Note though that "/The time to acquire the initial table locks is not counted as execution time", /so if Paul is right and its the table type you're using that's the problem then it won't tell you about it.
http://blog.mysqltuner.com/ is a useful place to start too, esp if it's not table locking. Cheers, Andy --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
