Help Optimizing MySQL

[elis2]

hi

me install server cpanel.
who uptimize mysql?

centos 6.9 64bit
ram:10gb ddr4
cori7 6700


plz hellp uptimize my.cnf

thank you
Best Regards

 

[24x7server]

Hi,

The MySQL optimization is purely based on current performance, so you will have to check how MySQL is currently behaving on your server..

Is this a new server with newy installed cPanel?
How many accounts and databases you have currentl on the server?

 

[cPanelMichael]

Hello,

The following thread is a good place to start when optimizing your MySQL configuration:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.