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!

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:
    70
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Problem resolved after firewall disabled! so strange and why?!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    334
    Likes Received:
    14
    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:
    3
    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
  7. Inigo Montoya

    Inigo Montoya Registered

    Joined:
    May 16, 2018
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    I have been trying to install mysqlmymonlite.sh on my server. When I get to the point of running the tool I get the following result:
    Code:
    [root@host tool]# cp centos/* /root/tool
    cp: overwrite ‘/root/tool/config.ini’? y
    cp: overwrite ‘/root/tool/mysqlmymonlite.sh’? y
    [root@host tool]# ./mysqlmymonlite.sh
    awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
    awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
    awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
    
    The server does have the Engintron nginx installed, but there is nothing in the location specified. After those error messages the script just hangs, and requires a ctrl-c to break out. I have tried both the centos and centos_whm versions of the script with the same result. Is this script incompatible with Engintron nginx?
     
  8. ronaldst

    ronaldst Well-Known Member

    Joined:
    Feb 22, 2016
    Messages:
    61
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Norway
    cPanel Access Level:
    Root Administrator
    I'm getting this error when running ./mysqlmymonlite for the first time.

    Code:
    The content of '/home/.cpan/build/DBD-mysql-4.047-4/META.json' is not a HASH reference. Cannot use it.
    Configuring C/CA/CAPTTOFU/DBD-mysql-4.047.tar.gz with Makefile.PL
    Can't locate Devel/CheckLib.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 12.
    BEGIN failed--compilation aborted at Makefile.PL line 12.
    No 'Makefile' created  CAPTTOFU/DBD-mysql-4.047.tar.gz
      /usr/bin/perl Makefile.PL OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
    ----------------------------------------------------------
    Installation complete. Exiting script...
    Please re-run ./mysqlmymonlite.sh again
    Re-running the script gives the same error.

    This is on a fresh installed server. What can I do to solve this?
     
  9. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    334
    Likes Received:
    14
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    haven't tested with Engintron nginx so definitely not compatible

    will have to check myself as it has been a while and alot of cpanel updates have occurred

    are you using centos 6 or 7 ?
     
    #69 eva2000, Sep 18, 2018
    Last edited: Sep 18, 2018
  10. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    334
    Likes Received:
    14
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    if you run this first
    Code:
    perl -MCPAN -e 'install Devel::CheckLib'
    
    then re-run mysqlmymonlite.sh does it help ?
     
  11. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    334
    Likes Received:
    14
    Trophy Points:
    318
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    know a bit late but what's output for these 2 commands
    Code:
    which nginx
    nginx -t
    
     
    Infopro likes this.
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