Skip to main content

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: [QUOTE] [url=http://docs.cpanel.net/twiki/bin/view/AllDocumentation/ChangeLog/CPanelVersion1142]CPanelVersion1142 < AllDocumentation/ChangeLog < TWiki case 90317: Removed mysqltuner from distribution.
This was previously done as well and then included again in 11.38: [QUOTE] [url=http://docs.cpanel.net/twiki/bin/view/AllDocumentation/ChangeLog/CPanelVersion1138]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.

Comments

6 comments

Date Votes
  • eva2000
    Just download it manually ;) I use a modified version of mysqltuner.pl for [url=http://mysqlmymon.com]mysqlmymonlite.sh You can download it if you want at WebScaleSQL MySQL 5.6.17 ./mysqltuner.pl --port=3307 --socket=/usr/local/mysql/mysql.sock >> MySQLTuner 1.3.0 mod - Major Hayden >> 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)
    0
  • 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.
    0
  • 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 :)
    0
  • Infopro
    [quote="DomineauX, post: 1617422">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!
    0
  • DomineauX
    The current version from
    0
  • eva2000
    I think Charles is referring to this
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post