##注释：本脚本必须手动单次调度，不能在生产环境运行

cat /home/tidb/scripts/analyze.sh

#!/bin/bash

tidbHost="127.0.0.1"
tidbPort=4000
tidbUser="root"
tidbPassword="gin"

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','METRICS_SCHEMA');")
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 "set @@session.tidb_distsql_scan_concurrency=60;set @@session.tidb_index_serial_scan_concurrency=10;set @@session.tidb_build_stats_concurrency=60;analyze table \`$tidbtable\`"
                echo "`date` | $tidbschema.$tidbtable analyze done"
    done
done

date