mysql-proxy-discuss team mailing list archive

[Mark Leith <mark.leith@xxxxxxxxxx>]

On 15 Nov 2010, at 11:08, Liran Zelkha wrote:

> Hi Mark
>
> Thank you for your response. Is that done on the plugin level or  
> internally in the server?


You mean the lua layer? It's global in the chassis if so.. The first  
step to multi-threading it will be pulling it in to a plugin of it's  
own.

Regards,

Mark


> Thank You,
> Best Regards,
>
> Liran Zelkha
> Tel US: (617)-943-7344
> Tel Israel: +972-54-3010714
> liran.zelkha@xxxxxxxxxxxxx
>
>
> On Mon, Nov 15, 2010 at 1:03 PM, Mark Leith <mark.leith@xxxxxxxxxx>  
> wrote:
> Hi Liran,
>
>
> On 14 Nov 2010, at 20:42, Liran Zelkha wrote:
>
> I have a weird issue.
> I am executing a query against a mysqlproxy instance, and my lua  
> script executes a query directly against a database, gets the  
> response, wraps it and returns a proxy.PROXY_SEND_RESULT.
> This works nicely. The problem is that if one query is blocked (for  
> example, trying to select data from a locked table), no other query  
> can execute against the mysqlproxy.
>
> Any way around it? I played with the event-thread parameter, to no  
> avail.
>
>
> The event-thread parameter is for network event threads - things  
> coming in off the wire - for the most part. There is a major body of  
> work coming up in the 0.9 series for MySQL Proxy that will also  
> multi-thread the lua layer as well. Currently the lua layer is a  
> single thread, at a global level.
>
> This means that currently anything that you do use to wrap a  
> statement should be as light weight as possible. I would certainly  
> not recommend running statements against a table that could be  
> locked entirely.
>
> Best regards
>
> Mark
>
> --
> Mark Leith
> Software Development Senior Manager
> MySQL Enterprise Tools @ Oracle Corp.

Best regards

Mark

--
Mark Leith
Software Development Senior Manager
MySQL Enterprise Tools @ Oracle Corp.