Table copy - result table smaller than original table

SmokingGnu posted 2 weeks ago in General

HeidiSQL version 9.5.05196 (64 Bit)

I copied a table using Create New > Table copy for backup purposes, and noticed that the resulting backup table was smaller (6.5 MiB) than the original (8.2 MiB).

I am not familiar enough with HeidiSQL or MySql to know if that is expected behavior or if there is something not being copied.

Any help, information, or words of wisdom would be appreciated.

kalvaro posted 2 weeks ago

When MySQL Server copies a table it doesn't probably care about deleted rows. You should check row count rather than raw bytes.

SmokingGnu posted 2 weeks ago

Row count is indeed the same for both tables, so you are probably right, thanks.

Please login to leave a reply, or register at first.