|
default |
small |
medium |
large |
huge |
InnoDB-heavy |
binlog_cache_size |
32768 |
32768 |
32768 |
32768 |
32768 |
1048576 |
binlog_format |
STATEMENT |
STATEMENT |
MIXED |
MIXED |
STATEMENT |
MIXED |
bulk_insert_buffer_size |
8388608 |
8388608 |
8388608 |
8388608 |
8388608 |
67108864 |
expire_logs_days |
10 |
0 |
0 |
0 |
0 |
0 |
innodb_additional_mem_pool_size |
1048576 |
1048576 |
1048576 |
1048576 |
1048576 |
16777216 |
innodb_buffer_pool_size |
8388608 |
8388608 |
8388608 |
8388608 |
8388608 |
2147483648 |
innodb_lock_wait_timeout |
50 |
50 |
50 |
50 |
50 |
120 |
innodb_log_buffer_size |
1048576 |
1048576 |
1048576 |
1048576 |
1048576 |
8388608 |
innodb_log_file_size |
5242880 |
5242880 |
5242880 |
5242880 |
5242880 |
268435456 |
innodb_log_files_in_group |
2 |
2 |
2 |
2 |
2 |
3 |
innodb_thread_concurrency |
8 |
8 |
8 |
8 |
8 |
16 |
join_buffer_size |
131072 |
131072 |
131072 |
131072 |
131072 |
8388608 |
key_buffer_size |
16777216 |
16384 |
16777216 |
268435456 |
402653184 |
33554432 |
log_bin |
OFF |
OFF |
ON |
ON |
ON |
ON |
log_error |
/var/log/mysql/error.log |
|
|
|
|
|
log_slow_queries |
OFF |
OFF |
OFF |
OFF |
OFF |
ON |
long_query_time |
10 |
10 |
10 |
10 |
10 |
2 |
max_allowed_packet |
16777216 |
1048576 |
1048576 |
1048576 |
1048576 |
16777216 |
max_binlog_size |
104857600 |
1073741824 |
1073741824 |
1073741824 |
1073741824 |
1073741824 |
max_connections |
151 |
151 |
151 |
151 |
151 |
100 |
max_heap_table_size |
16777216 |
16777216 |
16777216 |
16777216 |
16777216 |
67108864 |
myisam_max_sort_file_size |
2146435072 |
2146435072 |
2146435072 |
2146435072 |
2146435072 |
10737418240 |
myisam_recover_options |
BACKUP |
OFF |
OFF |
OFF |
OFF |
DEFAULT |
myisam_sort_buffer_size |
8388608 |
8388608 |
8388608 |
67108864 |
67108864 |
134217728 |
net_buffer_length |
16384 |
2048 |
8192 |
16384 |
16384 |
16384 |
open_files_limit |
1024 |
1024 |
1024 |
1024 |
1185 |
4206 |
pseudo_thread_id |
41 |
44 |
43 |
43 |
43 |
34 |
query_cache_limit |
1048576 |
1048576 |
1048576 |
1048576 |
1048576 |
2097152 |
query_cache_size |
16777216 |
0 |
0 |
16777216 |
33554432 |
67108864 |
read_buffer_size |
131072 |
262144 |
262144 |
1048576 |
2097152 |
2097152 |
read_rnd_buffer_size |
262144 |
262144 |
524288 |
4194304 |
8388608 |
16777216 |
server_id |
0 |
1 |
1 |
1 |
1 |
1 |
slow_query_log |
OFF |
OFF |
OFF |
OFF |
OFF |
ON |
sort_buffer_size |
2097144 |
65536 |
524288 |
1048576 |
2097152 |
8388608 |
table_open_cache |
64 |
4 |
64 |
256 |
512 |
2048 |
thread_cache_size |
8 |
0 |
0 |
8 |
8 |
8 |
thread_stack |
196608 |
131072 |
196608 |
196608 |
196608 |
196608 |
timestamp |
1306910479 |
1306909701 |
1306909821 |
1306909975 |
1306910049 |
1306910802 |
tmp_table_size |
16777216 |
16777216 |
16777216 |
16777216 |
16777216 |
67108864 |
version |
5.1.41-3ubuntu12.10 |
5.1.41-3ubuntu12.10 |
5.1.41-3ubuntu12.10-log |
5.1.41-3ubuntu12.10-log |
5.1.41-3ubuntu12.10-log |
5.1.41-3ubuntu12.10-log |
|
|
|
|
|
|
|