?

Log in

No account? Create an account

Previous Entry | Next Entry

Things that make MySQL dumb

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.

Originally published at HydricAcid. You can comment here or there.

Tags:

Comments

( 2 comments — Leave a comment )
meg
Oct. 20th, 2007 07:16 am (UTC)
Let me be the first to say it. HAPPY BIRTHDAY! Hope it turns out in your favor. :)
sodabrew
Oct. 20th, 2007 08:36 am (UTC)
Thanks! :-)
( 2 comments — Leave a comment )

Latest Month

May 2009
S M T W T F S
     12
3456789
10111213141516
17181920212223
24252627282930
31