mysqlreport的使用_MySQL

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysqlreport的使用_MySQL，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3608字，纯文字阅读大概需要6分钟。

内容图文

mysql参数怎么调是个问题，如果是Oracle，数据库报告上有很多建议，非常直观。mysql也有一个小工具mysqlreport,来统计一些信息指导调参数，最好是写一个任务，一个小时执行一次，这样可以看到高峰、低峰时期的统计信息，更有利于参数调优。

1.先下载dbi、dbd-mysql、mysqlreport-3.5。

2.安装dbi和dbd-mysql，安装之前确认安装过perl。
perl Makefile.PL
make
make test
make install

3.到mysqlreport-3.5的目录下执行

[root@VM-10 mysqlreport-3.5]# ./mysqlreport --user root --password root --host 10.10.15.208 --port 3316
Use of uninitialized value in formline at ./mysqlreport line 1099.
Use of uninitialized value $is in multiplication (*) at ./mysqlreport line 829.
Use of uninitialized value in formline at ./mysqlreport line 1227.
Use of uninitialized value in formline at ./mysqlreport line 1235.
MySQL 5.6.25-log uptime 0 5:34:3 Wed Aug 26 17:12:54 2015
__ Key _________________________________________________________________
Buffer used 0 of 2.00G %Used: 0.00
Current 373.45M %Usage: 18.24
Write hit 0.00%
Read hit 0.00%
__ Questions ___________________________________________________________
Total 757 0.0/s
Com_ 1.26k 0.1/s %Total: 166.31
-Unknown 805 0.0/s 106.34
DMS 294 0.0/s 38.84
COM_QUIT 9 0.0/s 1.19
Slow 5 s 13 0.0/s 1.72 %DMS: 4.42 Log:
DMS 294 0.0/s 38.84
SELECT 294 0.0/s 38.84 100.00
REPLACE 0 0/s 0.00 0.00
DELETE 0 0/s 0.00 0.00
INSERT 0 0/s 0.00 0.00
UPDATE 0 0/s 0.00 0.00
Com_ 1.26k 0.1/s 166.31
admin_comma 800 0.0/s 105.68
show_table_ 171 0.0/s 22.59
set_option 148 0.0/s 19.55


__ SELECT and Sort _____________________________________________________
Scan 337 0.0/s %SELECT: 114.63
Range 51 0.0/s 17.35
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 64 0.0/s
Sort range 1 0.0/s
Sort mrg pass 32 0.0/s


__ Query Cache _________________________________________________________
Memory usage 16.81k of 1.00M %Used: 1.64
Block Fragmnt 100.00%
Hits 0 0/s
Inserts 1 0.0/s
Insrt:Prune 1:1 0/s
Hit:Insert 0.00:1


__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 208 0.0/s


__ Tables ______________________________________________________________
Open 1 of 2000 %Cache: 0.05
Opened 240 0.0/s


__ Connections _________________________________________________________
Max used 4 of 1000 %Max: 0.40
Total 15 0.0/s
__ Created Temp ________________________________________________________
Disk table 20 0.0/s
Table 472 0.0/s Size: 16.0M
File 67 0.0/s
__ Threads _____________________________________________________________
Running 1 of 2
Cached 2 of 18 %Hit: 73.33
Created 4 0.0/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 8 0.0/s
Connects 0 0/s
__ Bytes _______________________________________________________________
Sent 504.65M 25.2k/s
Received 51.91k 2.6/s
__ InnoDB Buffer Pool __________________________________________________
Usage 127.98M of 127.98M %Used: 100.00
Read hit 97.36%
Pages
Free 0 %Total: 0.00
Data 7.87k 96.12 %Drty: 0.00
Misc 318 3.88
Latched 0.00
Reads 92.16M 4.6k/s
From file 2.43M 121.3/s 2.64
Ahead Rnd 0 0/s
Ahead Sql 0/s
Writes 134 0.0/s
Flushes 134 0.0/s
Wait Free 0 0/s
__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 2.46M 122.8/s
Writes 87 0.0/s
fsync 11 0.0/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 0 0/s
Read 3.54M 176.9/s
Written 134 0.0/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 65.10M 3.2k/s
Updated 0 0/s

内容总结

以上是互联网集市为您收集整理的mysqlreport的使用_MySQL全部内容，希望文章能够帮你解决mysqlreport的使用_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---