diff options
| author | Daniel Black <daniel@mariadb.org> | 2022-12-05 09:03:06 +1100 |
|---|---|---|
| committer | Daniel Black <daniel@mariadb.org> | 2023-01-23 08:39:41 +1100 |
| commit | 26ef4875e6ba17cb1cf83e4eec5b39b6ab5f89e8 (patch) | |
| tree | 12827eeae8dffb825565520b01ad331658092b6f /mysql-test/main/log_slow_debug.result | |
| parent | 61161cdaf99f8548815a7de97a544f8d0ab76960 (diff) | |
| download | mariadb-git-26ef4875e6ba17cb1cf83e4eec5b39b6ab5f89e8.tar.gz | |
MDEV-6339 deprecate log_slow_admin_statements
log_slow_filter=admin as been available for a long time.
Uses can migrate from log_slow_statements_statements=OFF by removing
'admin' from the default log_slow_filter variable setting.
Diffstat (limited to 'mysql-test/main/log_slow_debug.result')
| -rw-r--r-- | mysql-test/main/log_slow_debug.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/log_slow_debug.result b/mysql-test/main/log_slow_debug.result index 16d67d7fdc7..eaf38425f8b 100644 --- a/mysql-test/main/log_slow_debug.result +++ b/mysql-test/main/log_slow_debug.result @@ -6,6 +6,8 @@ SET @@GLOBAL.log_output='TABLE'; FLUSH SLOW LOGS; SET @@GLOBAL.slow_query_log=ON; SET @@GLOBAL.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET @saved_dbug = @@debug_dbug; SET SESSION debug_dbug="+d,simulate_slow_query"; CREATE PROCEDURE show_slow_log() @@ -19,6 +21,8 @@ $$ # Expect all admin statements in the slow log (ON,DEFAULT) # SET @@SESSION.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=DEFAULT; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -66,6 +70,8 @@ sql_text # Expect all admin statements in the slow log (ON,admin) # SET @@SESSION.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=admin; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -100,6 +106,8 @@ sql_text # Expect none of admin DDL statements in the slow log (ON,filesort) # SET @@SESSION.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=filesort; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -127,6 +135,8 @@ sql_text # Expect none of admin statements in the slow log (OFF,DEFAULT) # SET @@SESSION.log_slow_admin_statements=OFF; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=DEFAULT; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -171,7 +181,11 @@ sql_text # prevent enabling globally suppressed logging by setting the session variable to ON. # SET @@GLOBAL.log_slow_admin_statements=OFF; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET @@SESSION.log_slow_admin_statements=ON; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead SET log_slow_filter=DEFAULT; TRUNCATE TABLE mysql.slow_log; CREATE TABLE t1 (a INT); @@ -223,4 +237,6 @@ TRUNCATE mysql.slow_log; SET @@global.slow_query_log= @org_slow_query_log; SET @@global.log_output= @org_log_output; SET @@global.log_slow_admin_statements= @org_log_slow_admin_statements; +Warnings: +Warning 1287 '@@log_slow_admin_statements' is deprecated and will be removed in a future release. Please use '@@log_slow_filter' instead DROP PROCEDURE show_slow_log; |