You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
time for table in $(echo "SELECT concat(concat(table_schema,'.',table_name), '|', concat(round((data_length+index_length)/(1024*1024*1024),2),'G')) FROM information_schema.TABLES ORDER BY data_length+index_length DESC LIMIT 10" | mysql -N -r -u $mysql_user -h $mysql_host -p$mysql_pass)
do
name=$(echo $table | cut -d '|' -f 1)
size=$(echo $table | cut -d '|' -f 2)
echo "Warming up table $name, Size: $size"
echo "SELECT COUNT(*) FROM $name" | mysql -N -r -u $mysql_user -h $mysql_host -p$mysql_pass