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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL tuner suggestions question

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

Tags:
  1. Sujoy Dhar

    Sujoy Dhar Active Member

    Joined:
    Jul 24, 2016
    Messages:
    29
    Likes Received:
    5
    Trophy Points:
    3
    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:
    42,802
    Likes Received:
    1,714
    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.
     
Loading...

Share This Page