附件里下载该脚本。 [root@TestSizeServer ~]# ./system_summary # Aspersa System Summary Report ############################## Date | 2012-06-12 09:20:46 UTC (local
#创建LVM 1.pvcreate /dev/sdb /dev/sdc 2.vgcreate /dev/sdb /dev/sdc vgtest 3.lvcreate -l 100%FREE -n lvtest vgtest 4.mkfs.xfs -f /dev/vgtest/lvtest 5.mount -t xfs /dev/vgtest/lvtest /data/
# 统计客户端连接数 netstat -anlp|grep 3306|grep tcp|awk '{print $5}'|awk -F: '{print $1}'|sort|uniq -c|sort -nr|head -n20 mysql -e "show processlist"|awk '{print $3}' |awk -F: '{print $1}' |so
##统计每个库大小 mysql> use information_schema; Database changed mysql> SELECT TABLE_SCHEMA,SUM(DATA_LENGTH)/1024/1024/1024 as DATA_LENGTH,SUM(INDEX_LENGTH)/1024/1024/1024 as INDEX_LENGTH,SUM(DATA_L
运行 tuning-primer.sh显示说明 SLOW QUERIES慢查询检查SLOW QUERIESThe slow query log is enabled.说明我已经启用了慢查询记录功能。也就是参数slow_query_log = 1Current long_query_time = 5.000000 sec.慢查询的阀值时间。也就是参数long_query_time = 5You ha
##把全部的MySQL连接kill掉 for i in $(mysql -uroot -p123456 -Bse "show processlist" | awk '{print $1}');do mysql -uroot -p123456 -e "kill $i";done ##把admin用户的连接kill掉 for i in $(mysq
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
