Settings
Please refer to dev.mysql.com/doc/refman/5.1/en/using-system-variables.html for detailed information.
|
1 |
SHOW VARIABLES; |
|
1 2 |
SHOW VARIABLES LIKE 'max_join_size'; SHOW SESSION VARIABLES LIKE 'max_join_size'; |
|
1 2 |
SHOW VARIABLES LIKE '%size%'; SHOW GLOBAL VARIABLES LIKE '%size%'; |
|
1 2 3 4 5 6 7 8 9 |
SET sort_buffer_size=10000; SET @@local.sort_buffer_size=10000; SET GLOBAL sort_buffer_size=1000000, SESSION sort_buffer_size=1000000; SET @@sort_buffer_size=1000000; SET @@global.sort_buffer_size=1000000, @@local.sort_buffer_size=1000000; SET GLOBAL max_allowed_packet=16M; SET GLOBAL max_allowed_packet=16*1024*1024; SET max_join_size=DEFAULT; SET @@session.max_join_size=@@global.max_join_size; |
|
1 |
SELECT @@global.sql_mode, @@session.sql_mode, @@sql_mode; |
|
1 2 |
mysql --max_allowed_packet=16M mysql --max_allowed_packet=16*1024*1024 |
Using RMAN for...
12 March 2019