101 reputation
3
bio website andreimackenzie.com
location United States
age 31
visits member for 2 years, 5 months
seen 34 mins ago

ohi


Aug
11
awarded  Popular Question
Jun
28
comment Lock wait timeout exceeded on insert despite low lock_time in the slow query log
>They're probably sitting there not really doing anything waiting for some other query to finish until they're effectively killed What i don't understand is why this doesn't count as 'Lock_wait'. They are waiting, but not for a lock?
Jun
28
awarded  Supporter
Jun
28
comment Lock wait timeout exceeded on insert despite low lock_time in the slow query log
> The lock times are times spent actually locking affected tables Is this true? My understanding is that it is time spent by the query waiting for a lock to be freed.
Jun
28
asked Lock wait timeout exceeded on insert despite low lock_time in the slow query log
Jun
28
awarded  Autobiographer