Difference between revisions of "System/MySQL"

From LunaSys
Jump to navigation Jump to search
Line 1: Line 1:
 +
== Replication ==
 +
 +
For replication configuration, see [[System/MySQL/Replication]]
 +
 
== Configuration ==
 
== Configuration ==
  
Line 17: Line 21:
 
...
 
...
 
</pre>
 
</pre>
 
For replication configuration, see [[System/MySQL/Replication]]
 

Revision as of 11:48, 21 December 2012

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