MySQL性能建议者:mysqltuner.pl

页面导航:首页 > 数据库 > Mysql > MySQL性能建议者:mysqltuner.pl

MySQL性能建议者:mysqltuner.pl

来源: 作者: 时间:2016-02-04 09:03 【

MySQL性能建议者:mysqltuner pl性能mysql[[email protected] ~] wget http: mysqltuner pl mysqltuner pl[[email protected] ~] chmod +x mysqltuner pl [[email protected] ~] cp mysqltuner pl home mysql 一些简单
MySQL性能建议者:tuner.pl
 
性能mysql
[[email protected] ~]# wget  http://mysqltuner.pl/mysqltuner.pl
[[email protected] ~]# chmod +x mysqltuner.pl 
[[email protected] ~]# cp mysqltuner.pl /home/mysql/

 

 
一些简单的命令可从 --help 查阅
 
[[email protected] ~]$ ./mysqltuner.pl 

 >>  MySQLTuner 1.2.0 - Major Hayden <>
 >>  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 '' has no password set.
[!!] User 'root@::1' has no password set.
[!!] User '' 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)

 


Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<