1# 2# WL#8688: Support ability to persist SET GLOBAL settings 3# 4CALL mtr.add_suppression("Failed to set up SSL because of the following *"); 5CALL mtr.add_suppression("One can only use the --user switch.*"); 6# Syntax check for PERSIST option 7SET PERSIST auto_increment_increment=10; 8SET @@persist.event_scheduler=0; 9SET PERSIST slave_compressed_protocol=1; 10# Invalid syntax cases. 11SET GLOBAL PERSIST slave_compressed_protocol=1; 12ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PERSIST slave_compressed_protocol=1' at line 1 13SET PERSIST @@global.slave_compressed_protocol=1; 14ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@@global.slave_compressed_protocol=1' at line 1 15SET PERSIST @@session.slave_compressed_protocol=1; 16ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@@session.slave_compressed_protocol=1' at line 1 17SET @@persist.@@slave_compressed_protocol=1; 18ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@@slave_compressed_protocol=1' at line 1 19# Variables_info table should include info for 20SET SESSION auto_increment_increment=3; 21SELECT VARIABLE_NAME, VARIABLE_SOURCE 22FROM performance_schema.variables_info 23WHERE VARIABLE_NAME = 'auto_increment_increment'; 24VARIABLE_NAME VARIABLE_SOURCE 25auto_increment_increment DYNAMIC 26# Setting multiple variables value as PERSIST. 27SET PERSIST innodb_checksum_algorithm=strict_crc32, 28PERSIST innodb_default_row_format=COMPACT, 29PERSIST sql_mode=ANSI_QUOTES,PERSIST innodb_fast_shutdown=0; 30SET PERSIST innodb_flush_log_at_trx_commit=0,join_buffer_size=262144; 31# SET PERSIST invalid case for multiple variable set. 32SET PERSIST innodb_thread_concurrency=32, PERSIST innodb_write_io_threads=32, 33PERSIST innodb_read_io_threads=invalid_val; 34ERROR HY000: Variable 'innodb_write_io_threads' is a read only variable 35# Restart server with --no-defaults. 36SELECT @@global.innodb_fast_shutdown; 37@@global.innodb_fast_shutdown 381 39SELECT @@global.innodb_default_row_format; 40@@global.innodb_default_row_format 41dynamic 42SELECT @@global.sql_mode; 43@@global.sql_mode 44ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION 45SELECT @@global.innodb_flush_log_at_trx_commit; 46@@global.innodb_flush_log_at_trx_commit 471 48SELECT @@global.join_buffer_size; 49@@global.join_buffer_size 50262144 51SELECT @@global.innodb_checksum_algorithm; 52@@global.innodb_checksum_algorithm 53crc32 54# Return 0 rows 55SELECT VARIABLE_NAME, VARIABLE_SOURCE 56FROM performance_schema.variables_info 57WHERE VARIABLE_SOURCE = 'PERSISTED' 58 ORDER BY VARIABLE_NAME; 59VARIABLE_NAME VARIABLE_SOURCE 60# Restart server with --defaults-file. 61# Check values after restart. 62SELECT @@global.innodb_fast_shutdown; 63@@global.innodb_fast_shutdown 640 65SELECT @@global.innodb_default_row_format; 66@@global.innodb_default_row_format 67compact 68SELECT @@global.sql_mode; 69@@global.sql_mode 70ANSI_QUOTES 71SELECT @@global.innodb_checksum_algorithm; 72@@global.innodb_checksum_algorithm 73strict_crc32 74SELECT @@global.innodb_flush_log_at_trx_commit; 75@@global.innodb_flush_log_at_trx_commit 760 77SELECT @@global.max_digest_length; 78@@global.max_digest_length 792024 80SELECT @@global.join_buffer_size; 81@@global.join_buffer_size 82262144 83SELECT @@global.sort_buffer_size; 84@@global.sort_buffer_size 85462144 86SELECT VARIABLE_NAME,VARIABLE_SOURCE,MIN_VALUE,MAX_VALUE 87FROM performance_schema.variables_info 88WHERE VARIABLE_NAME IN ('innodb_fast_shutdown','sql_mode', 89'innodb_default_row_format','max_digest_length', 90'innodb_flush_log_at_trx_commit', 91'disconnect_on_expired_password', 92'innodb_checksum_algorithm') 93ORDER BY VARIABLE_NAME; 94VARIABLE_NAME VARIABLE_SOURCE MIN_VALUE MAX_VALUE 95disconnect_on_expired_password EXPLICIT 0 0 96innodb_checksum_algorithm PERSISTED 0 0 97innodb_default_row_format PERSISTED 0 0 98innodb_fast_shutdown PERSISTED 0 2 99innodb_flush_log_at_trx_commit PERSISTED 0 2 100max_digest_length EXPLICIT 0 1048576 101sql_mode PERSISTED 0 0 102SET PERSIST max_connections=500; 103SET PERSIST autocommit=OFF; 104SELECT VARIABLE_NAME, VARIABLE_SOURCE 105FROM performance_schema.variables_info 106WHERE VARIABLE_NAME = 'max_connections'; 107VARIABLE_NAME VARIABLE_SOURCE 108max_connections DYNAMIC 109SET GLOBAL max_connections=DEFAULT; 110SELECT VARIABLE_NAME, VARIABLE_SOURCE 111FROM performance_schema.variables_info 112WHERE VARIABLE_NAME IN ('max_connections','autocommit'); 113VARIABLE_NAME VARIABLE_SOURCE 114autocommit DYNAMIC 115max_connections DYNAMIC 116CREATE TABLE t1 (col1 INT); 117DROP TABLE t1; 118SET PERSIST log_bin_trust_function_creators=1; 119# SET PERSIST statement should not be bin logged. 120# Show binlog events 121include/show_binlog_events.inc 122Log_name Pos Event_type Server_id End_log_pos Info 123binlog.000001 # Query # # use `test`; CREATE TABLE t1 (col1 INT) 124binlog.000001 # Query # # use `test`; DROP TABLE "t1" /* generated by server */ 125SET PERSIST block_encryption_mode= 'aes-128-ecb'; 126SET PERSIST ft_boolean_syntax= '+ -><()~*:""&|', 127PERSIST log_error_services=DEFAULT; 128SET PERSIST innodb_max_dirty_pages_pct=80.99; 129SET PERSIST slow_query_log=ON; 130SET PERSIST slow_query_log_file='MYSQLTEST_VARDIR/log/slow_query_on.log;'; 131# Restart server cmd line and mysql-auto.cnf testing. 132# Check values after restart. 133SET PERSIST slow_query_log_file=DEFAULT; 134RESET PERSIST slow_query_log_file; 135SET PERSIST slow_query_log=DEFAULT; 136SELECT @@global.block_encryption_mode; 137@@global.block_encryption_mode 138aes-128-ecb 139SELECT @@global.ft_boolean_syntax; 140@@global.ft_boolean_syntax 141+ -><()~*:""&| 142SELECT @@global.log_error_services; 143@@global.log_error_services 144log_filter_internal; log_sink_internal 145SELECT @@global.innodb_max_dirty_pages_pct; 146@@global.innodb_max_dirty_pages_pct 14780.990000 148SELECT VARIABLE_NAME, VARIABLE_SOURCE, MIN_VALUE, MAX_VALUE 149FROM performance_schema.variables_info 150WHERE VARIABLE_NAME IN ('block_encryption_mode', 151'ft_boolean_syntax','log_error_services','innodb_max_dirty_pages_pct') 152ORDER BY VARIABLE_NAME; 153VARIABLE_NAME VARIABLE_SOURCE MIN_VALUE MAX_VALUE 154block_encryption_mode PERSISTED 0 0 155ft_boolean_syntax PERSISTED 0 0 156innodb_max_dirty_pages_pct PERSISTED 0 99 157log_error_services PERSISTED 0 0 158SELECT @@global.innodb_fast_shutdown; 159@@global.innodb_fast_shutdown 1600 161SELECT @@global.innodb_default_row_format; 162@@global.innodb_default_row_format 163compact 164SELECT @@global.sql_mode; 165@@global.sql_mode 166ANSI_QUOTES 167SELECT @@global.innodb_checksum_algorithm; 168@@global.innodb_checksum_algorithm 169strict_crc32 170SELECT @@global.max_digest_length; 171@@global.max_digest_length 1721024 173SELECT @@global.max_connections; 174@@global.max_connections 175500 176SELECT @@global.innodb_flush_log_at_trx_commit; 177@@global.innodb_flush_log_at_trx_commit 1780 179SELECT @@global.join_buffer_size; 180@@global.join_buffer_size 181262144 182SELECT @@global.innodb_flush_sync; 183@@global.innodb_flush_sync 1841 185SELECT @@global.autocommit; 186@@global.autocommit 1870 188SELECT @@session.autocommit; 189@@session.autocommit 1900 191SELECT VARIABLE_NAME, VARIABLE_SOURCE, MIN_VALUE, MAX_VALUE 192FROM performance_schema.variables_info 193WHERE VARIABLE_NAME IN ('innodb_fast_shutdown','sql_mode', 194'innodb_default_row_format','max_digest_length','max_connections', 195'innodb_flush_log_at_trx_commit','innodb_flush_sync', 196'autocommit','innodb_checksum_algorithm') 197ORDER BY VARIABLE_NAME; 198VARIABLE_NAME VARIABLE_SOURCE MIN_VALUE MAX_VALUE 199autocommit PERSISTED 0 0 200innodb_checksum_algorithm PERSISTED 0 0 201innodb_default_row_format PERSISTED 0 0 202innodb_fast_shutdown PERSISTED 0 2 203innodb_flush_log_at_trx_commit PERSISTED 0 2 204innodb_flush_sync COMPILED 0 0 205max_connections PERSISTED 1 100000 206max_digest_length COMPILED 0 1048576 207sql_mode PERSISTED 0 0 208SELECT VARIABLE_NAME,VARIABLE_SOURCE 209FROM performance_schema.variables_info 210WHERE VARIABLE_SOURCE = 'LOGIN'; 211VARIABLE_NAME VARIABLE_SOURCE 212TRUNCATE TABLE mysql.general_log; 213--------------- general log --------------------------------------- 214SET @old_log_output= @@global.log_output; 215SET @old_general_log= @@global.general_log; 216SET @old_general_log_file= @@global.general_log_file; 217SET GLOBAL general_log_file = 'MYSQLTEST_VARDIR/log/persist_general.log'; 218SET PERSIST log_output = 'FILE,TABLE'; 219SET PERSIST general_log= 'ON'; 220SET PERSIST innodb_io_capacity=225; 221SET PERSIST innodb_flush_sync=DEFAULT; 222SELECT VARIABLE_NAME, VARIABLE_SOURCE 223FROM performance_schema.variables_info 224WHERE VARIABLE_NAME IN('innodb_io_capacity','innodb_flush_sync'); 225VARIABLE_NAME VARIABLE_SOURCE 226innodb_flush_sync DYNAMIC 227innodb_io_capacity DYNAMIC 228# SET PERSIST statement should not be bin logged. 229# Show binlog events 230include/show_binlog_events.inc 231Log_name Pos Event_type Server_id End_log_pos Info 232Show what is logged: 233------ rewrite ------ 234SELECT argument FROM mysql.general_log WHERE argument LIKE 'SET PERSIST %'; 235argument 236SET PERSIST general_log= 'ON' 237SET PERSIST innodb_io_capacity=225 238SET PERSIST innodb_flush_sync=DEFAULT 239------ done ------ 240SET PERSIST general_log_file = 'MYSQLTEST_VARDIR/log/persist_general.log'; 241RESET PERSIST general_log_file; 242SET PERSIST log_output=DEFAULT ,PERSIST general_log=DEFAULT; 243SET GLOBAL general_log_file= @old_general_log_file; 244SET GLOBAL general_log= @old_general_log; 245SET GLOBAL log_output= @old_log_output; 246SET PERSIST block_encryption_mode=DEFAULT, PERSIST ft_boolean_syntax=DEFAULT, 247PERSIST innodb_checksum_algorithm=DEFAULT, 248PERSIST log_error_services=DEFAULT, 249PERSIST innodb_max_dirty_pages_pct=DEFAULT; 250SET PERSIST innodb_fast_shutdown=DEFAULT,PERSIST innodb_default_row_format=DEFAULT, 251PERSIST sql_mode=DEFAULT,PERSIST innodb_flush_log_at_trx_commit=DEFAULT, 252PERSIST max_connections=default, PERSIST join_buffer_size=default, 253PERSIST innodb_flush_sync=DEFAULT,PERSIST innodb_io_capacity=DEFAULT, 254PERSIST log_bin_trust_function_creators=DEFAULT, PERSIST autocommit=DEFAULT; 255WL#9720 - SET PERSIST to capture user, host and timestamp 256show create table performance_schema.variables_info; 257Table Create Table 258variables_info CREATE TABLE "variables_info" ( 259 "VARIABLE_NAME" varchar(64) NOT NULL, 260 "VARIABLE_SOURCE" enum('COMPILED','GLOBAL','SERVER','EXPLICIT','EXTRA','USER','LOGIN','COMMAND_LINE','PERSISTED','DYNAMIC') DEFAULT 'COMPILED', 261 "VARIABLE_PATH" varchar(1024) DEFAULT NULL, 262 "MIN_VALUE" varchar(64) DEFAULT NULL, 263 "MAX_VALUE" varchar(64) DEFAULT NULL, 264 "SET_TIME" timestamp(6) NULL DEFAULT NULL, 265 "SET_USER" char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, 266 "SET_HOST" char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL 267) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 268CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1'; 269GRANT ALL ON *.* TO 'user1'@'localhost'; 270SET @@global.max_connections = 100; 271SET @@persist.event_scheduler=DEFAULT; 272SET PERSIST auto_increment_increment=10; 273SET PERSIST innodb_checksum_algorithm=strict_crc32; 274SELECT VARIABLE_NAME, VARIABLE_SOURCE, SET_USER, SET_HOST 275FROM performance_schema.variables_info 276WHERE VARIABLE_NAME IN ('max_connections','event_scheduler', 277'auto_increment_increment','innodb_checksum_algorithm'); 278VARIABLE_NAME VARIABLE_SOURCE SET_USER SET_HOST 279auto_increment_increment DYNAMIC user1 localhost 280event_scheduler DYNAMIC user1 localhost 281innodb_checksum_algorithm DYNAMIC user1 localhost 282max_connections DYNAMIC user1 localhost 283RESET PERSIST auto_increment_increment; 284RESET PERSIST innodb_checksum_algorithm; 285SELECT VARIABLE_NAME, VARIABLE_SOURCE, SET_USER, SET_HOST 286FROM performance_schema.variables_info 287WHERE VARIABLE_NAME IN ('auto_increment_increment', 288'innodb_checksum_algorithm'); 289VARIABLE_NAME VARIABLE_SOURCE SET_USER SET_HOST 290auto_increment_increment DYNAMIC user1 localhost 291innodb_checksum_algorithm DYNAMIC user1 localhost 292select @@global.max_connections into @saved_max_connections; 293select @@global.autocommit into @saved_autocommit; 294CREATE USER 'internal_proxied'@'%' IDENTIFIED BY 'proxy_password'; 295CREATE USER 'external_u1'@'%' IDENTIFIED WITH test_plugin_server AS 'internal_proxied'; 296CREATE USER 'external_u2'@'%' IDENTIFIED WITH test_plugin_server AS 'internal_proxied'; 297GRANT PROXY ON 'internal_proxied'@'%' TO 'external_u1'@'%','external_u2'@'%'; 298GRANT ALL ON *.* TO 'internal_proxied'@'%'; 299SET @@global.max_connections=50; 300SET @@global.autocommit=1; 301SELECT VARIABLE_NAME, SET_USER, SET_HOST, SET_TIME from 302performance_schema.variables_info where variable_name='max_connections' or 303variable_name='autocommit'; 304VARIABLE_NAME SET_USER SET_HOST SET_TIME 305autocommit external_u2 localhost # 306max_connections external_u1 localhost # 307# Cleanup 308drop USER 'user1'@'localhost'; 309drop USER 'internal_proxied'@'%'; 310drop USER 'external_u1'@'%'; 311drop USER 'external_u2'@'%'; 312SET GLOBAL max_connections = @saved_max_connections; 313SET GLOBAL autocommit = @saved_autocommit; 314# 315# Bug#25563891: OPTION SET BY !INCLUDE OR !INCLUDEDIR SHOWED AS 'COMPILED' 316# IN P_S.VARIABLES_INFO 317# 318SELECT VARIABLE_NAME, VARIABLE_SOURCE 319FROM performance_schema.variables_info WHERE VARIABLE_NAME IN 320('sort_buffer_size', 'max_connections', 'max_digest_length', 321'innodb_fast_shutdown', 'innodb_default_row_format', 'innodb_flush_log_at_trx_commit'); 322VARIABLE_NAME VARIABLE_SOURCE 323innodb_default_row_format DYNAMIC 324innodb_fast_shutdown DYNAMIC 325innodb_flush_log_at_trx_commit DYNAMIC 326max_connections DYNAMIC 327max_digest_length COMPILED 328sort_buffer_size COMPILED 329SELECT @@sort_buffer_size, @@max_connections, @@max_digest_length; 330@@sort_buffer_size @@max_connections @@max_digest_length 331262144 100 1024 332SELECT @@innodb_fast_shutdown, @@innodb_default_row_format, @@innodb_flush_log_at_trx_commit; 333@@innodb_fast_shutdown @@innodb_default_row_format @@innodb_flush_log_at_trx_commit 3341 dynamic 1 335SELECT VARIABLE_NAME, VARIABLE_SOURCE 336FROM performance_schema.variables_info WHERE VARIABLE_NAME IN 337('sort_buffer_size', 'max_connections', 'max_digest_length', 338'innodb_fast_shutdown', 'innodb_default_row_format', 'innodb_flush_log_at_trx_commit'); 339VARIABLE_NAME VARIABLE_SOURCE 340innodb_default_row_format EXPLICIT 341innodb_fast_shutdown EXPLICIT 342innodb_flush_log_at_trx_commit EXPLICIT 343max_connections EXPLICIT 344max_digest_length EXPLICIT 345sort_buffer_size EXPLICIT 346SELECT @@sort_buffer_size, @@max_connections, @@max_digest_length; 347@@sort_buffer_size @@max_connections @@max_digest_length 348314156 51 2024 349SELECT @@innodb_fast_shutdown, @@innodb_default_row_format, @@innodb_flush_log_at_trx_commit; 350@@innodb_fast_shutdown @@innodb_default_row_format @@innodb_flush_log_at_trx_commit 3511 redundant 2 352# Cleanup 353# Restart server with all defaults 354# restart 355# 356# BUG#26085774: SERVER CRASHES WHEN STARTED USING CORRUPTED MYSQLD-AUTO.CNF 357# 358# this is the wrong format with event_scheduler value not being string 359# server should fail to start 360# on windows even though server fails to start return code is 0, thus expecting error to be 0 or 1 361# this is the wrong format with binlog_gtid_simple_recovery value not being string 362# server should fail to start 363# this is the wrong format with no ',' between key/value pair 364# server should fail to start 365# this is the wrong format with wrong static variables group name 366# server should fail to start 367# this is the wrong format with group name 368# server should fail to start 369# start server with all defaults 370# restart 371# 372# Bug#26100122: SERVER CRASHES WHEN SET PERSIST CALLS WITH A LONG STATEMENT 373# 374set @a=repeat('A',2000); 375SET PERSIST init_connect=@a;; 376set @b=repeat('A',24000); 377SET PERSIST init_connect=@b;; 378# Cleanup 379SET GLOBAL init_connect=default; 380RESET PERSIST; 381# 382# Bug#25677422: SET_TIME IN VARIABLES_INFO REFLECTS RESTART TIME FOR 383# PERSISTED VARIABLES 384# 385RESET PERSIST; 386CREATE USER bug25677422; 387GRANT ALL ON *.* TO bug25677422; 388SET PERSIST sort_buffer_size=256000; 389SET PERSIST max_heap_table_size=999424, slave_net_timeout=124; 390SET PERSIST_ONLY innodb_read_io_threads= 16; 391SET PERSIST long_query_time= 8.3452; 392SET PERSIST_ONLY innodb_log_file_size= 4194304, ft_query_expansion_limit= 80; 393SELECT VARIABLE_NAME, VARIABLE_SOURCE, SET_USER 394FROM performance_schema.variables_info WHERE VARIABLE_NAME IN 395('sort_buffer_size', 'max_heap_table_size', 'slave_net_timeout', 396'long_query_time', 'innodb_read_io_threads', 'innodb_log_file_size', 397'ft_query_expansion_limit'); 398VARIABLE_NAME VARIABLE_SOURCE SET_USER 399ft_query_expansion_limit COMPILED root 400innodb_log_file_size EXPLICIT root 401innodb_read_io_threads COMPILED bug25677422 402long_query_time DYNAMIC root 403max_heap_table_size DYNAMIC bug25677422 404slave_net_timeout DYNAMIC bug25677422 405sort_buffer_size DYNAMIC bug25677422 406SELECT VARIABLE_NAME, VARIABLE_SOURCE, SET_USER 407FROM performance_schema.variables_info WHERE VARIABLE_NAME IN 408('sort_buffer_size', 'max_heap_table_size', 'slave_net_timeout', 409'long_query_time', 'innodb_read_io_threads', 'innodb_log_file_size', 410'ft_query_expansion_limit'); 411VARIABLE_NAME VARIABLE_SOURCE SET_USER 412ft_query_expansion_limit COMPILED root 413innodb_log_file_size EXPLICIT root 414innodb_read_io_threads COMPILED bug25677422 415long_query_time DYNAMIC root 416max_heap_table_size DYNAMIC bug25677422 417slave_net_timeout DYNAMIC bug25677422 418sort_buffer_size DYNAMIC bug25677422 419# Restart server 420# restart 421SELECT VARIABLE_NAME FROM performance_schema.variables_info WHERE 422VARIABLE_SOURCE = 'PERSISTED'; 423VARIABLE_NAME 424ft_query_expansion_limit 425innodb_log_file_size 426innodb_read_io_threads 427long_query_time 428max_heap_table_size 429slave_net_timeout 430sort_buffer_size 431SELECT VARIABLE_NAME, VARIABLE_SOURCE, SET_USER 432FROM performance_schema.variables_info WHERE VARIABLE_NAME IN 433('sort_buffer_size', 'max_heap_table_size', 'slave_net_timeout', 434'long_query_time', 'innodb_read_io_threads', 'innodb_log_file_size', 435'ft_query_expansion_limit'); 436VARIABLE_NAME VARIABLE_SOURCE SET_USER 437ft_query_expansion_limit PERSISTED root 438innodb_log_file_size PERSISTED root 439innodb_read_io_threads PERSISTED bug25677422 440long_query_time PERSISTED root 441max_heap_table_size PERSISTED bug25677422 442slave_net_timeout PERSISTED bug25677422 443sort_buffer_size PERSISTED bug25677422 444SELECT VARIABLE_NAME, VARIABLE_SOURCE, SET_USER 445FROM performance_schema.variables_info WHERE VARIABLE_NAME IN 446('sort_buffer_size', 'max_heap_table_size', 'slave_net_timeout', 447'long_query_time', 'innodb_read_io_threads', 'innodb_log_file_size', 448'ft_query_expansion_limit'); 449VARIABLE_NAME VARIABLE_SOURCE SET_USER 450ft_query_expansion_limit PERSISTED root 451innodb_log_file_size PERSISTED root 452innodb_read_io_threads PERSISTED bug25677422 453long_query_time PERSISTED root 454max_heap_table_size PERSISTED bug25677422 455slave_net_timeout PERSISTED bug25677422 456sort_buffer_size PERSISTED bug25677422 457DROP USER bug25677422; 458RESET PERSIST; 459SET GLOBAL sort_buffer_size=DEFAULT, max_heap_table_size=DEFAULT, 460slave_net_timeout=DEFAULT, long_query_time=DEFAULT; 461# Restart server with defaults 462# restart 463SELECT 'END OF TEST'; 464END OF TEST 465END OF TEST 466