MySQLTuner 사용기
이 스크립트는 mysql 튜닝 포인트 정보를 실 운영되는 mysql서버를 접속하여 정보를 수집하여 결과를 보여줍니다. 조금은 미흡하지만 간력한 정보들을 파악하여 mysql의 튜닝 포인트를 한번 짚어보세요.
1. 사용 방법
>wget http://mysqltuner.com/mysqltuner.pl
>chmod +x mysqltuner.pl
>su - root
>./mysqltuner.pl
2. 결과 내용
저의 개인용 mysql 정보입니다. 설정부분을 수정해주어야 할 부분이 보이죠. ^^
1. 사용 방법
>wget http://mysqltuner.com/mysqltuner.pl
>chmod +x mysqltuner.pl
>su - root
>./mysqltuner.pl
2. 결과 내용
저의 개인용 mysql 정보입니다. 설정부분을 수정해주어야 할 부분이 보이죠. ^^
-------- General Statistics --------------------------------------------------
[OK] You have the latest version of MySQLTuner
[!!] Your MySQL version 4.1.21 is EOL software! Upgrade soon!
[OK] Operating on 32-bit architecture with less than 2GB RAM
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[!!] InnoDB is enabled but isn't being used
-------- Performance Metrics -------------------------------------------------
[--] Up for: 165d 1h 52m 10s (18M q [1.300 qps], 671K conn, TX: 2B, RX: 766M)
[--] Reads / Writes: 84% / 16%
[--] Total buffers: 1.6M per thread and 42.0M global
[OK] Maximum possible memory usage: 197.5M (9% of installed RAM)
[OK] Slow queries: 0% (0/18M)
[OK] Highest usage of available connections: 41% (41/100)
[!!] Cannot calculate MyISAM index size - re-run script as root user
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0%
[OK] Temporary tables created on disk: 5%
[!!] Thread cache is disabled
[!!] Table cache hit rate: 0%
[OK] Open file limit used: 12%
[OK] Table locks acquired immediately: 100%
-------- Recommendations -----------------------------------------------------
General recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
Enable the slow query log to troubleshoot bad queries
Set thread_cache_size to 4 as a starting value
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_size (>= 8M)
thread_cache_size (start at 4)
table_cache (> 64)