##注释：脚本统一部署在： /home/tidb/scripts 下


cat /home/tidb/scripts/analyze.sh

#!/bin/bash

tidbHost="10.26.2.2"
tidbPort=4000
tidbUser="******"
tidbPassword="*****"

date

for tidbschema in $(mysql -h$tidbHost -P$tidbPort -u$tidbUser -p$tidbPassword -Nse "select schema_name from information_schema.schemata where schema_name not in ('INFORMATION_SCHEMA','PERFORMANCE_SCHEMA','mysql');")
do
    for tidbtable in $(mysql -h$tidbHost -P$tidbPort -u"$tidbUser" -p"$tidbPassword" -D"$tidbschema"  -Nse "show tables")
    do
        mysql -h$tidbHost -P"$tidbPort" -u"$tidbUser" -p"$tidbPassword" -D"$tidbschema" -e "analyze table \`$tidbtable\`;" 
        echo "`date` | \`$tidbschema\`.\`$tidbtable\` analyze done"
    done
done

date