Get the most out of your Centmin Mod LEMP stack
Become a Member

mysqltuner update 1.7.5

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Jimmy, Feb 18, 2018.

  1. Jimmy

    Jimmy Premium Member Premium Member

    1,279
    268
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +660
    Local Time:
    1:13 AM
    1.13.x
    MariaDB 10.1.x
    @eva2000 mysqltuner is on version 1.7.5. I believe the one included with CCM is 1.7.1. Just an FYI.
     
  2. eva2000

    eva2000 Administrator Staff Member

    34,649
    7,658
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,776
    Local Time:
    3:13 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Yeah need to find the time :D
     
  3. eva2000

    eva2000 Administrator Staff Member

    34,649
    7,658
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,776
    Local Time:
    3:13 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
  4. eva2000

    eva2000 Administrator Staff Member

    34,649
    7,658
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +11,776
    Local Time:
    3:13 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    ah 1.7.5 is in master branch.. updated the source downloaded mysqltuner.pl

    Code (Text):
    /root/mysqltuner.pl
     >>  MySQLTuner 1.7.5 - Major Hayden <[email protected]>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Modified by George Liu (eva2000) at https://centminmod.com/
     >>  Run with '--help' for additional options and output filtering
    
    [--] Skipped version check for MySQLTuner script
    [OK] Currently running supported MySQL version 10.2.13-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: 1d 21h 21m 30s (90 q [0.001 qps], 36 conn, TX: 144K, RX: 9K)
    [--] Reads / Writes: 100% / 0%
    [--] Binary logging is disabled
    [--] Physical Memory     : 2.0G
    [--] Max MySQL memory    : 379.5M
    [--] Other process memory: 151.7M
    [--] Total buffers: 144.0M global + 804.0K per thread (300 max threads)
    [--] P_S Max memory usage: 0B
    [--] Galera GCache Max memory usage: 0B
    [OK] Maximum reached memory usage: 144.8M (7.07% of installed RAM)
    [OK] Maximum possible memory usage: 379.5M (18.53% of installed RAM)
    [OK] Overall possible memory usage with other process is compatible with memory available
    [OK] Slow queries: 0% (0/90)
    [OK] Highest usage of available connections: 0% (1/300)
    [OK] Aborted connections: 0.00%  (0/36)
    [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
    [!!] Query cache may be disabled by default due to mutex contention.
    [!!] Query cache efficiency: 0.0% (0 cached / 44 selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2 sorts)
    [OK] No joins without indexes
    [OK] Temporary tables created on disk: 5% (1 on disk / 20 total)
    [OK] Thread cache hit rate: 94% (2 created / 36 connections)
    [OK] Table cache hit rate: 93% (82 open / 88 opened)
    [OK] Open file limit used: 0% (59/524K)
    [OK] Table locks acquired immediately: 100% (24 immediate / 24 locks)
    
    -------- Performance schema ------------------------------------------------------------------------
    [--] Performance schema is disabled.
    [--] Memory used by P_S: 0B
    [--] Sys schema isn't installed.
    
    -------- ThreadPool Metrics ------------------------------------------------------------------------
    [--] ThreadPool stat is enabled.
    [--] Thread Pool Size: 2 thread(s).
    [--] Using default value is good enough for your version (10.2.13-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: 80.0% (10 cached / 2 reads)
    
    -------- InnoDB Metrics ----------------------------------------------------------------------------
    [--] InnoDB is disabled.
    [!!] InnoDB Storage engine is disabled. InnoDB is the default storage engine
    
    -------- AriaDB Metrics ----------------------------------------------------------------------------
    [--] AriaDB is enabled.
    [OK] Aria pagecache size / total Aria indexes: 8.0M/1B
    [OK] Aria pagecache hit rate: 98.3% (58 cached / 1 reads)
    
    -------- TokuDB Metrics ----------------------------------------------------------------------------
    [--] TokuDB is disabled.
    
    -------- XtraDB Metrics ----------------------------------------------------------------------------
    [--] XtraDB is disabled.
    
    -------- RocksDB Metrics ---------------------------------------------------------------------------
    [--] RocksDB is disabled.
    
    -------- Spider Metrics ----------------------------------------------------------------------------
    [--] Spider is disabled.
    
    -------- Connect Metrics ---------------------------------------------------------------------------
    [--] Connect 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
        Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
        Performance should be activated for better diagnostics
        Consider installing Sys schema from https://github.com/mysql/mysql-sys
    Variables to adjust:
        query_cache_size (=0)
        query_cache_type (=0)
        query_cache_limit (> 512K, or use smaller result sets)
        performance_schema = ON enable PFS
    


    to update your version run command to download the latest
    Code (Text):
    wget -O /root/mysqltuner.pl https://centminmod.com/centminmodparts/mysqltuner/mysqltuner.pl
    
     
    • Like Like x 3
..