How can I address MySQL51 performance issues?

Document ID : KB000020777
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary:

If you are experiencing MySql performance issues, you can edit the \Netqos\Mysql51\  my.ini file with the settings provided in this document to increase performance. 

These changes are for MySQL 5.1 only.

 

Instructions:  

1. Make a backup copy of your existing my.ini file located in the <Install Directory>\Netqos\MySql51 directory.

2. Edit the existing my.ini file in notepad and make the following changes:

key_buffer_size=128M (default 384)

read_buffer_size=1M (default 16) 

read_rnd_buffer_size=1M (default 16)

3. You will need to restart the Netqos MySQL51 service after making these changes.