Re: Manual Locks not displayed in the Show Full processlist
Quote
I tried locking the table by using ... LOCK TABLE TABLENAME WRITE;
Why do you feel the need to do this?
Locking an entire table is a pretty Draconian thing to do, especially in a multi-user system where it will
cripple your application's performance and lead to [major] problems if your network and/or applications are not completely reliable.
The proper use of Transactions all but
eliminates the need to take locks at table level. I don't think I've locked a table in over a decade.
Regards, Phill W.
Subject
Written By
Posted
Re: Manual Locks not displayed in the Show Full processlist
May 21, 2018 04:57AM
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.