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.

Why was mysqltuner.pl removed (again)

Discussion in 'Workarounds and Optimization' started by DomineauX, Apr 9, 2014.

  1. DomineauX

    DomineauX Well-Known Member
    PartnerNOC

    Joined:
    Apr 12, 2003
    Messages:
    414
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    I just noticed that the mysqltuner.pl script was removed with the 11.42.1.5 update that just installed to release tier:


    This was previously done as well and then included again in 11.38:

    Please stop removing this as it is very handy and nice to not have to install it ourselves.
     
  2. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    322
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    Just download it manually ;)

    I use a modified version of mysqltuner.pl for mysqlmymonlite.sh

    You can download it if you want at http://mysqlmymon.com/mysqltuner/mysqltuner.pl

    with MariaDB 5.5.36
    Code:
    ./mysqltuner.pl            
    
     >>  MySQLTuner 1.3.0 mod - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Modified by George Liu (eva2000) at http://vbtechsupport.com/
     >>  Run with '--help' for additional options and output filtering
    [OK] Currently running supported MySQL version 5.5.36-MariaDB
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: -ARCHIVE +Aria +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM 
    [--] Data in InnoDB tables: 95M (Tables: 1)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [OK] Total fragmented tables: 0
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 5m 35s (154K q [462.101 qps], 24 conn, TX: 114M, RX: 173M)
    [--] Reads / Writes: 29% / 71%
    [--] Total buffers: 176.0M global + 800.0K per thread (300 max threads)
    [OK] Maximum possible memory usage: 410.4M (41% of installed RAM)
    [OK] Slow queries: 0% (0/154K)
    [OK] Highest usage of available connections: 0% (2/300)
    [OK] Key buffer size / total MyISAM indexes: 32.0M/99.0K
    [!!] Query cache efficiency: 0.0% (0 cached / 45K selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2 sorts)
    [OK] Temporary tables created on disk: 0% (0 on disk / 13 total)
    [OK] Thread cache hit rate: 91% (2 created / 24 connections)
    [OK] Table cache hit rate: 210% (42 open / 20 opened)
    [OK] Open file limit used: 0% (51/8K)
    [OK] Table locks acquired immediately: 100% (154K immediate / 154K locks)
    [!!] InnoDB  buffer pool / data size: 48.0M/95.7M
    [OK] InnoDB log waits: 0
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        MySQL started within last 24 hours - recommendations may be inaccurate
        Enable the slow query log to troubleshoot bad queries.
        Do not forget to disable slow query logging after troubleshooting
       - For MySQL 5.0 http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
       - For MySQL 5.1 http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
       - For MySQL 5.5 http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html
       - For MySQL 5.6 http://dev.mysql.com/doc/refman/5.6/en/slow-query-log.html
    
    Variables to adjust:
        query_cache_limit (> 512K, or use smaller result sets)
        innodb_buffer_pool_size (>= 95M)
    
    with MariaDB 10.0.10

    Code:
    ./mysqltuner.pl 
    
     >>  MySQLTuner 1.3.0 mod - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Modified by George Liu (eva2000) at http://vbtechsupport.com/
     >>  Run with '--help' for additional options and output filtering
    [!!] Currently running unsupported MySQL version 10.0.10-MariaDB
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: -ARCHIVE +Aria +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MyISAM 
    [--] Data in MyISAM tables: 31M (Tables: 863)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
    [--] Data in MEMORY tables: 0B (Tables: 8)
    [!!] InnoDB is enabled but isn't being used
    [!!] Total fragmented tables: 10
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 20s (10 q [0.500 qps], 7 conn, TX: 16K, RX: 1K)
    [--] Reads / Writes: 100% / 0%
    [--] Total buffers: 152.0M global + 800.0K per thread (300 max threads)
    [OK] Maximum possible memory usage: 386.4M (20% of installed RAM)
    [OK] Slow queries: 0% (0/10)
    [OK] Highest usage of available connections: 0% (1/300)
    [OK] Key buffer size / total MyISAM indexes: 32.0M/7.4M
    [!!] Query cache efficiency: 0.0% (0 cached / 4 selects)
    [OK] Query cache prunes per day: 0
    [OK] Temporary tables created on disk: 0% (0 on disk / 2 total)
    [OK] Thread cache hit rate: 85% (1 created / 7 connections)
    [OK] Table cache hit rate: 100% (63 open / 0 opened)
    [OK] Open file limit used: 0% (26/8K)
    [OK] Table locks acquired immediately: 100% (73 immediate / 73 locks)
    [OK] InnoDB log waits: 0
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Add skip-innodb to MySQL configuration to disable InnoDB
        Run OPTIMIZE TABLE to defragment tables for better performance
        MySQL started within last 24 hours - recommendations may be inaccurate
    
    Variables to adjust:
        query_cache_limit (> 512K, or use smaller result sets)
    
    with WebScaleSQL MySQL 5.6.17

    Code:
    ./mysqltuner.pl --port=3307 --socket=/usr/local/mysql/mysql.sock
    
     >>  MySQLTuner 1.3.0 mod - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Modified by George Liu (eva2000) at http://vbtechsupport.com/
     >>  Run with '--help' for additional options and output filtering
    [OK] Currently running supported MySQL version 5.6.17
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM 
    [!!] InnoDB is enabled but isn't being used
    [OK] Total fragmented tables: 0
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 2m 59s (9 q [0.050 qps], 5 conn, TX: 13K, RX: 481)
    [--] Reads / Writes: 100% / 0%
    [--] Total buffers: 169.0M global + 1.1M per thread (151 max threads)
    [OK] Maximum possible memory usage: 338.9M (18% of installed RAM)
    [OK] Slow queries: 0% (0/9)
    [OK] Highest usage of available connections: 0% (1/151)
    [OK] Key buffer size / total MyISAM indexes: 8.0M/97.0K
    [!!] Query cache efficiency: 0.0% (0 cached / 4 selects)
    [OK] Query cache prunes per day: 0
    [OK] Temporary tables created on disk: 0% (0 on disk / 2 total)
    [OK] Thread cache hit rate: 80% (1 created / 5 connections)
    [OK] Table cache hit rate: 53% (8 open / 15 opened)
    [OK] Open file limit used: 0% (16/5K)
    [OK] Table locks acquired immediately: 100% (18 immediate / 18 locks)
    [OK] InnoDB log waits: 0
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Add skip-innodb to MySQL configuration to disable InnoDB
        MySQL started within last 24 hours - recommendations may be inaccurate
    
    Variables to adjust:
        query_cache_limit (> 1M, or use smaller result sets)
     
    #2 eva2000, Apr 9, 2014
    Last edited: Apr 9, 2014
  3. DomineauX

    DomineauX Well-Known Member
    PartnerNOC

    Joined:
    Apr 12, 2003
    Messages:
    414
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Thanks, but my point is that it keeps being removed and then replaced in each major version since 11.36 which is inconsistent and annoying. If it isn't going to be present, I'll start installing it, but there is no point if cPanel provides it consistently.
     
  4. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    322
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
    yeah indeed

    maybe just setup a cronjob to detect for it and if not at known location, auto download and set it up yourself :)
     
  5. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,467
    Likes Received:
    196
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    When it was restored in case 62947, it was to put it back after being removed mistakenly during the RPM project merge.

    When it was taken out in case 90317, it was due to it not supporting the versions of MySQL that cPanel provides.


    That's how it stands right now as I understand it. HTH!
     
  6. DomineauX

    DomineauX Well-Known Member
    PartnerNOC

    Joined:
    Apr 12, 2003
    Messages:
    414
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    The current version from http://mysqltuner.pl works fine on 5.5:

     
  7. eva2000

    eva2000 Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    322
    Likes Received:
    10
    Trophy Points:
    18
    Location:
    Brisbane, Australia
    cPanel Access Level:
    Root Administrator
    Twitter:
Loading...

Share This Page