There seems to be an optimizer problem in 5.1, if you put a NULL in the IN clause of a SELECT. For example, given the following table: CREATE TABLE foo ( a INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (a) ); Compare these two EXPLAINs: mysql> EXPLAIN * FROM foo WHERE a IN (160000, 160001, 160002)\G… Continue reading Don’t put a NULL in the IN clause in 5.1
Author: Gary
V Festival
While not as popular as its bigger cousin Big Day Out, V Festival always manages to sign on the big names, this year being no exception. While the day didn’t start out spectacularly (it seems one of the promoters forgot to pass the door list I was on over to Ticketek), the show itself went… Continue reading V Festival
JOIN and comma precedence
Here’s a little something that might trip you up occasionally. Have a look at this test scenario: USE test; DROP TABLE IF EXISTS a; DROP TABLE IF EXISTS b; DROP TABLE IF EXISTS c; CREATE TABLE a ( a INT ); CREATE TABLE b ( b INT ); CREATE TABLE c ( c INT );… Continue reading JOIN and comma precedence
Tools of a Support Engineer
So, you’ve emailed MySQL Support, they’re working on the problem you’re having. How are they working? What tools do they use? Well, here’s my list: IRC – All MySQL Support Engineers work on IRC, it’s our main communication medium. While you’re only getting emails from one Engineer, it’s quite likely they’re consulting with several others… Continue reading Tools of a Support Engineer
Gig Of The Year: Pillowtalk
I know, it’s pretty early on in the year to be making that claim. But, I think it’s justified. First of all, the performers: Tim Freedman, of The Whitlams Pinky Beecroft, formerly of Machine Gun Fellatio, now of Pinky Beecroft and the White Russians Dave McCormack, formerly of Custard, now of Dave McCormack and the… Continue reading Gig Of The Year: Pillowtalk