diff options
Diffstat (limited to 'mysql-test/t/log_slow.test')
-rw-r--r-- | mysql-test/t/log_slow.test | 60 |
1 files changed, 0 insertions, 60 deletions
diff --git a/mysql-test/t/log_slow.test b/mysql-test/t/log_slow.test deleted file mode 100644 index 56e35bd5a20..00000000000 --- a/mysql-test/t/log_slow.test +++ /dev/null @@ -1,60 +0,0 @@ -# -# Testing of slow log query options -# - -select @@log_slow_filter; -select @@log_slow_rate_limit; -select @@log_slow_verbosity; -show variables like "log_slow%"; -set @org_slow_query_log= @@global.slow_query_log; - -# Some simple test to set log_slow_filter -set @@log_slow_filter= "filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk,admin"; -select @@log_slow_filter; -set @@log_slow_filter="admin,admin"; -select @@log_slow_filter; -set @@log_slow_filter=7; -select @@log_slow_filter; - -# Test of wrong values ---error 1231 -set @@log_slow_filter= "filesort,impossible,impossible2,admin"; ---error 1231 -set @@log_slow_filter= "filesort, admin"; ---error 1231 -set @@log_slow_filter= 1<<31; -select @@log_slow_filter; - -# Some simple test to set log_slow_verbosity -set @@log_slow_verbosity= "query_plan,innodb"; -select @@log_slow_verbosity; -set @@log_slow_verbosity=1; -select @@log_slow_verbosity; - -# -# Check which fields are in slow_log table -# - -show fields from mysql.slow_log; - -# -# Check flush command -# - -flush slow logs; - -# MDEV-4206 (empty filter should be no filter) -set long_query_time=0.1; -set log_slow_filter=''; -set global slow_query_log=1; -set global log_output='TABLE'; -select sleep(0.5); -select count(*) FROM mysql.slow_log; - -# Reset used variables -set @@long_query_time=default; -set global slow_query_log= @org_slow_query_log; -set @@log_slow_filter=default; -set @@log_slow_verbosity=default; -set global log_output= default; -truncate mysql.slow_log; |