Re: 5.1.24-rc and partitioning and add, drop partitions and select

[Mariella Petrini <mariellapetrini@xxxxxxxxx>]

One more question, plz

(http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations.html)
Table locks.   
The process executing a partitioning operation on a
table takes a write lock on the table. Reads from such
tables are relatively unaffected; pending INSERT and
UPDATE operations are performed as soon as the
partitioning operation has completed 

Is that true also for the InnoDB storage engine ?
What does "Reads from such tables are relatively
unaffected;" implies, please ?



Thanks,

Mariella



--- Mariella Petrini <mariellapetrini@xxxxxxxxx>
wrote:

> 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 Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:   
>
http://lists.mysql.com/internals?unsub=mariellapetrini@xxxxxxxxx
> 
> 



      ____________________________________________________________________________________
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/mysql?unsub=royale@xxxxxxxxxx