title: Estimated Row Size for InnoDb query - buffer size greater than configured maximum
body: <p>What would an estimated row size in bytes be for a query that returns the following:</p>
  
  <pre><code>CHAR(255) x 10 columns
  TIMESTAMP x 1 column
  INT(11) x 2 columns
  </code></pre>
  
  <p>Does the actual content determine the size or is it the above info.  If the actual content how can I calculate a good estimate?</p>
  
  <p>Reading around I estimate 2562 based on (using latin1 charset):</p>
  
  <pre><code> 2 x INT(11)    = ( 2 x 4    )     8
   1 x TIMESTAMP  = ( 1 x 4    )     4
  10 x CHAR(255)  = ( 10 x 255 )   2550
                                  -----
                                   2562
  </code></pre>
  
  <p>Is that right?</p>
  
  <p>I'm setting the properties of an SSIS package ADO .NET source to:</p>
  
  <pre><code>DefaultBufferMaxRows:    10000
  DefaultBufferSize:       25620000
  </code></pre>
  
  <p>The problem is the DefaultBufferSize was higher than this before and I was getting errors:</p>
  
  <blockquote>
    <blockquote>
      <p>Rows in buffer type 0 would cause a buffer size greater than the configured maximum. There will be only 1835 rows in buffers of this type.</p>
    </blockquote>
  </blockquote>