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