MySQL tuner suggestions question

I have run the msql tuner and got the below suggestion :


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 user@% to user@SpecificDNSorIp
    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

cPanelMichael

January 19, 2018 14:50

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):

Rajesh Chauhan

November 20, 2018 04:33

I have used official MySQLTuner as suggested by Micheal worked fine for me

MySQL tuner suggestions question

Comments

Didn't find what you were looking for?