http://itbg.davnozdu.ru/?p=486
Минимальный конфиг [my.cnf]:
# Main MySQL server options [mysqld] port = 3306 socket = /var/run/mysqld/mysqld.sock # # No locking at all! skip-locking # # Set internal buffers, caches and stacks very low key_buffer = 16K max_allowed_packet = 16K table_cache = 1 sort_buffer_size = 16K read_buffer_size = 16K read_rnd_buffer_size = 1K net_buffer_length = 1K thread_stack = 16K # # Don’t listen on a TCP/IP port at all. # Will still work provided all access is done via localhost skip-networking server-id = 1 # # Skip Berkley and Inno DB types skip-bdb skip-innodb # # Set the query cache low query_cache_limit = 1048576 query_cache_size = 1048576 query_cache_type = 1 # # Set various memory limits very low, disable memory-hogging extras [mysqldump] quick max_allowed_packet = 16K [mysql] no-auto-rehash [isamchk] key_buffer = 16K sort_buffer_size = 16K [myisamchk] key_buffer = 16K sort_buffer_size = 16K [mysqlhotcopy] interactive-timeout
Оптимизированный конфиг:
[mysqld] datadir=/var/lib/mysql socket=/tmp/mysql/mysql.sock user=mysql port = 3306 bind-address = 127.0.0.1 # No locking at all! skip-locking # Set internal buffers, caches and stacks very low key_buffer = 16K max_allowed_packet = 16K table_cache = 1 sort_buffer_size = 16K read_buffer_size = 16K read_rnd_buffer_size = 1K net_buffer_length = 1K thread_stack = 16K # Don’t listen on a TCP/IP port at all. # Will still work provided all access is done via localhost skip-networking server-id = 1 # Skip Berkley and Inno DB types skip-bdb skip-innodb # Set the query cache low query_cache_limit = 500K query_cache_size = 3M query_cache_type = 1 # Set various memory limits very low, disable memory-hogging extras [mysqldump] quick max_allowed_packet = 16K [mysql] no-auto-rehash [isamchk] key_buffer = 16K sort_buffer_size = 16K [myisamchk] key_buffer = 16K sort_buffer_size = 16K [mysqlhotcopy] interactive-timeout