"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]
