7
7
set @my_server_id =@@global.server_id;
8
8
set @my_storage_engine =@@global.storage_engine;
9
9
set @my_myisam_sort_buffer_size =@@global.myisam_sort_buffer_size;
10
set @my_tx_isolation =@@global.tx_isolation;
11
12
select @test, @`test`, @TEST, @`TEST`, @"teSt";
12
13
@test @`test` @TEST @`TEST` @"teSt"
585
586
set global thread_cache_size =@my_thread_cache_size;
586
587
ERROR HY000: Unknown system variable 'thread_cache_size'
587
588
set global myisam_sort_buffer_size =@my_myisam_sort_buffer_size;
589
SHOW GLOBAL VARIABLES LIKE 'max_join_size';
591
max_join_size 2147483647
592
SHOW LOCAL VARIABLES LIKE 'max_join_size';
595
set GLOBAL bulk_insert_buffer_size=DEFAULT;
596
set GLOBAL join_buffer_size=DEFAULT;
597
set GLOBAL max_allowed_packet=DEFAULT;
598
set GLOBAL max_connect_errors=DEFAULT;
599
set GLOBAL max_heap_table_size=DEFAULT;
600
set GLOBAL max_join_size=DEFAULT;
601
set GLOBAL max_sort_length=DEFAULT;
602
set GLOBAL max_write_lock_count=DEFAULT;
603
set GLOBAL myisam_sort_buffer_size=DEFAULT;
604
set GLOBAL mysql_protocol_buffer_length=DEFAULT;
605
set GLOBAL read_buffer_size=DEFAULT;
606
set GLOBAL read_rnd_buffer_size=DEFAULT;
607
set GLOBAL server_id=DEFAULT;
608
set GLOBAL sort_buffer_size=DEFAULT;
609
set GLOBAL table_open_cache=DEFAULT;
610
set GLOBAL storage_engine= @my_storage_engine;
611
set GLOBAL tmp_table_size=DEFAULT;
612
set GLOBAL tx_isolation= @my_tx_isolation;
613
set SESSION bulk_insert_buffer_size=DEFAULT;
614
set SESSION join_buffer_size=DEFAULT;
615
set SESSION max_allowed_packet=DEFAULT;
616
set SESSION max_heap_table_size=DEFAULT;
617
set SESSION max_join_size=DEFAULT;
618
set SESSION max_sort_length=DEFAULT;
619
set SESSION read_buffer_size=DEFAULT;
620
set SESSION read_rnd_buffer_size=DEFAULT;
621
set SESSION sort_buffer_size=DEFAULT;
622
set SESSION sql_big_selects=DEFAULT;
623
set SESSION sql_buffer_result=DEFAULT;
624
set SESSION sql_select_limit=DEFAULT;
625
set SESSION sql_warnings=DEFAULT;
626
set SESSION storage_engine= @my_storage_engine;
627
set SESSION tmp_table_size=DEFAULT;
628
set SESSION tx_isolation= @my_tx_isolation;
588
629
show global variables where variable_name='table_definition_cache' or Variable_name='table_lock_wait_timeout';
589
630
Variable_name Value
590
631
table_definition_cache #