New answers tagged parameter
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 ...
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