Table copy - result table smaller than original table

[expired user #11325]'s profile image [expired user #11325] posted 6 years ago in General Permalink

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's profile image kalvaro posted 6 years ago Permalink

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

[expired user #11325]'s profile image [expired user #11325] posted 6 years ago Permalink

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.