Debian Codegraph @

mysql-test/suite/perfschema/t/persisted_variables.test

raw
1 --echo # Test persisted variables
2
3 # return 0 rows
4 select * from performance_schema.persisted_variables ORDER BY 1;
5 SET PERSIST foreign_key_checks=0;
6 SET PERSIST flush_time=2;
7 # return 2 rows
8 select * from performance_schema.persisted_variables ORDER BY 1;
9 SET PERSIST sort_buffer_size=256000;
10 SET PERSIST max_heap_table_size=999424, replica_net_timeout=124;
11 SET PERSIST innodb_default_row_format=COMPACT;
12 SET @@persist.max_execution_time=44000, @@persist.max_user_connections=30;
13 # return 8 rows
14 select * from performance_schema.persisted_variables ORDER BY 1;
15
16 SET PERSIST foreign_key_checks=DEFAULT;
17 SET PERSIST flush_time=DEFAULT;
18 SET PERSIST sort_buffer_size=DEFAULT;
19 SET PERSIST max_heap_table_size=DEFAULT, replica_net_timeout=DEFAULT;
20 SET PERSIST innodb_default_row_format=DEFAULT;
21 SET @@persist.max_execution_time=DEFAULT, @@persist.max_user_connections=DEFAULT;
22
23 RESET PERSIST;
24 let $MYSQLD_DATADIR= `select @@datadir`;
25 --remove_file $MYSQLD_DATADIR/mysqld-auto.cnf
26
27 SELECT 'END OF TEST';