… replication 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 …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
…tables and has been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in …remote server was closed leading to an unappropriated network error and stopping the Slave SQL thread….As the option ignore-builtin-innodb is incompatible with Percona Server with XtraDB, the server will not start…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate_wild_do_tableblogpercona.commanual replicate_wild_ignore…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
…`) Not copying rows because this is a dry run. INSERT LOW_PRIORITY IGNORE INTO `test`.`_t_new` (`id`, `guest_language`, `guest_country… use the following SQL statements to copy rows: Not copying rows because this is a dry run. INSERT LOW_PRIORITY IGNORE INTO `test… are any bugs in the tool, problems with the MySQL server (privileges, etc.), or other oddities, there is a good likelihood…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…fragmented indexes because records are inserted in the correct order into…is loaded.” mysqldump in Percona Server supports the new option –…keys > 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.cc:…->value_list, 3135 lex->duplicates, 3136 lex->ignore))) 3137 { 3138 res= handle_select(thd, … 0}, lex = 0x33ae900, query_string = {string = { str = 0x7f3e84004ba0 “INSERT INTO testdb_N . t1_temp1_N SELECT…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… | Position | Binlog_Do_DB | Binlog_Ignore_DB | +——————+———-+————–+——————+ | mysql-bin.000007 | 474 … Event_type: Query Server_id: 1 End_log_pos: 90 Info: insert into test….000006 Slave_IO_Running: No Slave_SQL_Running: No …… omitted ……… slave1 > start …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…query parallelization, so ETL jobs written to rely on SQL tend to get really bogged down. In contrast… your script can figure out which files it can ignore. What we’re doing here starts to …way to bypass the hard-to-scale database server for the initial insertion, because you can write CSV files …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… form the timestamp included in the last executed sql statement. As some of them are looping, the… statement were first inserted. Another way to see it is by monitoring your MySQL server with cacti, you… the current server_id didn’t fetch up. There is also the possibility to use IGNORE_SERVER_IDS from…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
… MySQL puzzle. He was running Percona Server 5.5.21 with a table … FORCE INDEX on (bar) or an IGNORE INDEX(uid) and we got a …then, can we learn from this? Unfortunately, setting sql_mode does not help you here….i` (`i`,`update_date`) ) ENGINE=InnoDB and then inserted a few bogus rows with the …
