Lock contention
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
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.