Re: evaluating table locking
thank you for your answer.
well i think that the problem is about the way that i'm selecting from the tables.
i've tried to measure the hd-activity with some linux tools, and i remember that the hd was only at 10% of activity, so there must be some other bottle neck. that's why i now think about locks.
i've just used mytop-utility to look on the queries in my system. i found out that sometimes i have about 10-15 queries that are locked and are waiting for 1-2 queries that are beeing executed. i think that would not be so if i would use an engine with row level locking. but i'm not sure
Subject
Views
Written By
Posted
5326
May 19, 2008 10:32AM
2933
May 21, 2008 09:04PM
Re: evaluating table locking
2950
May 30, 2008 05:30AM
2900
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.