查询非innodb引擎的表
<代码>选择TABLE_NAME,从information_schema TABLE_SCHEMA、发动机。表引擎=MyISAM和TABLE_SCHEMA不在(mysql, performance_schema, information_schema);
查看当前的每秒和tps以及等等
<代码> # !/bin/bash/usr/bin/mysqladmin -P3306 -uroot - p extended-status i1 | awk的开始{local_switch=0;打印“每秒提交回滚TPS Threads_con Threads_run \ n - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -”}
2 ~/查询/美元{q=$ 4-lq; lq=4美元;}
2 ~/Com_commit/美元{c=$ 4-lc; lc=4美元;}
2 ~/Com_rollback/美元{r=$ 4-lr; lr=4美元;}
2 ~/Threads_connected/美元{tc=4美元;}
2 ~/Threads_running/美元{tr=4美元;
如果(local_switch==0)
{local_switch=1;数=0}
其他{
如果(count> 10)
{count=0;打印”- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - \ nQPS提交回滚TPS Threads_con Threads_run \ n - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -”;}
其他{
数+=1;
printf“% 6 d % 8 d % 7 d % 8 d % -10 d % d \ n”, q, c, c + r, r, tc, tr;
}
}
}'
查看多个实例选择插入、更新、删除情况
<代码> # !/bin/bash
setup_select ()
{
清晰的
猫& lt; & lt;菜单
+ + + + + + + + +显示MYSQL状态+ + + + + + + + + +
1. 显示mysql qps_3306
2. 显示mysql processlist
3.显示mysql qps_3307
问:戒烟
+++++++++++++++++++++++++++++++++++++++++++++
菜单
echo - e - n”请选择(1、2、3,Q)的在”
}
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
amp_setup ()
{
setup_select
阅读选择
案例选择美元
1）/usr/bin/mysqladmin -P3306 -uroot - p - r - 1 extended-status | awk - f“|”开始{count=0;}{if ($ 2 ~/Variable_name/,,+ +数% 15==1){打印”- - - - - - - - - - - | - - - - - - - - - - - - | - - - MySQL命令状态——| - - - - - - Innodb行操作- - - - - - | -缓冲池读”;打印”- - - - - | -每秒——|选择插入、更新、删除|阅读插入更新删除|逻辑物理”;}else if($ 2 ~/查询/){查询=3美元;}else if ($ 2 ~/Com_select/) {Com_select=3美元;}else if ($ 2 ~/Com_insert/) {Com_insert=3美元;}else if ($ 2 ~/Com_update/) {Com_update=3美元;}else if ($ 2 ~/Com_delete/) {Com_delete=3美元;}else if ($ 2 ~/Innodb_rows_read/) {Innodb_rows_read=3美元;}else if ($ 2 ~/Innodb_rows_deleted/) {Innodb_rows_deleted=3美元;}else if ($ 2 ~/Innodb_rows_inserted/) {Innodb_rows_inserted=3美元;}else if ($ 2 ~/Innodb_rows_updated/) {Innodb_rows_updated=3美元;}else if ($ 2 ~/Innodb_buffer_pool_read_requests/) {innodb_lor=3美元;}else if ($ 2 ~/Innodb_buffer_pool_reads/) {innodb_phr=3美元;}else if($ 2 ~/正常运行时间/,,数在=2){printf (" % s | % 9 d”, strftime (“% H: % M: % s”),查询),printf (" | % 6 d % 6 d % 6 d % 6 d”, com_select, com_insert, com_update, com_delete); printf (" | % 8 d % 7 d % 7 d % 7 d”, innodb_rows_read, innodb_rows_inserted, innodb_rows_updated, innodb_rows_deleted);printf (" | % 10 d % 11 d \ n”, innodb_lor, innodb_phr);}}’
amp_setup
；；
2）/usr/bin/mysqladmin -P3306 -uroot - p公关| grep iv睡眠
睡眠10
amp_setup
；；
3）/usr/bin/mysqladmin -P3307 -uroot - p - r - 1 extended-status | awk - f“|”开始{count=0;}{if ($ 2 ~/Variable_name/,,+ +数% 15==1){打印”- - - - - - - - - - - | - - - - - - - - - - - - | - - - MySQL命令状态——| - - - - - - Innodb行操作- - - - - - | -缓冲池读”;打印”- - - - - | -每秒——|选择插入、更新、删除|阅读insertedupdated删除|逻辑物理”;}else if($ 2 ~/查询/){查询=3美元;}else if ($ 2 ~/Com_select/) {Com_select=3美元;}else if ($ 2 ~/Com_insert/) {Com_insert=3美元;}else if ($ 2 ~/Com_update/) {Com_update=3美元;}else if ($ 2 ~/Com_delete/) {Com_delete=3美元;}else if ($ 2 ~/Innodb_rows_read/) {Innodb_rows_read=3美元;}else if ($ 2 ~/Innodb_rows_deleted/) {Innodb_rows_deleted=3美元;}else if ($ 2 ~/Innodb_rows_inserted/) {Innodb_rows_inserted=3美元;}else if ($ 2 ~/Innodb_rows_updated/) {Innodb_rows_updated=3美元;}else if ($ 2 ~/Innodb_buffer_pool_read_requests/) {innodb_lor=3美元;}else if ($ 2 ~/Innodb_buffer_pool_reads/) {innodb_phr=3美元;}else if($ 2 ~/正常运行时间/,,数在=2){printf (" % s | % 9 d”, strftime (“% H: % M: % s”),查询),printf (" | % 6 d % 6 d % 6 d % 6 d”, com_select, com_insert, com_update, com_delete); printf (" | % 8 d % 7 d % 7 d % 7 d”, innodb_rows_read, innodb_rows_inserted, innodb_rows_updated, innodb_rows_deleted);printf (" | % 10 d % 11 d \ n”, innodb_lor, innodb_phr);}}’
amp_setup
；；
问|问)
退出0
；；
*)
amp_setup
；；
esac
}
start_menu ()
{
amp_setup
}
start_menu MySQL巡检
