With increasing data, mysql tables can get defragmented and it is a good idea to
optimize tables every once in a while.Getting the list of all tables that need
optimization :> mysql -p -e “select
concat(TABLE_SCHEMA,’.’,TABLE_NAME),Data_free from information_schema.TABLES
where TABLE_SCHEMA