MySQL性能提议者：mysqltuner.pl
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了MySQL性能提议者：mysqltuner.pl，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3049字，纯文字阅读大概需要5分钟。
内容图文
MySQL性能建议者：mysqltuner.pl [root@even ~]# wget http://mysqltuner.pl/mysqltuner.pl [root@even ~]# chmod +x mysqltuner.pl [root@even ~]# cp mysqltuner.pl /home/mysql/ 一些简单的命令可从 --help 查阅 [mysql@even ~]$ ./mysqltuner.pl MySQLTun
MySQL性能建议者：mysqltuner.pl[root@even ~]# wget http://mysqltuner.pl/mysqltuner.pl
[root@even ~]# chmod +x mysqltuner.pl
[root@even ~]# cp mysqltuner.pl /home/mysql/
一些简单的命令可从 --help 查阅
[mysql@even ~]$ ./mysqltuner.pl
>> MySQLTuner 1.2.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
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.16-log
[OK] Operating on 32-bit architecture with less than 2GB RAM
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 7B (Tables: 2)
[--] Data in InnoDB tables: 184M (Tables: 7)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 5
-------- Security Recommendations -------------------------------------------
[!!] User '@even.example.com' has no password set.
[!!] User '@localhost' has no password set.
[!!] User 'root@127.0.0.1' has no password set.
[!!] User 'root@::1' has no password set.
[!!] User 'root@even.example.com' has no password set.
-------- Performance Metrics -------------------------------------------------
[--] Up for: 10s (9 q [0.900 qps], 6 conn, TX: 10K, RX: 625)
[--] Reads / Writes: 100% / 0%
[--] Total buffers: 176.0M global + 1.6M per thread (151 max threads)
[OK] Maximum possible memory usage: 411.9M (38% of installed RAM)
[OK] Slow queries: 0% (0/9)
[OK] Highest usage of available connections: 0% (1/151)
[OK] Key buffer size / total MyISAM indexes: 16.0M/98.0K
[!!] Query cache is disabled
[OK] Temporary tables created on disk: 0% (0 on disk / 2 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 78% (26 open / 33 opened)
[OK] Open file limit used: 2% (21/1K)
[OK] Table locks acquired immediately: 100% (36 immediate / 36 locks)
[!!] Connections aborted: 16%
[!!] InnoDB data size / buffer pool: 184.8M/128.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Set thread_cache_size to 4 as a starting value
Your applications are not closing MySQL connections properly
Variables to adjust:
query_cache_size (>= 8M)
thread_cache_size (start at 4)
innodb_buffer_pool_size (>= 184M)
输出结果简单明了，读者有兴趣可参阅官网博客
By 迦夜
2013-10-23
Happy Databasing
内容总结
以上是互联网集市为您收集整理的MySQL性能提议者：mysqltuner.pl全部内容，希望文章能够帮你解决MySQL性能提议者：mysqltuner.pl所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。