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
Tag: regression
Replication with InnoDB and MyISAM Transactions
There’s a change of behaviour in MySQL 5.1.31 for Row Based Replication, if you have InnoDB transactions that also write to a MyISAM (or other non-transactional engine) table. It’s a side effect of fixing Bug #40116. Take this simple example: Transaction 1: INSERT INTO myisam_tbl (item, val) VALUES (1, 0); Transaction 1: INSERT INTO innodb_tbl… Continue reading Replication with InnoDB and MyISAM Transactions