Join the community today
Become a Member

Have as default the Tunning primer script

Discussion in 'Feature Requests & Suggestions' started by pamamolf, Sep 7, 2016.

  1. pamamolf

    pamamolf Well-Known Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    10:49 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    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
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,797
    12,271
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,857
    Local Time:
    5:49 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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.
     
    Last edited: Sep 8, 2016
  3. eva2000

    eva2000 Administrator Staff Member

    55,797
    12,271
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,857
    Local Time:
    5:49 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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)
     
  4. pamamolf

    pamamolf Well-Known Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    10:49 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    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 :)
     
  5. pamamolf

    pamamolf Well-Known Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    10:49 PM
    Nginx-1.26.x
    MariaDB 10.6.x
    I just notice that you got confused and reply to this topic about mysqltunner but this topic is for tunning primer script :)
     
  6. eva2000

    eva2000 Administrator Staff Member

    55,797
    12,271
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,857
    Local Time:
    5:49 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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
     
  7. eva2000

    eva2000 Administrator Staff Member

    55,797
    12,271
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,857
    Local Time:
    5:49 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+