Re: evaluating table locking
InnoDB has row-level locking where as InnoDB has table level locking. If you are completing a large amount of DML (adding/inserting data) then this may effect performance.
InnoDB also has a data buffer which MyIsam does not have. Where you are selecting random records, this can have a good effect on performance as these are selected from memory buffer and not the disk.
I would also be interested in your SELECT statements. A lot of performance might be gained by optimising these statements.
Ben
Subject
Views
Written By
Posted
5328
May 19, 2008 10:32AM
2933
May 21, 2008 09:04PM
2952
May 30, 2008 05:30AM
Re: evaluating table locking
2901
May 30, 2008 08:41AM
2879
August 30, 2008 10:55AM
2645
January 21, 2009 03:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.