On Tue, Jul 21, 2009 at 3:37 AM, Anthony Lopez<[email protected]> wrote: > I have seen something similar and agree it that MySQL is the likely > culprit. Turning on the slow query log in MySQL may show you some of the > queries that are taking long but once they start stacking up then > everything winds up slow and going into the log. Make sure to run the > explain plan on all your queries and analyze them carefully. A few > months back we restarted a mysql instance without changing anything and > I/O went through the roof. Running explain looked ok but when our DBA > grouped up with the app developer they figured out the mysql wasn't > taking the best path to retrieving the data. They modified the query > and load went back to normal. >
Thanks for sharing your experience. Unfortunately, I'm not the MySQL Admin for this server. Do you have any advice that I could talk to MySQL Admin in order for them to fine-tune their side? _______________________________________________ rhelv5-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/rhelv5-list
