Mysql size of tables is not immediately updated after delete

Run

 OPTIMIZE TABLE Log

After deleting. This will update the index statistics (and free all unused disk-space btw).

ANALYZE TABLE tableName;

This is also possible for refreshing the table statistics.

Ref: https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html