mysql-proxy-discuss team mailing list archive

[Adrienne Porter Felt <apf@xxxxxxxxxxxx>]

Sadly no, there are no VMs involved.  Running on Mac OS 10.5.7.

On Fri, Sep 4, 2009 at 1:30 PM, Mike Frank <Michael.Frank@xxxxxxx> wrote:

> This probably isn't it, but just to throw this our there -- is this per
> chance running on virtual machines?
>
> -- the reason I ask -- if you run 2 (or more) virtual servers on the same
> hypervisor you will get bus level data transfer through the virtual nics. So
> sometimes folks see  higher speeds they might not expect through virtual
> nics if they are local to a common hypervisor versus a test where the
> network is in play.
>
>
> Giuseppe Maxia wrote:
>
>> 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
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>
> --
> Mike Frank
> Senior Product Manager, Database Group
> Sun Microsystems
> michael.frank@xxxxxxx
> Accessline: 713-493-7591
> Cellular: 713-825-5391
> Skype: mfranktexas
>
>