Locks

Hi,

What happen when there is a select query given to a table of MYISAM
engine type? I suppose to think, there might occur a read lock which
is a sharable lock. My doubt is will that table allows inserts same as
when select is in progress...


Regards,

On Mon, 30 Jul 2007 17:42:42 -0000, Dhandapani S wrote:
> Hi,
>
> What happen when there is a select query given to a table of MYISAM
> engine type? I suppose to think, there might occur a read lock which
> is a sharable lock. My doubt is will that table allows inserts same as
> when select is in progress...

What problem are you trying to solve?

--
6. I will not gloat over my enemies' predicament before killing them.
--Peter Anspach's list of things to do as an Evil Overlord