…be found in the 5.5.16-22.0 milestone at Launchpad. New Features InnoDB Fake Changes…-lru-restore), which is OFF by default. When set to ON, restoring from the LRU dump file… assertion failure in InnoDB. #814404 (Yasufumi Kinoshita). Since AUTO_INCREMENT columns must be defined as keys, omitting key…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
… release can be found in the 5.5.27-28.0 milestone at Launchpad. New Features: Percona Server supports tunable buffer… … ON DUPLICATE KEY UPDATE statements on a table with an AUTO_INCREMENT column could result in spurious duplicate key errors (and, as… it’s setting up the innodb_lazy_drop_table to 1. Release notes for Percona Server 5.5.27-28.0 are…
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
… a SHOW CREATE TABLE we’d see that the AUTO_INCREMENT counter is currently set to 2. If we do an INSERT … ODKU… | +—-+———-+———+———————+ 1 row in set (0.00 sec) And now, even though we didn’t insert a new row, our auto-increment counter has increased… in set (0.00 sec) Yep, it’s actually THE LAST ROW, the one where the id is equal to the auto-increment max…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…_length: 37 Data_length: 78233600 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2008-04-24 00:54…> select count(*) from cbool where c1=NULL; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.20 sec) You can use IS NULL operator which…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
…_log_pos 1593 Query thread_id=18 exec_time=0 error_code=0 SET TIMESTAMP=1323820314/*!*/; INSERT INTO t VALUES(YEAR(CURDATE())) If…-22.1. AUTO INCREMENTAL VALUES In order to have the same auto incremental values on master and slaves the actual used auto incremental value is logged…_ID is the next auto incremental value: #111214 21:54:06 server id 1 end_log_pos 203 Intvar SET INSERT_ID=6…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…(id INT AUTO_INCREMENT PRIMARY KEY, c FLOAT) ENGINE=InnoDB; Query OK, 0 rows affected (0.00 sec) …0.000002 | | end | 0.000007 | | query end | 0.000003 | | closing tables | 0.000008 | | freeing items | 0.000021 | | cleaning up | 0.000003 | +——————————+———–+ 18 rows in set (0…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… the InnoDB auto-inc scalability issue with MySQL 5.0 and older versions, employing other techniques to maintain the PK auto incremental becomes more… set (0.00 sec) mysql> INSERT INTO `huge_table` (text) VALUES (‘test’); ERROR 1062 (23000): Duplicate entry ‘0‘ for key 1 Unfortunately, adding auto_increment…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… used to advice on the compression page settings by looking at compressed page size distribution … of auto increment values needed or if we get behavior change by having potential “holes” when auto increment … with them available. With current MySQL 5.0 I still see Innodb having serious scalability …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… t1(i int(11) not null auto_increment primary key) ENGINE=InnoDB; Query OK, 0 rows affected (0.09 sec) session1 > insert into t1… | +—+ | 1 | +—+ 1 row in set (0.00 sec) session2 > CREATE TABLE t1(i int(11) not null auto_increment primary key) ENGINE=InnoDB; When… different reason): session2 > set session lock_wait_timeout=1;CREATE TABLE t1(i int(11) not null auto_increment primary key) ENGINE=InnoDB…
Post: Extending Index for Innodb tables can hurt performance in a surprising way
May 22, 2010 By 10 Comments
… NULL AUTO_INCREMENT, `a` int(11) NOT NULL, `b` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `a` (`a`) ) ENGINE=InnoDB AUTO_INCREMENT=6029313 DEFAULT CHARSET=latin1 mysql> select count(*) from idxitest where a=5 and b=5; +———-+ | count(*) | +———-+ | 60434 | +———-+ 1 row in set (0…
