System/MySQL

Replication

For replication configuration, see System/MySQL/Replication

Configuration

...
sort_buffer_size       = 1M
query_cache_limit      = 4M
query_cache_size       = 32M
...
# INNODB
innodb_file_per_table = 1
innodb_buffer_pool_size = 128M
innodb_flush_log_at_trx_commit = 1
...
# LOG
log_slow_queries        = /var/log/mysql/mysql-slow.log
long_query_time = 2
...

Change max connections on the fly:

SET GLOBAL max_connections = 500;