Simple Cron Job Snippet that will optimize your MySQL DATABASE mysqlcheck -uXXXXX -pXXXX --all-databases --repair --optimize Change this uXXXXX with your database username Change this pXXXX with your database password