title: How to Get True Size of MySQL Database?
body: <p>I would like to know how much space does my MySQL database use, in order to select a web host.
  I found the command <code>SHOW TABLE STATUS LIKE 'table_name'</code> so when I do the query, I get something like this:</p>
  
  <pre><code>Name       | Rows | Avg. Row Length | Data_Length | Index Length
  ----------   ----   ---------------   -----------   ------------
  table_name   400          55            362000        66560
  </code></pre>
  
  <ul>
  <li>numbers are rounded.</li>
  </ul>
  
  <p>So do I have <strong>362000</strong>  or 400*362000 = <strong>144800000</strong> bytes of data for this table?
  And what does Index Length mean?
  Thanks !</p>