Re: LOCK TABLES on compressed tables...

[Michael Widenius]

Hi!

>>>>> "Paul" == Paul Cadach <paul@stripped> writes:

<cut>

Paul> I needs to perform some sequential queries (select and updates) and I must
Paul> sure that noone writes to tables at this time. For single queries I'm never
Paul> uses locks...

In this case you should lock tables that you only read from with a
READ lock and other with a WRITE lock.

Having a READ lock on a table will ensure that no one thread will
write to it.

Regards,
Monty