Re: Lock Tables - Manual Ambiguity
"Primaria Falticeni" <[EMAIL PROTECTED]> wrote: > So, when client X has Read lock, the client Y cannot have Write lock, Egor? Yes, if client X obtaines read lock on the table client Y can't have write lock on this table until client X releases lock. > > Iulian > - Original Message - > From: "Egor Egorov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, June 18, 2003 1:33 PM > Subject: Re: Lock Tables - Manual Ambiguity > > >> "K.L." <[EMAIL PROTECTED]> wrote: >> > The 3.23.54 Manual states in; >> > >> > Section 1.4.4.3 Transactions >> > >> > "If you only obtain a read lock (as opposed to a write lock), then reads > and >> > inserts are still allowed to happen. The new inserted records will not > be seen >> > by any of the clients that have a READ lock until they release their > read locks >> > " >> > >> > But in Section 6.7.2 Lock Tables/Unlock Tables Syntax >> > >> > "If a thread obtains a READ lock on a table, that thread (and all other > threads) >> > can only read from the table. If a thread obtains a WRITE lock on a > table, then >> > only the thread holding the lock can READ from or WRITE to the table." >> > >> > >> > What am I missing pls? Can I, with a "READ" Lock, still write to the > table? >> >> Only thread that obtains lock on the table can write to the table. >> >> > Is the following assumption correct? >> > >> > "READ" Lock - Thread/Client with Lock, can write to locked Table, and is > ONLY >> > ONE who can until Lock released. >> >> Sure. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lock Tables - Manual Ambiguity
So, when client X has Read lock, the client Y cannot have Write lock, Egor? Iulian - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 1:33 PM Subject: Re: Lock Tables - Manual Ambiguity > "K.L." <[EMAIL PROTECTED]> wrote: > > The 3.23.54 Manual states in; > > > > Section 1.4.4.3 Transactions > > > > "If you only obtain a read lock (as opposed to a write lock), then reads and > > inserts are still allowed to happen. The new inserted records will not be seen > > by any of the clients that have a READ lock until they release their read locks > > " > > > > But in Section 6.7.2 Lock Tables/Unlock Tables Syntax > > > > "If a thread obtains a READ lock on a table, that thread (and all other threads) > > can only read from the table. If a thread obtains a WRITE lock on a table, then > > only the thread holding the lock can READ from or WRITE to the table." > > > > > > What am I missing pls? Can I, with a "READ" Lock, still write to the table? > > Only thread that obtains lock on the table can write to the table. > > > Is the following assumption correct? > > > > "READ" Lock - Thread/Client with Lock, can write to locked Table, and is ONLY > > ONE who can until Lock released. > > Sure. > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lock Tables - Manual Ambiguity
"K.L." <[EMAIL PROTECTED]> wrote: > The 3.23.54 Manual states in; > > Section 1.4.4.3 Transactions > > "If you only obtain a read lock (as opposed to a write lock), then reads and > inserts are still allowed to happen. The new inserted records will not be seen > by any of the clients that have a READ lock until they release their read locks > " > > But in Section 6.7.2 Lock Tables/Unlock Tables Syntax > > "If a thread obtains a READ lock on a table, that thread (and all other threads) > can only read from the table. If a thread obtains a WRITE lock on a table, then > only the thread holding the lock can READ from or WRITE to the table." > > > What am I missing pls? Can I, with a "READ" Lock, still write to the table? Only thread that obtains lock on the table can write to the table. > Is the following assumption correct? > > "READ" Lock - Thread/Client with Lock, can write to locked Table, and is ONLY > ONE who can until Lock released. Sure. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lock Tables - Manual Ambiguity
Hi All, The 3.23.54 Manual states in; Section 1.4.4.3 Transactions "If you only obtain a read lock (as opposed to a write lock), then reads and inserts are still allowed to happen. The new inserted records will not be seen by any of the clients that have a READ lock until they release their read locks " But in Section 6.7.2 Lock Tables/Unlock Tables Syntax "If a thread obtains a READ lock on a table, that thread (and all other threads) can only read from the table. If a thread obtains a WRITE lock on a table, then only the thread holding the lock can READ from or WRITE to the table." What am I missing pls? Can I, with a "READ" Lock, still write to the table? Is the following assumption correct? "READ" Lock - Thread/Client with Lock, can write to locked Table, and is ONLY ONE who can until Lock released. Thanks in Advance [Filter: SQL MySQL] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]