This post was published 8 years, 11 months ago. Due to the rapidly evolving world of technology, some concepts may no longer be applicable.
A one-liner to optimize all MySQL tables, in all databases. Be advised that running optimize on InnoDB does a ‘recreate and analyze’. Run as root in the example below.
mysqlcheck -o -u root -p --all-databases