GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

row-locking innodb

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • row-locking innodb

    Having an MyISAM-Table.
    When an Update comes in it haves to wait till a privios (already started) SELECT ends.
    Having a very time-consuming SELECT (for reporting) "stops" the database.
    I think about switching to INNODB (row-level-locking).
    Will Updates be performed while the former SELECT is still running?

  • #2
    I've just tested it - and yes, I can confirm that when doing time-consuming select on MyISAM table and trying to update this table at the same time, update takes a very long time (for example, 1.6 seconds on my very old test computer).
    If I convert the same table into InnoDB and do the same select, and try to update table, updates are done in ~0.01-0.02 seconds on the same computer.
    So I believe changing table engine to InnoDB can help you to improve performance.

    Comment


    • #3
      yes it works great.
      thx

      Comment

      Working...
      X