Debian Codegraph @

mysql-test/suite/sysschema/include/sys_config_cleanup.inc

raw
1 # Reset the sys.sys_config table
2
3 # Note, we have to disable the triggers to reset the set_by column back to NULL
4 # as the sys.sys_config_update_set_user trigger will overwrite it to the current user
5 SET @sys.ignore_sys_config_triggers := true;
6
7 DELETE FROM sys.sys_config;
8
9 INSERT IGNORE INTO sys.sys_config (variable, value) VALUES
10 ('statement_truncate_len', 64),
11 ('statement_performance_analyzer.limit', 100),
12 ('statement_performance_analyzer.view', NULL),
13 ('diagnostics.allow_i_s_tables', 'OFF'),
14 ('diagnostics.include_raw', 'OFF'),
15 ('ps_thread_trx_info.max_length', 65535);
16
17 SET @sys.ignore_sys_config_triggers := NULL;