Update mysltuner script on Centminmod

hehe updated at Have as default the Tunning primer script | Centmin Mod Community

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 <[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

[--] 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)

 

for your output or you mean above example ?

 

You using Centmin Mod provided version or official ? I probably need to update my version hehe

 

yeah double check if your database tables are InnoDB or MyISAM

 

There's the issue than you only have your 3 system databases for mysql which are not InnoDB based and you need them as such for MySQL server to work. Once you add mysql databases that are InnoDB based, you will see it work InnoDB in use