Aaron (sodabrew) wrote,
Aaron
sodabrew

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: general
Subscribe

  • Migrating to SodaBrew.com!

    At some point I’ll provide post-to-post redirects, but for now, new content is at sodabrew.com. Cheers! Originally published at…

  • Bottle Return

    When I was in the Czech Republic in March 2007, I went to see a movie called  Vratné lahve, which in Czech means “Bottle Return” —…

  • Plugin Strategies in Open Source, Part 2

    In any project, feature-creep can be a problem. In an open source project, this can be particularly acute when there are few developers. Worse yet,…

  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 2 comments