Difference between revisions of "System/MySQL"
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...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | == Replication == | ||
| + | |||
| + | For replication configuration, see [[System/MySQL/Replication]] | ||
| + | |||
== Configuration == | == Configuration == | ||
| Line 18: | Line 22: | ||
</pre> | </pre> | ||
| − | + | Change max connections on the fly: | |
| + | |||
| + | SET GLOBAL max_connections = 500; | ||
Latest revision as of 10:27, 26 August 2014
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;
