MySQL patrol inspection

Query tables that are not innodb engines

Select TABLE_NAME,TABLE_SCHEMA,engine from information_schema.tables where engine='MyISAM' and TABLE_SCHEMA not in ('mysql','performance_schema','information_schema')

Check the current qps and tps, and so on #! / bin/bash/usr/bin/mysqladmin-P3306-uroot-p extended-status-i1 | awk 'BEGIN {local_switch=0 Print "QPS Commit Rollback TPS Threads_con Threads_run\ nMurray -"} $2 ~ / Queries$/ {QQ quotation 4;} $2 ~ / Com_commit$/ {caterpillar 4 } $2 ~ / Com_rollback$/ {if 4;} $2 ~ / Threads_connected$/ {tc=$4;} $2 ~ / Threads_running$/ {tr=$4; if (local_switch==0) {local_switch=1; count=0} else {if (count > 10) {count=0 Print "- -\ nQPS Commit Rollback TPS Threads_con Threads_run\ nMurray -" } else {count+=1; printf "%-6d%-8d%-7d%-8d%-10d% d\ n", qmeme crecedence cprecedence tcjurisdiction trr;} 'View multiple instance select insert update delete conditions #! / bin/bashsetup_select () {clearcat