Sign-up our Newsletter  Register on our LinkedIn  Follow us on Twitter  Check out our Facebook  Follow us on Google+
Follow

My MySql server's performances are degrading with time. Is there a way I can improve this?

Depending on your setup, you may need to polish your MySql server for better performances and scalability.
It's a good idea to run the MySql Server Instance Config Wizard (delivered with MySql) and follow the instructions. This will set the best settings for your configuration.


In addition/Alternatively, you can manually set a few parameters (in my.ini) such as:
[mysqld]
max_connections=256 (can be increased if needed)
query_cache_size=20000000 (which means 20MBytes)
thread_cache_size=32
innodb_buffer_pool_size=128M (<75% of the total addressable RAM on dedicated database server)
innodb_thread_concurrency=32



From mysql admin in startup variables >> innodb >> increase mem pools size to 30MBytes inside startup variables change >> general parameters >> memory usage >> KEY BUFFER to 64Bytes

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.