In mysql when you delete a row it obviously needs to be optimized. My question is, is there a way to see if the table needs to be optimized from php/mysql command? In phpmyadmin it shows in red that the table has overhead. So perhaps there is a way to see if there is overhead in a table?

Thanks
Silly