Daily Script2

franket

发布于 2022-07-09 23:30:16

6910

#参数推荐

pt-variable-advisor 192.168.1.123 --user root --password abc

# mysql 信息汇总

pt-mysql-summary --user root --password abc

# mysql 参数对比

pt-config-diff h=192.168.1.123 h=192.168.1.178 --user=abc --password=abc

# mysql 参数调整

./mysqltuner.pl --forcemem 48288 --forceswap 4094

#查看长时休眠的mysql进程

select * from  information_schema.processlist where Command="sleep" and Time>86400;

#杀进程脚本

mysql -u root -p -e "select concat('KILL ',ID,';') from information_schema.processlist where COMMAND='Sleep';"  | cat 

mysql -u root -p -e "select concat('KILL ',ID,';') from information_schema.processlist where COMMAND='Sleep' and time > 259200;"  | cat

# mysqladmin

mysqladmin flush-hosts -h localhost -P 3306 -u root -p 

mysqladmin -u root -pPASSWORD flush-hosts flush-tables flush-threads flush-logs flush-privileges flush-status

本文系转载，前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

数据库