The Corrosion of Aaron Stone

http://forums.mysql.com/read.php?92,133026,133102

Hi. Since the updates on a memory table should be very fast, the locks are taken for a very short time only. I won’t expect that they become a bottleneck. But I must admit that I don’t have any experiences with applications like this. If they do indeed become a bottleneck, you could try to use a transactional engine that uses row level locks, like InnoDB. But I guess that the overhead will outweigh the improvements in locking. Regards Ingo

Ingo Strüwing, Senior Software Developer - Storage Engines MySQL AB, www.mysql.com

Ouch, man. That’s my cerebellum you’re destroying.

This entry was posted on Friday, October 19th, 2007 at 4:56 pm and is filed under General. You can follow responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your site.