… in slave server is not working because of an error: Last_SQL_Error: Error ‘Duplicate entry ’4′ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert into …SQL_SLAVE_SKIP_COUNTER doesn’t work with GTID we need to find a way to ignore that…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825… duplicates. This problem is avoided when upgrading to Percona Server …server was closed leading to an unappropriated network error and stopping the Slave SQL… ignore-builtin-innodb is incompatible with Percona Server with XtraDB, the server…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…00 sec) Records: 1 Duplicates: 0 Warnings: 0 . . . mysql> INSERT INTO t(c) …is loaded.” mysqldump in Percona Server supports the new option –… > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql real …slower; mysqldump –innodb-optimize-keys ignores indexes on AUTO_INCREMENT columns…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
…at /percona-server/5.5/Percona-Server-5.5.25a-rel27.1/sql/sql_parse…., 3134 &lex->value_list, 3135 lex->duplicates, 3136 lex->ignore))) 3137 { 3138 res= handle_select…}, lex = 0x33ae900, query_string = {string = { str = 0x7f3e84004ba0 “INSERT INTO testdb_N . t1_temp1_N…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
… FORCE INDEX on (bar) or an IGNORE INDEX(uid) and we got a …, can we learn from this? Unfortunately, setting sql_mode does not help you here….- I was able to duplicate this same issue with Percona Server 5.5.25a, but …i` (`i`,`update_date`) ) ENGINE=InnoDB and then inserted a few bogus rows with the…
