This can be fixed by, rebuilding or Repairing Tables or Indexes. Follow the below steps to do this,
=-=-=--=-
Take the backup of the db using the command,
#mysqldump db > db.sql
Check size of the backup of db taken.
#du -sch db.sql
Now, remove the db,
#mysqladmin drop db
#mysqladmin create db
Restore the db using the command,
#mysql db < db.sql
=-=-=-=-=-=-
Done
=-=-=--=-
Take the backup of the db using the command,
#mysqldump db > db.sql
Check size of the backup of db taken.
#du -sch db.sql
Now, remove the db,
#mysqladmin drop db
#mysqladmin create db
Restore the db using the command,
#mysql db < db.sql
=-=-=-=-=-=-
Done