On 18.05.2010, at 17:22, Shawn Heisey wrote:

> On 5/14/2010 12:40 PM, Shawn Heisey wrote:
>> I downgraded to 5.0.8 for testing. Initially, I thought it was going to be 
>> faster, but it slows down as it gets further into the index.  It now looks 
>> like it's probably going to take the same amount of time.
>> 
>> On the server timeout thing - that's a setting you'd have to put in my.ini 
>> or my.cfg, there may also be a way to change it on the fly without 
>> restarting the server.  I suspect that when you are running a multiple query 
>> setup like yours, it opens multiple connections, and when one of them is 
>> busy doing some work, the others are idle.  That may be related to the 
>> timeout with the older connector version.  On my setup, I only have one 
>> query that retrieves records, so I'm probably not going to run into that.  I 
>> could be wrong about how it works - you can confirm or refute this idea by 
>> looking at SHOW PROCESSLIST on your MySQL server while it's working.
> 
> I was having no trouble with the 5.0.8 connector on 1.5-dev build 922440M, 
> but then I upgraded the test machine to the latest 4.0 from trunk, and ran 
> into the timeout issue you described, so I am going back to the 5.1.12 
> connector.  I just saw the message on the list about branch_3x in SVN, which 
> looks like a better option than trunk.


Any news on this topic?

regards,
Lukas Kahwe Smith
m...@pooteeweet.org



Reply via email to