title: Optimization of Mysql table size
body: <p>I am considering a problem.</p>
  
  <p>In C language, we are suggested that the size of struct should be multiples of 2-byte.</p>
  
  <p>e.q.: </p>
  
  <pre><code>struct text{
     int index;//assume int is 4 byte.
     char [8] word;
  }//alought text is only 12 bytes, compiler would assign 16 bytes for this struct
  </code></pre>
  
  <p>Therefore, I am wondering does the record size(thanks of Gordon Linoff) of MySQL encounter the same problem?</p>
  
  <p>Moreover, how can I optimize MySQL via controlling table size?</p>