#!/bin/sh
host="localhost"
user="root"
password="root"
database="dbname"
compression="lz4"
mysql -h${host} -u${user} -p${password} --skip-column-names -e \
"select concat('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' COMPRESSION=\"${compression}\";'), concat('OPTIMIZE TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,';')
 from information_schema.TABLES where TABLE_SCHEMA='${database}';" | mysql -h${host} -u${user} -p${password}