Identifying MySQL slow queries
Here are some handy on monitoring troublesome queries in your MySQL db.
With the info identified here you will setup slowquery logging and be able to generate short reports of the top ten slowest queries.
Slow is defined as any query that is longer than 1 second in duration.
One of the most important steps in optimizing and tuning mysql is to identify the queries that are causing problems. How can we find out what queries are taking a long time to complete? How can we see what queries are slowing down the mysql server? Mysql has the answer for us and we only need to know where to look for it…
Listed below are links to blogs that reference this entry: Identifying MySQL slow queries.
TrackBack URL for this entry: