Robinson, Eric Slow Response -- What Does This Sound Like to You?
May 09, 2013; 20:58
Robinson, Eric
Slow Response -- What Does This Sound Like to You?
We have a situation where users complain that the system periodically freezes for 30-90 seconds. We check the slow query logs and find that one user issued a complex query that did indeed take 30-90 seconds to complete. However, NO slow queries are recorded for the other 50 users, before, during, or after the freeze. Note that the complex query in question always shows: "Lock_time: 0".
Q: What conditions could cause single query to lock up a database for a while for all users (even though it shows "lock time: 0") but no other slow queries would show in the logs for any other users who are hitting the database at the same time?
Disclaimer - May 9, 2013 This email and any files transmitted with it are confidential and intended solely for mysql@lists.mysql.com. 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/
May 09
Rick James RE: Slow Response -- What Does This Sound Like to You?
May 09, 2013; 21:14
Rick James
RE: Slow Response -- What Does This Sound Like to You?
May 09
Robinson, Eric RE: Slow Response -- What Does This Sound Like to You?
May 09, 2013; 22:25
Robinson, Eric
RE: Slow Response -- What Does This Sound Like to You?
May 09
Johnny Withers Re: Slow Response -- What Does This Sound Like to You?
May 09, 2013; 17:34
Johnny Withers
Re: Slow Response -- What Does This Sound Like to You?
May 10
Denis Jedig Re: Slow Response -- What Does This Sound Like to You?
May 10, 2013; 00:39
Denis Jedig
Re: Slow Response -- What Does This Sound Like to You?
May 09
Wm Mussatto RE: Slow Response -- What Does This Sound Like to You?
May 09, 2013; 15:50
Wm Mussatto
RE: Slow Response -- What Does This Sound Like to You?
May 09
Robinson, Eric RE: Slow Response -- What Does This Sound Like to You?
May 09, 2013; 23:13
Robinson, Eric
RE: Slow Response -- What Does This Sound Like to You?
May 09
shawn green Re: Slow Response -- What Does This Sound Like to You?
May 09, 2013; 19:36
shawn green
Re: Slow Response -- What Does This Sound Like to You?
May 09
Bruce Ferrell Re: Slow Response -- What Does This Sound Like to You?
May 09, 2013; 18:04
Bruce Ferrell
Re: Slow Response -- What Does This Sound Like to You?
May 10
Rick James RE: Slow Response -- What Does This Sound Like to You?
May 10, 2013; 01:47
Rick James
RE: Slow Response -- What Does This Sound Like to You?
May 10
Vikas Shukla RE: Slow Response -- What Does This Sound Like to You?
May 10, 2013; 09:36
Vikas Shukla
RE: Slow Response -- What Does This Sound Like to You?
May 10
Rick James RE: Slow Response -- What Does This Sound Like to You?
May 10, 2013; 20:20
Rick James
RE: Slow Response -- What Does This Sound Like to You?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!