MySQL Forums
Forum List  »  Memory Storage Engine

Chat Sessions - Memory engine a good fit?
Posted by: Jackson Owens
Date: August 06, 2010 06:07PM

I have an online chat service that stores chat sessions in an InnoDB table. Each user in a chat room makes a request to the server every few seconds. The script requested needs to query the user sessions table with a SELECT statement for all the users currently in the room. But, it also needs to UPDATE the user sessions table to store information like a timestamp of the last request and the key of the last served message.

It seems like the Memory engine would be a good fit considering this data is small and expendable when there's a crash... But, I'm not sure about the high volume of UPDATE queries. Would this be okay with Memory engine's table locking or should I stay with InnoDB and its row locking?

Options: ReplyQuote

Written By
Chat Sessions - Memory engine a good fit?
August 06, 2010 06:07PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.