'MySQLTunerScript'에 해당되는 글 1건

MySQL MySQLTuner script

LINUX 2016. 8. 18. 12:50

MySQL MySQLTuner script



MySQL 튜닝 스크립트입니다.

설치한 다음에 실행만 하면 됩니다.


# yum -y install mysqltuner


[root@conoha-jp ~]# mysqltuner

Please enter your MySQL administrative login: root

Please enter your MySQL administrative password:  >>  MySQLTuner 1.6.0 - Major Hayden <major@mhtx.net>

 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/

 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script

[OK] Currently running supported MySQL version 5.5.50-MariaDB

[OK] Operating on 64-bit architecture


-------- Storage Engine Statistics -------------------------------------------

[--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MYISAM

[!!] InnoDB is enabled but isn't being used

[OK] Total fragmented tables: 0


-------- Security Recommendations  -------------------------------------------

[OK] There is no anonymous account in all database users

[OK] All database users have passwords assigned

[!!] There is not basic password file list !


-------- Performance Metrics -------------------------------------------------

[--] Up for: 2m 17s (58 q [0.423 qps], 16 conn, TX: 32K, RX: 2K)

[--] Reads / Writes: 75% / 25%

[--] Binary logging is disabled

[--] Total buffers: 416.0M global + 2.8M per thread (151 max threads)

[OK] Maximum reached memory usage: 418.8M (42.17% of installed RAM)

[OK] Maximum possible memory usage: 836.0M (84.19% of installed RAM)

[OK] Slow queries: 0% (0/58)

[OK] Highest usage of available connections: 0% (1/151)

[!!] Aborted connections: 18.75%  (3/16)

[!!] Query cache is disabled

[OK] Temporary tables created on disk: 0% (0 on disk / 4 total)

[!!] Thread cache is disabled

[OK] Table cache hit rate: 178% (41 open / 23 opened)

[OK] Open file limit used: 4% (51/1K)

[OK] Table locks acquired immediately: 100% (43 immediate / 43 locks)


-------- MyISAM Metrics -----------------------------------------------------

[!!] Key buffer used: 18.2% (24M used / 134M cache)

[OK] Key buffer size / total MyISAM indexes: 128.0M/99.0K

[!!] Read Key buffer hit rate: 83.3% (6 cached / 1 reads)


-------- InnoDB Metrics -----------------------------------------------------

[--] InnoDB is disabled.

[!!] InnoDB Storage engine is disabled. InnoDB is the default storage engine


-------- AriaDB Metrics -----------------------------------------------------

[--] AriaDB is disabled.


-------- Replication Metrics -------------------------------------------------

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

    Enable the slow query log to troubleshoot bad queries

    Reduce or eliminate unclosed connections and network issues

    Set thread_cache_size to 4 as a starting value

Variables to adjust:

    query_cache_size (>= 8M)

    thread_cache_size (start at 4)


테스트 한 서버는 DB를 사용하지 않고 있어서 나온 결과값입니다.


단순 참고용으로만 보세요~


블로그 이미지

영은파더♥

가상서버호스팅 VPS 리눅스 서버관리 윈도우 IT

,