首页 > 代码库 > dstat mysql5-io 模块使用
dstat mysql5-io 模块使用
[root@shylock dstat]# dstat --listinternal: aio, cpu, cpu24, disk, disk24, disk24old, epoch, fs, int, int24, io, ipc, load, lock, mem, net, page, page24, proc, raw, socket, swap, swapold, sys, tcp, time, udp, unix, vm/usr/share/dstat: battery, battery-remain, cpufreq, dbus, disk-util, fan, freespace, gpfs, gpfs-ops, helloworld, innodb-buffer, innodb-io, innodb-ops, lustre, memcache-hits, mysql-io, mysql-keys, mysql5-cmds, mysql5-conn, mysql5-io, mysql5-keys, net-packets, nfs3, nfs3-ops, nfsd3, nfsd3-ops, ntp, postfix, power, proc-count, rpc, rpcd, sendmail, snooze, thermal, top-bio, top-cpu, top-cputime, top-cputime-avg, top-io, top-latency, top-latency-avg, top-mem, top-oom, utmp, vm-memctl, vmk-hba, vmk-int, vmk-nic, vz-cpu, vz-io, vz-ubc, wifi
当运行dstat 监控mysql io 的时候报连接不到mysql server
[root@shylock ~]# dstat --mysql5-ioModule dstat_mysql5_io failed to load. (Cannot interface with MySQL server)None of the stats you selected are available.
[root@shylock ~]# cd /usr/share/dstat[root@shylock dstat]# vi dstat_mysql5_io.py 3 global mysql_user 4 mysql_user = os.getenv(‘DSTAT_MYSQL_USER‘) or os.getenv(‘USER‘) 5 6 global mysql_pwd 7 mysql_pwd = os.getenv(‘DSTAT_MYSQL_PWD‘)在/usr/shared/dstat目录下有dstat的命令和插件vi dstat_mysql5_io.py在3-7行里有声明mysql_user 和mysql_pwd os.getenv(环境变量名称) 从环境变量中获取MYSQL的用户名密码
#!/bin/bash#file:mysql5io.shexport DSTAT_MYSQL_USER=‘user‘export DSTAT_MYSQL_PWD=‘pwd‘dstat --mysql5-io $@
编写shell脚本 --"$@" 数组 "$*" 字符串
chmod 700 mysql5io.sh ./mysql5io.sh 3 5 #停3秒,获取5次结果
-mysql5-io-
recv sent
1.00B 3.34B
778B 2618B
791B 2677B
804B 2736B
817B 2794B
830B 2853B
因为在脚本里 dstat --mysql5_io $@ 运行脚本传参数(参考dstat -h)
[root@shylock ~]# ./mysql5io.sh -c -s -m 3 5-mysql5-io- ----total-cpu-usage---- ----swap--- ------memory-usage----- recv sent|usr sys idl wai hiq siq| used free| used buff cach free1.11B 3.75B| 16 2 78 4 0 0| 0 2016M|95.7M 41.5M 276M 594M 885B 2996B| 0 0 100 0 0 0| 0 2016M|95.8M 41.5M 276M 594M 898B 3055B| 0 0 99 0 0 0| 0 2016M|95.8M 41.5M 276M 594M 911B 3114B| 0 0 100 0 0 0| 0 2016M|95.8M 41.5M 276M 594M 924B 3172B| 0 0 100 0 0 0| 0 2016M|95.8M 41.5M 276M 594M 937B 3231B| 0 0 100 0 0 0| 0 2016M|95.8M 41.5M 276M 594M
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。