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.

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Discussion in 'Workarounds and Optimization' started by eva2000, Apr 5, 2012.

Tags:
  1. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    66
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    user/pass is ok, all others mysqlmymonlite switch working fine.
    Just i have problem with ./mysqlmymonlite.sh mysqltuner
    Im confused!
     
  2. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    66
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Problem resolved after firewall disabled! so strange and why?!
     
  3. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    66
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    I think mysqltuner will be download on server after "./mysqlmymonlite.sh mysqltuner"
    Its not good idea for local and intranet servers.
     
  4. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    330
    Likes Received:
    13
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    ah i see so you on an intranet ! explains the problem.
     
    lambov likes this.
  5. Binay Kumar

    Binay Kumar Registered

    Joined:
    Aug 25, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Any one who help me about the above issue.
     
  6. Anthony Parsons

    Anthony Parsons Active Member

    Joined:
    Aug 4, 2016
    Messages:
    26
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Australia
    cPanel Access Level:
    Root Administrator
    What do these mean as recommendations, in relation to how my.cnf should be structured?
    Code:
    General recommendations:
        Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
        Increase table_open_cache gradually to avoid file descriptor limits
        Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
        Beware that open_files_limit (10000) variable
        should be greater than table_open_cache ( 256)
    Variables to adjust:
        query_cache_size (> 10M)
        table_open_cache (> 256)
        innodb_buffer_pool_size (>= 3G) if possible.
        innodb_buffer_pool_instances (=1)
    
     
    #66 Anthony Parsons, Sep 8, 2016
    Last edited by a moderator: Sep 8, 2016
Loading...

Share This Page