patternsqlMinor
What is the best use of memory in MySQL?
Viewed 0 times
thewhatmysqlmemoryusebest
Problem
I have a MySql server with 2Gb of memory. What's the best configuration to use then with best results? How can I "distribute" this memory fine to MySql server?
Solution
You can alter some values in your /etc/my.cnf file.
Some important ones are innodb_buffer_pool_size (assuming you are using InnoDB) and also query_cache_size. You should try to set the innodb_buffer_pool_size to 10% larger than the size of your data if you can. The default of 8MB really is woeful for performance.
Some important ones are innodb_buffer_pool_size (assuming you are using InnoDB) and also query_cache_size. You should try to set the innodb_buffer_pool_size to 10% larger than the size of your data if you can. The default of 8MB really is woeful for performance.
Context
StackExchange Database Administrators Q#799, answer score: 3
Revisions (0)
No revisions yet.