diff options
Diffstat (limited to 'mysql-test/suite/sysschema/include/sys_config_cleanup.inc')
-rw-r--r-- | mysql-test/suite/sysschema/include/sys_config_cleanup.inc | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/suite/sysschema/include/sys_config_cleanup.inc b/mysql-test/suite/sysschema/include/sys_config_cleanup.inc new file mode 100644 index 00000000000..af8d0362519 --- /dev/null +++ b/mysql-test/suite/sysschema/include/sys_config_cleanup.inc @@ -0,0 +1,17 @@ +# Reset the sys.sys_config table + +# Note, we have to disable the triggers to reset the set_by column back to NULL +# as the sys.sys_config_update_set_user trigger will overwrite it to the current user +SET @sys.ignore_sys_config_triggers := true; + +DELETE FROM sys.sys_config; + +INSERT IGNORE INTO sys.sys_config (variable, value) VALUES + ('statement_truncate_len', 64), + ('statement_performance_analyzer.limit', 100), + ('statement_performance_analyzer.view', NULL), + ('diagnostics.allow_i_s_tables', 'OFF'), + ('diagnostics.include_raw', 'OFF'), + ('ps_thread_trx_info.max_length', 65535); + +SET @sys.ignore_sys_config_triggers := NULL; |