title: best engine for high-performance counts table
body: <p>I have a <code>counts</code> table which contains columns similar to (around 14 count columns):</p>
  
  <pre><code>user_id
  friends_count
  photo_count
  video_count
  blogs_count
  </code></pre>
  
  <p>This table gets updated whenever the user adds a photo or a friend.</p>
  
  <p>I am going with InnoDB Engine since it is better to have row locking, but in the meantime also there are good number of reads on this table. For every user when they see profile of other user or even the users side menu contains all these counts. </p>
  
  <p>Which engine is best suited for <strong>most writes and most reads</strong> like this?</p>