I have an Innodb table which is over 400GB and performing quite a lot of deletes on it, so I thought I should try to optimize the free space kept it is probably creating. I ran this query to find out how much it was:
SELECT table_schema, table_name, data_free / 1024 / 1024 AS data_free_MB FROM information_schema.tables WHERE ENGINE LIKE 'InnoDB';
But according to the report it's only 4MB. Is that possible??