Debian Codegraph @

mysql-test/suite/sysschema/r/t_sys_config.result

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