1set @log_output.saved = @@global.log_output; 2set @@global.log_output = 'TABLE'; 3connect con1,localhost,root,,; 4connect con2,localhost,root,,; 5connection con1; 6set session long_query_time=10; 7select get_lock('bug27638', 1); 8get_lock('bug27638', 1) 91 10connection con2; 11set session long_query_time=1; 12select get_lock('bug27638', 2); 13get_lock('bug27638', 2) 140 15select if (query_time >= '00:00:01', 'OK', concat('WRONG: ',query_time)) as qt, sql_text from mysql.slow_log 16where sql_text = 'select get_lock(\'bug27638\', 2)'; 17qt sql_text 18OK select get_lock('bug27638', 2) 19select get_lock('bug27638', 60); 20get_lock('bug27638', 60) 210 22select if (query_time >= '00:00:59', 'OK', concat('WRONG: ',query_time)) as qt, sql_text from mysql.slow_log 23where sql_text = 'select get_lock(\'bug27638\', 60)'; 24qt sql_text 25OK select get_lock('bug27638', 60) 26select get_lock('bug27638', 101); 27get_lock('bug27638', 101) 280 29select if (query_time >= '00:01:40', 'OK', concat('WRONG: ',query_time)) as qt, sql_text from mysql.slow_log 30where sql_text = 'select get_lock(\'bug27638\', 101)'; 31qt sql_text 32OK select get_lock('bug27638', 101) 33connection con1; 34select release_lock('bug27638'); 35release_lock('bug27638') 361 37connection default; 38disconnect con1; 39disconnect con2; 40set @@global.log_output = @log_output.saved; 41