MySQL + MyISAM table size question
- by alessandro ferrucci
Hello,
I have a test table. The test table is as follows:
CREATE TABLE mytest (
num1 int(10) unsigned NOT NULL,
KEY key1 (num1)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
I inserted 50 million rows in this table.
When I do show table status the avg_row_length is 7. I was expecting to see 4 since mySQL uses 4 bytes for integers. Does the key…
