Bug#591271: [debian-mysql] Bug#591271: Explanation and fix

2012-03-09 Thread Nicholas Bamber
There is a 5.5 in experimental that might be worth a try (in a non-production environment). On 09/03/12 22:19, Trey Raymond wrote: > This info is applicable to all 5.0.x and 5.1.x versions, I'm not sure > yet about improvements in 5.5 that might have made it irrelevant. > > On Fri, Mar 9, 2012 a

Bug#591271: [debian-mysql] Bug#591271: Explanation and fix

2012-03-09 Thread Nicholas Bamber
reassign 591271 mysql-server tag 591271 +moreinfo thanks Trey, Thanks for the new information. Could you confim what version it was obtained on? On 09/03/12 21:43, Trey Raymond wrote: > So this is what's happening here. I'll explain what it's doing for each > query, then show you the op

Bug#591271: Explanation and fix

2012-03-09 Thread Trey Raymond
So this is what's happening here. I'll explain what it's doing for each query, then show you the optimal way. SELECT MAX(sample.id) FROM sample JOIN interface ON (sample.interface= interface.id) WHERE interface.name='accounting-total' -- This is just a symptom of the optimizer being stupid. It s