Want to subscribe to topics you're interested in?
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

    3,113
    295
    83
    May 31, 2014
    Ratings:
    +530
    Local Time:
    6:33 AM
    Nginx-1.13.x
    MariaDB 10.1.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

    36,040
    7,906
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,188
    Local Time:
    1:33 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    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
    • Informative Informative x 1
  3. eva2000

    eva2000 Administrator Staff Member

    36,040
    7,906
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,188
    Local Time:
    1:33 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    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 <[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)
     
  4. pamamolf

    pamamolf Well-Known Member

    3,113
    295
    83
    May 31, 2014
    Ratings:
    +530
    Local Time:
    6:33 AM
    Nginx-1.13.x
    MariaDB 10.1.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 :)
     
    • Like Like x 1
  5. pamamolf

    pamamolf Well-Known Member

    3,113
    295
    83
    May 31, 2014
    Ratings:
    +530
    Local Time:
    6:33 AM
    Nginx-1.13.x
    MariaDB 10.1.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

    36,040
    7,906
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,188
    Local Time:
    1:33 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    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
     
    • Informative Informative x 1
  7. eva2000

    eva2000 Administrator Staff Member

    36,040
    7,906
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,188
    Local Time:
    1:33 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
..