how to get mysql row size in GB
mysql
Solution
To get the average row length (including overhead), use the `AVG_ROW_LENGTH` column in the information schema table:
select AVG_ROW_LENGTH from INFORMATION_SCHEMA.tables;
As far as I'm aware, there's no way to calculate the exact actual size of a single, specific row in MySQL.
Problem
Just ended up with calculating the size of MySQL table in GB with the following query. SELECT (data_length+index_length)/power(1024,3) tablesize_gb FROM information_schema.tables WHERE table_schema='db' and table_name='tablename' Is it possible to get the size of a MySQL row in GB. Or how to get the avg row size for the table in GB.