DomineauX

Well-Known Member
PartnerNOC
Apr 12, 2003
429
11
168
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:


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

Well-Known Member
Aug 14, 2001
339
16
318
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 <[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

Code:
./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

Code:
./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)
 
Last edited:

DomineauX

Well-Known Member
PartnerNOC
Apr 12, 2003
429
11
168
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.
 

Infopro

Well-Known Member
May 20, 2003
17,091
516
613
Pennsylvania
cPanel Access Level
Root Administrator
Twitter
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

Well-Known Member
PartnerNOC
Apr 12, 2003
429
11
168
Houston, TX
cPanel Access Level
Root Administrator