1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA='sys';
COUNT(*)
0
DESC sys.sys_config;
Field Type Null Key Default Extra
variable varchar(128) NO PRI NULL
value varchar(128) YES NULL
set_time timestamp NO current_timestamp() on update current_timestamp()
set_by varchar(128) YES NULL
SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1;
variable value set_by
diagnostics.allow_i_s_tables OFF NULL
diagnostics.include_raw OFF NULL
ps_thread_trx_info.max_length 65535 NULL
statement_performance_analyzer.limit 100 NULL
statement_performance_analyzer.view NULL NULL
statement_truncate_len 64 NULL
UPDATE sys.sys_config SET value = 128 WHERE variable = 'statement_truncate_len';
SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1;
variable value set_by
diagnostics.allow_i_s_tables OFF NULL
diagnostics.include_raw OFF NULL
ps_thread_trx_info.max_length 65535 NULL
statement_performance_analyzer.limit 100 NULL
statement_performance_analyzer.view NULL NULL
statement_truncate_len 128 NULL
INSERT INTO sys.sys_config (variable, value) VALUES ('foo', 'bar');
SELECT variable, value, set_by FROM sys.sys_config ORDER BY 1;
variable value set_by
diagnostics.allow_i_s_tables OFF NULL
diagnostics.include_raw OFF NULL
foo bar NULL
ps_thread_trx_info.max_length 65535 NULL
statement_performance_analyzer.limit 100 NULL
statement_performance_analyzer.view NULL NULL
statement_truncate_len 128 NULL
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;
|
