Warm up MySQL caches: `./warm-up-mysql.sh db-name`

warm-up-mysql.sh

#!/bin/bash
echo "SELECT
  CONCAT('SELECT ',MIN(c.COLUMN_NAME),' FROM ',c.TABLE_NAME,' WHERE ',MIN(c.COLUMN_NAME),' IS NOT NULL;')
FROM
  information_schema.COLUMNS AS c
LEFT JOIN (
  SELECT DISTINCT
    TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
  FROM
    information_schema.KEY_COLUMN_USAGE
) AS k
USING
  (TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME)
WHERE
  c.TABLE_SCHEMA = '$1'
  AND k.COLUMN_NAME IS NULL
GROUP BY
  c.TABLE_NAME;" | mysql | grep -v 'CONCAT(' | \
while read i ; do
echo -n $i | sed 's/.*FROM \(.*\) WHERE.*/\1/'
echo -n " + ";
echo $i | mysql | wc -l;
done;