Sujoy Dhar

Well-Known Member
Jul 24, 2016
48
7
8
India
cPanel Access Level
Root Administrator
Twitter
I have run the msql tuner and got the below suggestion :
Code:
General recommendations:
    /var/lib/mysql/ns533067.ip-149-56-242.net.err is > 32Mb, you should analyze                                                                                                                                                              why or implement a rotation log strategy such as logrotate!
    Control warning line(s) into /var/lib/mysql/ns533067.ip-149-56-242.net.err f                                                                                                                                                             ile
    Control error line(s) into /var/lib/mysql/ns533067.ip-149-56-242.net.err fil                                                                                                                                                             e
    Restrict Host for [email protected]% to [email protected]
    MySQL started within last 24 hours - recommendations may be inaccurate
    Configure your accounts with ip or subnets only, then update your configurat                                                                                                                                                             ion with skip-name-resolve=1
    Temporary table size is already large - reduce result set size
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Consider installing Sys schema from [URL='https://github.com/mysql/mysql-sys']GitHub - mysql/mysql-sys: The MySQL sys schema[/URL]
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello,

The following thread is a good place to start when optimizing your MySQL configuration (it looks like a different tuner than the one you used):

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Additionally, it's generally advised to let MySQL run at least 24 hours before running a tuning script to ensure the results are accurate.

Thank you.