mysql mysqltuner.pl_MySQL性能建议者:mysqltuner.pl

MySQL性能建议者:mysqltuner.pl

性能mysql

[root@even ~]# wget https://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

>> Bug reports, feature requests, and downloads at https://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)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值