What does row size mean in mysql? I have a mysql db and table in myisam and it shows
Space usage Type Usage Data 1.3 GiB Index 429.1 MiB Total 1.7 GiB Row Statistics Statements Value Format static Collation utf8_unicode_ci Rows 22,000,001 Row length ø 63 Row size ø 83 B Next autoindex 22,000,002 Creation Jul 06, 2014 at 10:48 AM Last update Jul 06, 2014 at 10:54 AM Last check Jul 06, 2014 at 10:54 AM
I don't understand what does the row size mean. I tried searching on Google, but didn't find much explanation about it.
Can I use it to get the final table size after inserting N rows, by doing
row size * N rows = table size ?
Is it correct?
Let's say I am in testing phase, so I dont have much data in my table. Can this formula be used to get the table size after inserting n rows while in production phase?