28 lines
994 B
Plaintext
28 lines
994 B
Plaintext
--echo # Test persisted variables
|
|
|
|
# return 0 rows
|
|
select * from performance_schema.persisted_variables ORDER BY 1;
|
|
SET PERSIST foreign_key_checks=0;
|
|
SET PERSIST flush_time=2;
|
|
# return 2 rows
|
|
select * from performance_schema.persisted_variables ORDER BY 1;
|
|
SET PERSIST sort_buffer_size=256000;
|
|
SET PERSIST max_heap_table_size=999424, slave_net_timeout=124;
|
|
SET PERSIST innodb_default_row_format=COMPACT;
|
|
SET @@persist.max_execution_time=44000, @@persist.max_user_connections=30;
|
|
# return 8 rows
|
|
select * from performance_schema.persisted_variables ORDER BY 1;
|
|
|
|
SET PERSIST foreign_key_checks=DEFAULT;
|
|
SET PERSIST flush_time=DEFAULT;
|
|
SET PERSIST sort_buffer_size=DEFAULT;
|
|
SET PERSIST max_heap_table_size=DEFAULT, slave_net_timeout=DEFAULT;
|
|
SET PERSIST innodb_default_row_format=DEFAULT;
|
|
SET @@persist.max_execution_time=DEFAULT, @@persist.max_user_connections=DEFAULT;
|
|
|
|
RESET PERSIST;
|
|
let $MYSQLD_DATADIR= `select @@datadir`;
|
|
--remove_file $MYSQLD_DATADIR/mysqld-auto.cnf
|
|
|
|
SELECT 'END OF TEST';
|