Optimize MYSQL Database
Posted on 2013-06-19
Hoping someone with patience can walk me through optimizing a MYSQL database as I am new to MYSQL. I have never understood why developers don't clear white space in files as part of a general/common routine.
Anywho, the database that I'm trying to shrink/optimize white space is a Sonicwall Viewpoint MYSQL database = gmsdatabase.
I have the MySql workbench 5.2. I'm able to open the database but how do I optimize all tables in all databases? I have tried OPTIMIZE, MYSQLCHECK, it doesn't recognize the commands. I wish I could just right click on the database and select Optimize. You would think that something so common would be right there.... Uggghhhh