patternsqlMinor
What's row size in mysql?
Viewed 0 times
sizerowmysqlwhat
Problem
What does row size mean in mysql? I have a mysql db and table in myisam and it shows
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?
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 AMI 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?
Solution
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:
Convert result in Giga Bytes:
Total = 1.7 GiB
Max
row size * N rows = table size
Row size = 83 B
Rows = 22,000,001
Row Size times Number of rows:
83 * 22000001 = 1826000083Convert result in Giga Bytes:
1826000083 / 1024 / 1024 / 1024 = 1.7Total = 1.7 GiB
Max
Code Snippets
83 * 22000001 = 18260000831826000083 / 1024 / 1024 / 1024 = 1.7Context
StackExchange Database Administrators Q#69818, answer score: 2
Revisions (0)
No revisions yet.