MySQL性能优化脚本MySQLtuner.pl使用介绍

这篇文章主要为大家详细介绍了MySQL性能优化脚本MySQLtuner.pl使用介绍，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

MySQLTuner 下载地址：http://github.com/rackerhacker/MySQLTuner-perl

MySQLTuner 使用方法：Downloading and using MySQLTuner is actually a very simple process:

wget mysqltuner.plperl mysqltuner.pl

If you'd rather not invoke perl every time, just make it executable:

chmod u+x mysqltuner.pl./mysqltuner.pl

» Latest development versionIf you want to get the bleeding edge commits, you can check out the latest code with git:

git clone git://github.com/rackerhacker/MySQLTuner-perl.git

看看我的运行结果

代码如下:

>> MySQLTuner 1.1.1 - Major Hayden 
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/ 
>> Run with '--help' for additional options and output filtering

-------- General Statistics --------------------------------------------------[--] Skipped version check for MySQLTuner script[OK] Currently running supported MySQL version 5.1.43-log[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster[--] Data in MyISAM tables: 889M (Tables: 479)[--] Data in MEMORY tables: 1M (Tables: 4)[!!] Total fragmented tables: 29

-------- Security Recommendations -------------------------------------------[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------[--] Up for: 12h 55m 27s (4M q [105.230 qps], 295K conn, TX: 9B, RX: 546M)[--] Reads / Writes: 82% / 18%[--] Total buffers: 432.0M global + 6.3M per thread (500 max threads)[!!] Maximum possible memory usage: 3.5G (175% of installed RAM)[OK] Slow queries: 0% (48K/4M)[OK] Highest usage of available connections: 3% (16/500)[OK] Key buffer size / total MyISAM indexes: 384.0M/332.6M[OK] Key buffer hit rate: 100.0% (2B cached / 205K reads)[OK] Query cache efficiency: 49.3% (1M cached / 3M selects)[!!] Query cache prunes per day: 268042[OK] Sorts requiring temporary tables: 0% (10 temp sorts / 122K sorts)[OK] Temporary tables created on disk: 19% (4K on disk / 22K total)[OK] Thread cache hit rate: 99% (16 created / 295K connections)[!!] Table cache hit rate: 18% (256 open / 1K opened)[OK] Open file limit used: 19% (497/2K)[!!] Table locks acquired immediately: 88%

-------- Recommendations -----------------------------------------------------General recommendations:Run OPTIMIZE TABLE to defragment tables for better performanceMySQL started within last 24 hours - recommendations may be inaccurateReduce your overall MySQL memory footprint for system stabilityIncrease table_cache gradually to avoid file descriptor limitsOptimize queries and/or use InnoDB to reduce lock waitVariables to adjust:*** MySQL's maximum memory usage is dangerously high ****** Add RAM before increasing MySQL buffer variables ***query_cache_size (> 32M)table_cache (> 256)

注：关于MySQL性能优化脚本MySQLtuner.pl使用介绍的内容就先介绍到这里，更多相关文章的可以留意