Difference between revisions of "System/MySQL"

From LunaSys
Jump to navigation Jump to search
(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...")
 
Line 18: Line 18:
 
</pre>
 
</pre>
  
For replication configuration, see [System/MySQL/Replication]
+
For replication configuration, see [[System/MySQL/Replication]]

Revision as of 11:34, 10 November 2012

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