… from the slave or use mk-table-checksum to find inconsistencies and re-sync them with mk-table-sync. Both of these operations can…
Comment: Resyncing table on MySQL Slave
July 1, 2008 By 11 Comments
… you have traffic flowing as you need to ensure the table is “synced” at same point in time in master and slave… be hard to guaranty for complex replication topologies. The mk-table-sync is nice tool as I mentioned though it is not…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… 450 tables/sec – This indicates the “fsync” is lying on this test system as default sync_frm option is used. With default table_cache=64 accessing all tables take 12 sec which is almost 8500 tables/sec…-only benchmark. Why ? Because for MyISAM tables table header has to be modified each time the table is opened. In this case the…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
…. Let’s take a table with data as example, column c1 on table t2 references column c1 on table t1 – both columns have identical set of rows for simplicity. CREATE TABLE `t1` ( `t1_c1` int(10) unsigned NOT NULL AUTO_INCREMENT….00 sec) Uh oh, now the slave is out of sync, because the statement failed to delete all intended rows it…
Post: Released: Percona Toolkit 2.1.5
October 12, 2012 By Leave a Comment
… a couple of bugs concerning how pt-table-checksum works with Percona XtraDB Cluster: pt-table-checksum 2.1.4 doesn’t…-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based slaves as cluster nodes There was also a bug affecting pt-table-sync… is a small release, but if you’re using pt-table-checksum on your Percona XtraDB Cluster then you’ll definitely…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… replication filters rollback of transactions mixing transactional and non-transactional tables The real problem is that replication may keep on running… the problem right now (either manually or with pt-table-checksum/pt-table-sync) than several days or several weeks later, as a…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…/unique key duplication then you can run the pt-table-checksum and pt-table-sync. How to restore a slave in a good…
Post: Percona Toolkit versions 2.0.5 and 2.1.2 released
June 12, 2012 By 1 Comment
… the current development focus: We fixed several bugs in pt-table-sync that prevented it from working properly, and disabled the –lock… versions that don’t support it reliably. We enhanced pt-table-checksum and pt-online-schema-change to add even more…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… sync_frmblogpercona.commanual sync_master_infoblogpercona.commanual sync_relay_logblogpercona.commanual sync_relay_log_infoblogpercona.commanual sysdate_is_nowblogpercona.commanual system_time_zoneblogpercona.commanual table_definition_cacheblogpercona.commanual table_lock…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… point in time recovery it can go unnoticed. sync_binlog Is helping by syncing binary log, but at performance penalty. If using… Innodb does not store index cardinality in tables, instead it computes them on first table access after startup. This may take significant… might run select 1 from _table_ limit 1 for each table or any other statement – it is table open which is important. There…
