… MySQL version 5.1.22 or newer? If so, you probably have gaps in your auto-increment columns. A simple INSERT IGNORE query creates gaps for every ignored insert, but this is undocumented behaviour. This… but with a small cost. Queries like INSERT … ON DUPLICATE KEY UPDATE produce gaps on the auto_increment column. To avoid this…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… number of other environments. INSERT ON DUPLICATE KEY UPDATE had a unfair share of replication issues in MySQL 5.0. There are number… functionality is used. Happily there are only few INSERT ON DUPLICATE KEY UPDATE query instances, and only one of them into table…. This was not the issue for application and could be ignored. So at this point we were sure the write traffic…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…mysql.com/bug.php?id=34058, this has since been fixed (this bug was marked as duplicate of http://bugs.mysql…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…, 300024 rows affected (13.28 sec) Records: 300024 Duplicates: 0 Warnings: 0 mysql> update employees set age = ((YEAR(CURDATE())-YEAR(birth_date)) – (RIGHT…. [root@sb logs]# cat mysql-data-201202230157-binlog-info File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000022 336796712 Using the…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…. There are probably similar problems in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible to… patch out where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like to see…. IO Scalability patches Mark Callaghan from Google released so many MySQL patches so we can call patched version GoogleSQL. Among them…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…a temporary table, secondary indexes are updated by inserting individual rows rather than …Duplicates: 0 Warnings: 0 mysql> SET expand_fast_index_creation=ON; Query OK, 0 rows affected (0.00 sec) mysql… restore slower; mysqldump –innodb-optimize-keys ignores indexes on AUTO_INCREMENT columns, because…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 2 Comments
…running MySQL Master-Master replication pairs in …updated or deleted is not found in addition to duplicate key errors, if you set slave_exec_mode=IDEMPOTENT both duplicate key error and row not found errors will be ignored…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
July 16, 2008 By 46 Comments
… small issue. If you try to update a record with the same data as in table, mysql ignore the query (affected rows => 0… INSERT INTO query is executed and an error will occur (duplicate entry cos’ of the primary index) INSERT INTO forum_sessions…
