pbxt-discuss team mailing list archive

[Paul McCullagh <paul.mccullagh@xxxxxxxxx>]

Hi Brian,

thanks for heads up. I will check it out.

Best regards,

Paul

On Aug 6, 2010, at 12:43 AM, Brian Aker wrote:

> Hi!
>
> So I have noticed that in HA_STATUS_CONST you are updating the  
> global table share. I am not positive about this, but it looks like  
> it is quite possible for additional readers to come along and look  
> at the keymap you are replacing. According to the documentation  
> MySQL has a read lock on the table while ANALYZE is being run (and  
> from a brief glance it looks like MyISAM might be setting one for  
> thr as well). If you are overwriting the global indexes while this  
> happens I think you might have an issue.
>
> I do know from looking at Drizzle that you can stomp the keymap  
> while doing this. I would think it would make sense to what Innodb  
> is doing for concurrency reasons (which is that I believe it just  
> updates the local keycap).
>
> Just my 0.02 about it.
>
> Cheers,
>   -Brian
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~pbxt-discuss
> Post to     : pbxt-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~pbxt-discuss
> More help   : https://help.launchpad.net/ListHelp