MySQL/Optimization: Difference between revisions
< MySQL
(Created page with "MySQL memory optimization memory = key_buffer + (sort_buffer_size + read_buffer_size) * max_connections ie. 64 + (1 + 1) * 200 = 464MB [mysqld] set-variable = max_connecti...") |
(No difference)
|
Latest revision as of 20:56, 9 March 2016
MySQL memory optimization
memory = key_buffer + (sort_buffer_size + read_buffer_size) * max_connections
ie. 64 + (1 + 1) * 200 = 464MB
[mysqld] set-variable = max_connections = 500