Why was mysqltuner.pl removed (again)

[DomineauX]

I just noticed that the mysqltuner.pl script was removed with the 11.42.1.5 update that just installed to release tier:

CPanelVersion1142 < AllDocumentation/ChangeLog < TWiki case 90317: Removed mysqltuner from distribution.

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

CPanelVersion1138 < AllDocumentation/ChangeLog < TWiki Fixed case 62947: Restore mysqltuner.pl to shipped files.

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

 

[eva2000]

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

./mysqltuner.pl            

 >>  MySQLTuner 1.3.0 mod - Major Hayden <[email protected]>
 >>  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

./mysqltuner.pl 

 >>  MySQLTuner 1.3.0 mod - Major Hayden <[email protected]>
 >>  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

./mysqltuner.pl --port=3307 --socket=/usr/local/mysql/mysql.sock

 >>  MySQLTuner 1.3.0 mod - Major Hayden <[email protected]>
 >>  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)

 

[DomineauX]

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.

 

[eva2000]

yeah indeed

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

 

[Infopro]

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.

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!

 

[DomineauX]

The current version from http://mysqltuner.pl works fine on 5.5:

>> MySQLTuner 1.3.0 - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at MySQLTuner-perl by major
>> Run with '--help' for additional options and output filtering
[OK] Currently running supported MySQL version 5.5.36-cll
[OK] Operating on 64-bit architecture

 

[eva2000]

I think Charles is referring to this http://forums.cpanel.net/f354/case-90317-warning-using-mysqltuner-mysql-5-6-a-389971.html