Server IP : 172.67.216.182 / Your IP : 104.23.175.161 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/sys_vars/r/ |
Upload File : |
SET @global_slow_query_log = @@global.slow_query_log; SET @global_log_output = @@global.log_output; SET @@session.long_query_time=1; SET @@global.log_output = 'TABLE'; '----When slow_query_log = OFF----' SET @@global.slow_query_log = OFF; TRUNCATE mysql.slow_log; SELECT sleep(2); sleep(2) 0 SELECT count(*) FROM mysql.slow_log; count(*) 0 '----When slow_query_log = ON-----' SET @@global.slow_query_log = ON; TRUNCATE mysql.slow_log; SELECT sleep(2) AS bug53630; bug53630 0 SELECT count(*) > 0 FROM mysql.slow_log WHERE sql_text LIKE '% bug53630'; count(*) > 0 1 SELECT thread_id - connection_id() FROM mysql.slow_log WHERE sql_text LIKE '% bug53630' ORDER BY start_time DESC LIMIT 1; thread_id - connection_id() 0 'Bug#47905 stored procedures not logged correctly to slow query log' TRUNCATE mysql.slow_log; CREATE PROCEDURE p_test() BEGIN select sleep(2); select 1; END// CALL p_test(); sleep(2) 0 1 1 SELECT count(*) > 0 FROM mysql.slow_log; count(*) > 0 1 DROP PROCEDURE p_test; Bug53191 Lock_time in slow log is negative when logging stored routines TRUNCATE mysql.slow_log; SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. CREATE TABLE t1 (c0 INT PRIMARY KEY AUTO_INCREMENT, c1 TIMESTAMP, c2 TIMESTAMP); CREATE FUNCTION f_slow_now() RETURNS TIMESTAMP BEGIN DO SLEEP(2); RETURN NOW(); END// CREATE FUNCTION f_slow_current_time() RETURNS TIME BEGIN DO SLEEP(2); RETURN CURRENT_TIME(); END // INSERT INTO t1 (c1,c2) VALUES (now(), f_slow_now())// CREATE TRIGGER tf_before BEFORE INSERT ON t1 FOR EACH ROW BEGIN SET new.c2 = f_slow_now(); END// CREATE PROCEDURE p1() BEGIN INSERT INTO t1 (c1,c2) values (now(),now()); DO SLEEP(2); INSERT INTO t1 (c1,c2) values (now(),now()); end// INSERT INTO t1 (c1,c2) VALUES (now(), now()); CALL p1(); SELECT c1-c2 FROM t1; c1-c2 0 0 0 0 *** There shouldn't less than 1 s difference between each row SELECT t1.c1-self.c1 > 1 FROM t1, t1 as self WHERE t1.c0=self.c0+1 ORDER BY t1.c0; t1.c1-self.c1 > 1 1 1 1 DROP TRIGGER tf_before; DROP FUNCTION f_slow_now; DROP FUNCTION f_slow_current_time; DROP TABLE t1; DROP TABLE IF EXISTS t1; Warnings: Note 1051 Unknown table 'test.t1' CREATE TABLE t1(c1 INT) ENGINE=MyISAM; DROP PROCEDURE IF EXISTS p1; CREATE PROCEDURE p1() BEGIN INSERT INTO t1 VALUES (1); SELECT COUNT(*) FROM t1 WHERE c1= 1; UPDATE t1 SET c1=c1*2; END| Connection 2 LOCK TABLE t1 WRITE; Back to default connection CALL p1(); Wait three seconds and unlock the table UNLOCK TABLES; COUNT(*) 1 Slow log: **** 1 == we have slow log entries SELECT count(*) > 0 FROM mysql.slow_log; count(*) > 0 1 **** 0 == None of the entries have a lock time greater than 10 s SELECT count(*) FROM mysql.slow_log WHERE lock_time > 10; count(*) 0 DROP TABLE t1; DROP PROCEDURE p1; SET sql_mode = default; SET @@global.log_output = @global_log_output; SET @global.slow_query_log = @global_slow_query_log;