System/MySQL

From LunaSys

Revision as of 11:33, 10 November 2012 by Eadam (talk | contribs) (Created page with "== Configuration == <pre> ... sort_buffer_size = 1M query_cache_limit = 4M query_cache_size = 32M ... # INNODB innodb_file_per_table = 1 innodb_buffer_pool_s...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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]

Retrieved from "http://wiki.lunasys.fr/mediawiki/index.php?title=System/MySQL&oldid=214"