Which MySQL database engine is better for storing sessions and session data: MyISAM or InnoDB? Which MySQL database engine is better for storing sessions and session data: MyISAM or InnoDB? php php

Which MySQL database engine is better for storing sessions and session data: MyISAM or InnoDB?


Since you're looking at a pretty even mix of read/write traffic, InnoDB is the better choice. MyISAM's full-table locks on every write would probably be murder. MyISAM fairs better with 90%+ read or 90%+ write situations.

I believe that's mentioned in High Performance MySQL