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
[email protected]
On Mon, Nov 15, 2010 at 1:03 PM, Mark Leith <[email protected]>
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.
_______________________________________________
Mailing list: https://launchpad.net/~mysql-proxy-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mysql-proxy-discuss
More help : https://help.launchpad.net/ListHelp
