Create an Account
username: password:
 
  MemeStreams Logo

MySQL AB :: MySQL 5.0 Reference Manual :: 5.12.4 The Slow Query Log

search

Lost
Picture of Lost
My Blog
My Profile
My Audience
My Sources
Send Me a Message

sponsored links

Lost's topics
Arts
Business
Games
Health and Wellness
Home and Garden
Miscellaneous
Current Events
Recreation
Local Information
Science
Society
Sports
Technology

support us

Get MemeStreams Stuff!


 
MySQL AB :: MySQL 5.0 Reference Manual :: 5.12.4 The Slow Query Log
Topic: Technology 7:48 pm EST, Mar 10, 2007

5.12.4. The Slow Query Log

The slow query log consists of all SQL statements that took more than long_query_time seconds to execute. The time to acquire the initial table locks is not counted as execution time. mysqld writes a statement to the slow query log after it has been executed and after all locks have been released, so log order might be different from execution order. The minimum and default values of long_query_time are 1 and 10, respectively.

Great tool to find low hanging fruit in your database application.

MySQL AB :: MySQL 5.0 Reference Manual :: 5.12.4 The Slow Query Log



 
 
Powered By Industrial Memetics
RSS2.0