search cancel

How can I address MySQL51 performance issues?

book

Article ID: 20777

calendar_today

Updated On:

Products

CA Application Delivery Analysis MTP (NetQoS / ADA) CA Infrastructure Performance CA NetVoyant (NetQoS / NV) CA eHealth

Issue/Introduction

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.

Environment

Release: RAIB1H99000-9.1-Network Flow Analysis-Interface Bundle-Hardware
Component: