MySQL/Optimization

From Omnia
< MySQL
Revision as of 20:56, 9 March 2016 by Kenneth (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

Retrieved from "https://aznot.com/index.php?title=MySQL/Optimization&oldid=3012"