Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL tuner suggestions question

Discussion in 'Database Discussion' started by Sujoy Dhar, Jan 19, 2018.

Tags:
  1. Sujoy Dhar

    Sujoy Dhar Active Member

    Joined:
    Jul 24, 2016
    Messages:
    31
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    India
    cPanel Access Level:
    Root Administrator
    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 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 [URL='https://github.com/mysql/mysql-sys']GitHub - mysql/mysql-sys: The MySQL sys schema[/URL]
    
    
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,323
    Likes Received:
    1,851
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice