Debian Codegraph @

mysql-test/suite/perfschema/r/persisted_variables.result

raw
1 # Test persisted variables
2 select * from performance_schema.persisted_variables ORDER BY 1;
3 VARIABLE_NAME VARIABLE_VALUE
4 SET PERSIST foreign_key_checks=0;
5 SET PERSIST flush_time=2;
6 select * from performance_schema.persisted_variables ORDER BY 1;
7 VARIABLE_NAME VARIABLE_VALUE
8 flush_time 2
9 foreign_key_checks OFF
10 SET PERSIST sort_buffer_size=256000;
11 SET PERSIST max_heap_table_size=999424, replica_net_timeout=124;
12 SET PERSIST innodb_default_row_format=COMPACT;
13 SET @@persist.max_execution_time=44000, @@persist.max_user_connections=30;
14 select * from performance_schema.persisted_variables ORDER BY 1;
15 VARIABLE_NAME VARIABLE_VALUE
16 flush_time 2
17 foreign_key_checks OFF
18 innodb_default_row_format compact
19 max_execution_time 44000
20 max_heap_table_size 999424
21 max_user_connections 30
22 replica_net_timeout 124
23 slave_net_timeout 124
24 sort_buffer_size 256000
25 SET PERSIST foreign_key_checks=DEFAULT;
26 SET PERSIST flush_time=DEFAULT;
27 SET PERSIST sort_buffer_size=DEFAULT;
28 SET PERSIST max_heap_table_size=DEFAULT, replica_net_timeout=DEFAULT;
29 SET PERSIST innodb_default_row_format=DEFAULT;
30 SET @@persist.max_execution_time=DEFAULT, @@persist.max_user_connections=DEFAULT;
31 RESET PERSIST;
32 SELECT 'END OF TEST';
33 END OF TEST
34 END OF TEST