MySQL Forums
Forum List  »  MyISAM

Lock contention
Posted by: chintan sanghvi
Date: August 19, 2009 06:36PM

I have a Myisam table with 3.5 Million rows. My queries are mostly insert and delete. Very few selects. Because, I use this table only as a backup arm.
my Table lock status is:
Table_locks_immediate 5153419
Table_locks_waited 8784465

What could be possible causing the Table Locks waited to bloat up, while in the past i have been using this same system with roughly following values:
Table_locks_immediate 3977738
Table_locks_waited 1884544

Any help will be really appreciated

Options: ReplyQuote


Subject
Views
Written By
Posted
Lock contention
5182
August 19, 2009 06:36PM
2551
August 20, 2009 08:52PM


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.