… 300 seconds and because the resultset is huge, it eventually starts creating a temp table on disk. Now during those 300 second…’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up. If… as ‘null’ and Info says ‘commit’ The ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled…