Re: Lock Time in slow queries log
The lock_time is the time spent waiting for a lock.
Examine the queries being run to see what was preventing this query from obtaining a lock!
Regards
John
__________________________________________________________________________
John Daisley
Freelance Cognos BI Developer / SQL Server & MySQL DBA
Gloucester, United Kingdom.
Telephone +44(0)7918 621621
» MySQL Certified Database Administrator (CMDBA)
» MySQL Certified Developer (CMDEV)
» MySQL Certified Associate (CMA)
» Comptia A+ Certified Professional IT Technician
Subject
Written By
Posted
Re: Lock Time in slow queries log
August 02, 2010 05:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.