MySQL Forums
Forum List  »  Performance

Re: Correlated subquery taking much much longer since upgrade from 5.0
Posted by: Alan Douglas
Date: July 05, 2012 05:04AM

Thank you for taking the time to look at this.

I don't believe the problem is the client. 5.0, 5.1, and 5.5 are on three different machines, and we are using the local client on each machine. We also see the same problem using perl DBI.

The 5.1 is on a recent new install of Ubuntu 10.04 with no previous MySQL versions on it. The 5.5 is on a brand new install of Ubuntu 12.04 on a brand new machine set up specifically to investigate this.

Pehaps your 4s time was the result of the query cache? If not, then I'd be interested to know more about your setup.

Using the 5.1 client to connect to 5.1 server on same machine in the way you descibe yields a time of 75m58.949s

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.