Is there an easy way in mysql to turn on some logging to see which queries are taking the longest?
See http://www.mysql.com/doc/L/o/Log_Files.html and esp. http://www.mysql.com/doc/S/l/Slow_query_log.html
Let me know the results ASAP because I would really like some real data on where the real problems are.
-- Jan Hidders