List:General Discussion« Previous MessageNext Message »
From:Eric Robinson Date:May 30 2013 10:13pm
Subject:Are There Slow Queries that Don't Show in the Slow Query Logs?
View as plain text  
As everyone knows, with MyISAM, queries and inserts can lock tables and force other
queries to wait in a queue. When that happens, does the time shown in the slow query logs
represent the whole time from when the server received the request to when the response
was sent to the client? Or is the time a query spends waiting for a table lock to be
released omitted from what is recorded in the slow query logs?

--
Eric Robinson






Disclaimer - May 30, 2013 
This email and any files transmitted with it are confidential and intended solely for
'mysql@stripped'. If you are not the named addressee you should not disseminate,
distribute, copy or alter this email. Any views or opinions presented in this email are
solely those of the author and might not represent those of Physicians' Managed Care or
Physician Select Management. Warning: Although Physicians' Managed Care or Physician
Select Management has taken reasonable precautions to ensure no viruses are present in
this email, the company cannot accept responsibility for any loss or damage arising from
the use of this email or attachments. 
This disclaimer was added by Policy Patrol: http://www.policypatrol.com/

Thread
Are There Slow Queries that Don't Show in the Slow Query Logs?Eric Robinson30 May
RE: Are There Slow Queries that Don't Show in the Slow Query Logs?Vikas Shukla31 May
  • RE: Are There Slow Queries that Don't Show in the Slow Query Logs?Eric Robinson31 May