The corrosion of Aaron Stone


Things that make MySQL dumb,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,

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