Table of Contents
MySQL Configuration
Update Runtime Configuration
For MB sizes, use bc 1024^2 * <num MB>
Set key_buffer_size to 16MB
SET GLOBAL key_buffer_size = 16777216;
Set max_allowed_packet to 1MB
SET GLOBAL max_allowed_packet = 1048576;
Set myisam_sort_buffer_size to 64MB
SET @@myisam_sort_buffer_size = 67108864;
Default Configuration Files
Small
# This is for a system with little memory (<= 64M) where MySQL is only used # from time to time and it's important that the mysqld daemon # doesn't use much resources. [mysqld] port = 3306 socket = /var/run/mysqld/mysqld.sock skip-locking key_buffer_size = 16K max_allowed_packet = 1M table_open_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 128K server-id = 1
Medium
# This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) [mysqld] port = 3306 socket = /var/run/mysqld/mysqld.sock skip-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log-bin=mysql-bin binlog_format=mixed server-id = 1
Large
# This is for a large system with memory = 512M where the system runs mainly # MySQL. [mysqld] port = 3306 socket = /var/run/mysqld/mysqld.sock skip-locking key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 16M thread_concurrency = 8 log-bin=mysql-bin binlog_format=mixed server-id = 1
Default
key_buffer_size = 8M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 2M read_buffer_size = 128K read_rnd_buffer_size = 256K myisam_sort_buffer_size = 8M thread_cache_size = 0 query_cache_size= 0 thread_concurrency = 10
