user484957 user484957 - 5 months ago 8
MySQL Question

InnoDB or MyISAM?

I have two tables: Users and Friendships.
The actions I have in the website are:


  • Register

  • Log in

  • Select friends/people from users table

  • Add people as friends



There are a little more actions but in general i wanted to know :

The Question:

Should I use InnoDB or MyISAM for the tables ?
( Or InnoDB for one and MyISAM for the other ? )

Answer

Always use InnoDB unless you specifically want to include a FULLTEXT index on a particular table. Only InnoDB enforces foreign keys, and the more referential integrity you can build into the database the better off everyone's going to be.