System/MySQL

From LunaSys
Revision as of 11:34, 10 November 2012 by Eadam (talk | contribs) (→‎Configuration)
Jump to navigation Jump to search

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
...

For replication configuration, see System/MySQL/Replication