mysql-proxy-discuss team mailing list archive

[Giuseppe Maxia <g.maxia@xxxxxxxxx>]

Hi,
really puzzling indeed.
* Can you share the query that was faster under Proxy?
* Did you check if the results were the same in both cases?
* Could it be that the query through Proxy was cached?

Cheers

Giuseppe

On Fri, Sep 4, 2009 at 8:50 PM, Adrienne Porter Felt<apf@xxxxxxxxxxxx> wrote:
> Hi everyone,
> I've come across a puzzling discovery while trying to test a baseline.
>  Here's our setup: we make a connection from a python script to a local
> MySQL database through MySQL Proxy.  We're using MySQL proxy with the funnel
> modification (but I'm not sure that matters).  We are sure our queries are
> actually going through the proxy to the database (they aren't being
> reflected back by a Lua script).
> Bizarrely enough, some of our queries are running FASTER with MySQL Proxy in
> the middle than if we were just directly connecting to the database.  This
> doesn't seem to make sense -- the system with the proxy is doing strictly
> more work.
> Does anyone know why this is happening?  Have you seen this before?  We've
> gone over our measurement system repeatedly and can't find bugs (but of
> course there may still be bugs).  One thought is that MySQL Proxy is loading
> some library it shares with MySQL into memory and thereby pre-fetching the
> library for MySQL...but I don't know if that makes sense since the MySQL
> server is always running in the background anyway.
> We'd appreciate thoughts.
> Thanks!
> Adrienne
> _______________________________________________
> Mailing list: https://launchpad.net/~mysql-proxy-discuss
> Post to     : mysql-proxy-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~mysql-proxy-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>



-- 
The Data Charmer
http://datacharmer.org/