Hi As we have the mysqltunner script in place i want to recommend to have always also the latest version of Tunning primer script on Centminmod I know it is very old and has many years to get an update but it works and many times is useful MySQL Tuning Primer Script in Launchpad Thanks
mysqltuner.pl included in Centmin Mod is from mysqlmymonlite.sh's modified mysqltuner.pl version at mysqlmymon.com so needs modifying for each version update. So will need to update it myself.
ah was an easier update apparently to add my modifications to mysqltuner.pl 1.6.18 updating is as easy as removing existing /root/mysqltuner.pl and downloading latest one Code (Text): rm /root/mysqltuner.pl wget -O /root/mysqltuner.pl https://centminmod.com/centminmodparts/mysqltuner/mysqltuner.pl example run of mysqltuner.pl 1.6.18 Code (Text): /root/mysqltuner.pl >> MySQLTuner 1.6.18 - 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 [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 10.1.17-MariaDB [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE [!!] InnoDB is enabled but isn't being used [OK] Total fragmented tables: 0 -------- Security Recommendations ------------------------------------------------------------------ [OK] There are no anonymous accounts for any database users [OK] All database users have passwords assigned [!!] There is no basic password file list! -------- CVE Security Recommendations -------------------------------------------------------------- [--] Skipped due to --cvefile option undefined -------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 13m 6s (151 q [0.192 qps], 55 conn, TX: 198K, RX: 15K) [--] Reads / Writes: 100% / 0% [--] Binary logging is disabled [--] Physical Memory : 996.1M [--] Max MySQL memory : 386.7M [--] Other process memory: 127.0M [--] Total buffers: 152.0M global + 801.0K per thread (300 max threads) [--] P_S Max memory usage: 0B [--] Galera GCache Max memory usage: 0B [OK] Maximum reached memory usage: 152.8M (15.34% of installed RAM) [OK] Maximum possible memory usage: 386.7M (38.82% of installed RAM) [OK] Overall possible memory usage with other process is compatible with memory available [OK] Slow queries: 0% (0/151) [OK] Highest usage of available connections: 0% (1/300) [OK] Aborted connections: 1.82% (1/55) [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance [!!] Query cache efficiency: 0.0% (0 cached / 78 selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4 sorts) [OK] No joins without indexes [OK] Temporary tables created on disk: 3% (1 on disk / 32 total) [OK] Thread cache hit rate: 98% (1 created / 55 connections) [OK] Table cache hit rate: 92% (82 open / 89 opened) [OK] Open file limit used: 0% (59/8K) [OK] Table locks acquired immediately: 100% (29 immediate / 29 locks) -------- Performance schema ------------------------------------------------------------------------ [--] Performance schema is disabled. -------- ThreadPool Metrics ------------------------------------------------------------------------ [--] ThreadPool stat is enabled. [--] Thread Pool Size: 1 thread(s). [--] Using default value is good enough for your version (10.1.17-MariaDB) -------- MyISAM Metrics ---------------------------------------------------------------------------- [!!] Key buffer used: 18.3% (6M used / 33M cache) [OK] Key buffer size / total MyISAM indexes: 32.0M/124.0K [!!] Read Key buffer hit rate: 90.0% (20 cached / 2 reads) -------- AriaDB Metrics ---------------------------------------------------------------------------- [--] AriaDB is enabled. [OK] Aria pagecache size / total Aria indexes: 8.0M/1B [OK] Aria pagecache hit rate: 98.4% (61 cached / 1 reads) -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is disabled. [!!] InnoDB Storage engine is disabled. InnoDB is the default storage engine -------- TokuDB Metrics ---------------------------------------------------------------------------- [--] TokuDB is disabled. -------- Galera Metrics ---------------------------------------------------------------------------- [--] Galera is disabled. -------- Replication Metrics ----------------------------------------------------------------------- [--] Galera Synchronous replication: NO [--] No replication slave(s) for this server. [--] This is a standalone server. -------- Recommendations --------------------------------------------------------------------------- General recommendations: Add skip-innodb to MySQL configuration to disable InnoDB MySQL started within last 24 hours - recommendations may be inaccurate Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1 Variables to adjust: query_cache_limit (> 512K, or use smaller result sets)
Yes i know but i was ask for it to be there ready to go after Centminmod installation.... But no big deal if you want to keep your modified version as default
I just notice that you got confused and reply to this topic about mysqltunner but this topic is for tunning primer script
doh.. mysql tuning-primer.sh is too ancient and some suggestions are not relevant to newest mysql, percona and mariadb server versions so probably won't be included by default
example bug Bug #1565227 “Mysql 5.7 InnoDB support” : Bugs : MySQL Tuning Primer Script and Bugs : MySQL Tuning Primer Script