diff options
Diffstat (limited to 'mysql-test/main/log_slow.result')
-rw-r--r-- | mysql-test/main/log_slow.result | 79 |
1 files changed, 79 insertions, 0 deletions
diff --git a/mysql-test/main/log_slow.result b/mysql-test/main/log_slow.result new file mode 100644 index 00000000000..59149633b99 --- /dev/null +++ b/mysql-test/main/log_slow.result @@ -0,0 +1,79 @@ +select @@log_slow_filter; +@@log_slow_filter +admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk +select @@log_slow_rate_limit; +@@log_slow_rate_limit +1 +select @@log_slow_verbosity; +@@log_slow_verbosity + +show variables like "log_slow%"; +Variable_name Value +log_slow_admin_statements ON +log_slow_disabled_statements sp +log_slow_filter admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk +log_slow_rate_limit 1 +log_slow_slave_statements ON +log_slow_verbosity +set @org_slow_query_log= @@global.slow_query_log; +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; +@@log_slow_filter +admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk +set @@log_slow_filter="admin,admin"; +select @@log_slow_filter; +@@log_slow_filter +admin +set @@log_slow_filter=7; +select @@log_slow_filter; +@@log_slow_filter +admin,filesort,filesort_on_disk +set @@log_slow_filter= "filesort,impossible,impossible2,admin"; +ERROR 42000: Variable 'log_slow_filter' can't be set to the value of 'impossible' +set @@log_slow_filter= "filesort, admin"; +ERROR 42000: Variable 'log_slow_filter' can't be set to the value of ' admin' +set @@log_slow_filter= 1<<31; +ERROR 42000: Variable 'log_slow_filter' can't be set to the value of '2147483648' +select @@log_slow_filter; +@@log_slow_filter +admin,filesort,filesort_on_disk +set @@log_slow_verbosity= "query_plan,innodb"; +select @@log_slow_verbosity; +@@log_slow_verbosity +innodb,query_plan +set @@log_slow_verbosity=1; +select @@log_slow_verbosity; +@@log_slow_verbosity +innodb +show fields from mysql.slow_log; +Field Type Null Key Default Extra +start_time timestamp(6) NO current_timestamp(6) on update current_timestamp(6) +user_host mediumtext NO NULL +query_time time(6) NO NULL +lock_time time(6) NO NULL +rows_sent int(11) NO NULL +rows_examined int(11) NO NULL +db varchar(512) NO NULL +last_insert_id int(11) NO NULL +insert_id int(11) NO NULL +server_id int(10) unsigned NO NULL +sql_text mediumtext NO NULL +thread_id bigint(21) unsigned NO NULL +rows_affected int(11) NO NULL +flush slow logs; +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); +sleep(0.5) +0 +select count(*) FROM mysql.slow_log; +count(*) +1 +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; |