Friday, June 06, 2008

Alat Bantu Tuning MySQL:

Run awal:

$ ./mysqltuner.pl

-------- General Statistics --------------------------------------------------
[OK] You have the latest version of MySQLTuner
[OK] Currently running supported MySQL version 5.0.32-Debian_7etch5-log
[!!] Switch to 64-bit OS - MySQL cannot currenty use all of your RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 3G (Tables: 95)
[!!] InnoDB is enabled but isn't being used

-------- Performance Metrics -------------------------------------------------
[--] Up for: 12h 50m 58s (7M q [159.334 qps], 1M conn, TX: 2B, RX: 597M)
[--] Reads / Writes: 64% / 36%
[--] Total buffers: 2.6M per thread and 58.0M global
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 2.1G (53% of installed RAM)
[OK] Slow queries: 0% (338/7M)
[OK] Highest usage of available connections: 14% (115/800)
[OK] Key buffer size / total MyISAM indexes: 16.0M/74.0K
[OK] Key buffer hit rate: 98.9%
[OK] Query cache efficiency: 34.8%
[!!] Query cache prunes per day: 65411
[OK] Sorts requiring temporary tables: 3%
[OK] Temporary tables created on disk: 0%
[OK] Thread cache hit rate: 98%
[!!] Table cache hit rate: 7%
[OK] Open file limit used: 15%
[!!] Table locks acquired immediately: 83%

-------- 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
Increase table_cache gradually to avoid file descriptor limits
Optimize queries and/or use InnoDB to reduce lock wait
Variables to adjust:
query_cache_size (> 16M)
table_cache (> 1024)

Mari kita tunggu minimum 24 jam untuk melihat hasil tuning.

2 comments:

Harry said...

Wah terimakasih banyak pak :)

Saya barusan coba, dan server MySQL yang sudah saya tune ternyata masih bisa di tweak lagi.

Sekali lagi terimakasih.

Yudha said...

Nungguin hasilnya nih Pak ;)