DX Infrastructure Management

Tech Tip: MySQL 5.6 Performance 

11-11-2015 12:29 PM

In previous versions of NetQoS applications we used MySQL 5.1.

We made some changes in my.ini to improve performance that may not be relevant to the new MySQL 5.6 that has been installed.

 

While the changes are similar the numbers may have changed:

 

These changes are for MySQL 5.6

 

The following can be changed in the my.ini file to help deal with performance issues in MySQL56:

 

key_buffer_size=192M (Default 384M)
read_buffer_size=8M (Default 16M)
read_rnd_buffer_size=8M (Default 16M)
sort_buffer_size=32M (Default 32M)

 

The my.ini file is located in the \CA\MySQL\ directory.

 

You will need to restart MySQL after making these changes.

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

10-03-2016 01:57 PM

Hello,

 

I am on  Leave from 30thSep 2016 to 7th Oct 2016. I have limited access to Phone and mail. Any Urgent matters please call ENTIIS office @ +65 6283.7378 . Else I will respond to your mail when I get chance to respond.

 

Thanks

Rajesh

+65 92380924

Related Entries and Links

No Related Resource entered.