[Chrysm]

If you are using windows that MySQL program, MySQL Control Center has a right click context. Right click on tables and select tools and click optimize. You don't have to do it for each table just the unexpanded table list and it will do all of them and show you what the output was. If you use phpmyadmin the function is also there and when you refresh your table after optimization (if it did anything) your table should be reduced in size