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?
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