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
My MySql server's performances are degrading with time. Is there a way I can improve this?
Have more questions? Submit a request
Please sign in to leave a comment.
0 Comments