Hi ALL,
I have been using 5.1.24-rc and partitioning by range.
I have noticed that while doing a set of SELECT
statements on one of the partitions (e.g. p1) and at
the same time doing an ALTER TABLE with drop or add a
different partition (e.g. ALTER TABLE DROP or ADD
PARTITION p10) all the select
statements are placed on hold (Waiting for table).
Would it be possible to know the reason for that ?
My understanding was there there was a lock per
partition, instead of "lock per table" ?
Thanks in advance for your help,
Mariella
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
