78 lines
2.7 KiB
Plaintext
78 lines
2.7 KiB
Plaintext
# WL#12393: Logging: Add new command line option for richer slow query logging
|
|
|
|
# test global variable "log_slow_extra"
|
|
|
|
SELECT @@global.log_slow_extra INTO @old_lse;
|
|
SELECT @@global.log_output INTO @old_lo;
|
|
SELECT @@global.slow_query_log INTO @old_sql;
|
|
# invalid values / types
|
|
SET GLOBAL log_slow_extra=symbol;
|
|
ERROR 42000: Variable 'log_slow_extra' can't be set to the value of 'symbol'
|
|
SET GLOBAL log_slow_extra="string";
|
|
ERROR 42000: Variable 'log_slow_extra' can't be set to the value of 'string'
|
|
SET GLOBAL log_slow_extra=99;
|
|
ERROR 42000: Variable 'log_slow_extra' can't be set to the value of '99'
|
|
SET GLOBAL log_slow_extra=0.5;
|
|
ERROR 42000: Incorrect argument type to variable 'log_slow_extra'
|
|
|
|
# only GLOBAL scope is valid
|
|
SET SESSION log_slow_extra=0;
|
|
ERROR HY000: Variable 'log_slow_extra' is a GLOBAL variable and should be set with SET GLOBAL
|
|
|
|
# valid values
|
|
SET GLOBAL slow_query_log=0;
|
|
SET GLOBAL log_slow_extra=0;
|
|
SELECT @@global.log_slow_extra;
|
|
@@global.log_slow_extra
|
|
0
|
|
SET GLOBAL log_slow_extra=1;
|
|
SELECT @@global.log_slow_extra;
|
|
@@global.log_slow_extra
|
|
1
|
|
SET GLOBAL log_slow_extra=DEFAULT;
|
|
SELECT @@global.log_slow_extra;
|
|
@@global.log_slow_extra
|
|
0
|
|
|
|
# warnings and errors
|
|
SET GLOBAL slow_query_log=1;
|
|
|
|
# Switching slow query log file format while target is not FILE is legal,
|
|
# but does nothing. Throw a warning!
|
|
SET GLOBAL log_output="TABLE";
|
|
SELECT @@global.log_slow_extra INTO @old;
|
|
SET GLOBAL log_slow_extra=1;
|
|
Warnings:
|
|
Warning 3795 slow query log file format changed as requested, but setting will have no effect when not actually logging to a file.
|
|
# Value must have changed:
|
|
SELECT @@global.log_slow_extra!=@old;
|
|
@@global.log_slow_extra!=@old
|
|
1
|
|
SET GLOBAL log_slow_extra=DEFAULT;
|
|
Warnings:
|
|
Warning 3795 slow query log file format changed as requested, but setting will have no effect when not actually logging to a file.
|
|
|
|
# Switching slow query log file format while target is not FILE is legal,
|
|
# but does nothing. Throw a warning!
|
|
SET GLOBAL log_output="NONE";
|
|
SELECT @@global.log_slow_extra INTO @old;
|
|
SET GLOBAL log_slow_extra=1;
|
|
Warnings:
|
|
Warning 3795 slow query log file format changed as requested, but setting will have no effect when not actually logging to a file.
|
|
# Value must have changed:
|
|
SELECT @@global.log_slow_extra!=@old;
|
|
@@global.log_slow_extra!=@old
|
|
1
|
|
SET GLOBAL log_slow_extra=DEFAULT;
|
|
Warnings:
|
|
Warning 3795 slow query log file format changed as requested, but setting will have no effect when not actually logging to a file.
|
|
|
|
# clean up
|
|
SET GLOBAL log_slow_extra=@old_lse;
|
|
Warnings:
|
|
Warning 3795 slow query log file format changed as requested, but setting will have no effect when not actually logging to a file.
|
|
SET GLOBAL log_output=@old_lo;
|
|
SET GLOBAL slow_query_log=@old_sql;
|
|
|
|
# READY
|