Tag Info

New answers tagged

1

Table size is made up of 3 main factors Data Indexes Fragmentation Data size is simply a matter of row size by number of rows. Index size for MyISAM is dealt with here - (key_length+4)/0.67, summed over all keys). A great post explaining fragmentation is here and another good one is here. Fragmentation (indexes and actual data) increases the processing ...


2

Yes it's the average size of each row in your table. row size * N rows = table size Row size = 83 B Rows = 22,000,001 Row Size times Number of rows: 83 * 22000001 = 1826000083 Convert result in Giga Bytes: 1826000083 / 1024 / 1024 / 1024 = 1.7 Total = 1.7 GiB Max



Top 50 recent answers are included