----- Original Message -----
From: "Sinisa Milivojevic" <sinisa@stripped>
To: "Paul Cadach" <paul@stripped>
Sent: Thursday, September 06, 2001 5:13 PM
Subject: Re: LOCK TABLES on compressed tables...
> On Wed, 5 Sep 2001 18:14:01 +0700
> "Paul Cadach" <paul@stripped> wrote:
> > Hi,
> > I'm uses write locks to prevent other people to write to table when I'm
> > updates it. When updating I need to select some additional values from
> > table, so I must lock it too. But because table is compressed (aka
> > read-only), I can't lock it with write lock. Why?
> > As I understand, write lock delays any writes to locked table performed
> > other connections until a table is unlocked. In case with compressed
> > (read-only) table, it can be treaded as 'locked for write' all times
> > LOCK TABLE ... WRITE issued.
> If you are using MyISAM tables, then you do not need to LOCK them for
UPDATE, as MySQL uses table locks for updates.
> For the same reason, locking of the table that is to be read is not
necessary as row that you are reading can not be changed while you are
I needs to perform some sequential queries (select and updates) and I must
sure that noone writes to tables at this time. For single queries I'm never