mysql:warmup
ウォームアップ用スクリプト
#/bin/bash
USR='root'
PWD='password'
for TABLENAME in `mysql -u ${USR} -p${PWD} -N -s -e "SELECT concat(TABLE_SCHEMA,\".\",TABLE_NAME) as TABLE NAME FROM information_schema.tables WHERE TABLE_SCHEMA like 'PREFIX_%' AND TABLE_TYPE = 'BASE TABLE' AND ENGINE = 'InnoDB';"`;
do
mysql -u ${USR} -p${PWD} -N -s -e "SELECT * FROM $TABLENAME;" > /dev/null
done;
###
### -N: カラム名を出力しない
### -s: セパレータをタブに置換
###
mysql/warmup.txt · 最終更新: 2014/02/26 08:12 by clownclown