mysqldatabase-optimizationdatabase-engine

best engine for high-performance counts table


I have a counts table which contains columns similar to (around 14 count columns):

user_id
friends_count
photo_count
video_count
blogs_count

This table gets updated whenever the user adds a photo or a friend.

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.

Which engine is best suited for most writes and most reads like this?


Solution

  • I looked at the different articles and especially these three links

    http://www.oracle.com/partners/en/knowledge-zone/mysql-5-5-innodb-myisam-522945.pdf

    Should I use MyISAM or InnoDB Tables for my MySQL Database?

    http://www.quora.com/Which-MySQL-Storage-engines-are-used-by-Facebook

    and came to conclusion it is better to go ahead with InnoDB .

    Any comments on this also appreciated

    Thanks and Regards

    Kiran