| 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'; |