101 reputation
2
bio website andreimackenzie.com
location United States
age 30
visits member for 2 years
seen 9 hours ago

ohi


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