Optimize all tables in all MySQL databases for VestaCP user (for better performance in InnoDB engine)

mysql_optimize_databases.sh

#!/bin/bash

# Optimize all tables in all MySQL databases for VestaCP user (for better performance in InnoDB engine)
# set 'chmod +x' 
# and add this script in your weekly cron

VESTA_USER="vestacp_username"


MYSQL_DBS=$(mysql -e "show databases like '${VESTA_USER}_%';" | awk '{ if ($1 != "Database") print $1 }')
for DB in $MYSQL_DBS; do
#    echo "[$DB]"
    mysqlcheck -o $DB
done

No, as far as I remember there was something else besides these lines :)