MySQL Variables

  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