title: how to get mysql table size in GB
body: <p>Just ended up with calculating the size of MySQL table in GB with the following query.</p>
  
  <blockquote>
    <p>SELECT (data_length+index_length)/power(1024,3) tablesize_gb FROM
    information_schema.tables WHERE table_schema='db' and
    table_name='tablename'</p>
  </blockquote>
  
  <p>Is it possible to get the size of a MySQL row in GB.</p>
  
  <p>Or how to get the avg row size for the table in GB. </p>