Identifying MySQL slow queries

By klsh on November 21, 2006 10:41 AM | | TrackBacks (0)

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.

Identifying MySQL slow queries | MDLog:/sysadmin

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…

Categories:

0 TrackBacks

Listed below are links to blogs that reference this entry: Identifying MySQL slow queries.

TrackBack URL for this entry: http://kennethhunt.com/mt/mt-tb.cgi/1774

About this Entry

This page contains a single entry by klsh published on November 21, 2006 10:41 AM.

Check Your Mobile Phone Minute Usage Firefox Plugins For Cellular Carriers was the previous entry in this blog.

Ruby On Rails Salted Hash Login & Authentication Generator is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.