… release: pt-online-schema-change can now handle column renames pt-online-schema-change’s DELETE trigger no longer fails when altering a primary key pt-stalk got a plugin hook interface pt-show…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… — and using this the node should be fully functional and online during the entire backup. Q: Can I run two Percona… and removing indexes, can be done using Galera’s rolling schema upgrade feature. If that won’t work with your change… only do it on some nodes), then I’d suggest pt-online-schema-change. Q: Does replication of MyISAM form any bottlenecks in…
Post: Percona Toolkit versions 2.0.5 and 2.1.2 released
June 12, 2012 By 1 Comment
… is the current development focus: We fixed several bugs in pt-table-sync that prevented it from working properly, and disabled… versions that don’t support it reliably. We enhanced pt-table-checksum and pt-online-schema-change to add even more safety checks, and…
Comment: Percona Toolkit 1.0.1 released
September 8, 2011 By 13 Comments
…, but we want to make pt-query-digest simpler, and yanking out that code will help. pt-online-schema-change hasn’t been extensively… bugs in features that we’ll remove entirely in the PT tools, for example. But that is life. We can’t…
Comment: Solving INFORMATION_SCHEMA slowness
April 20, 2012 By 25 Comments
…’ve just hit the INFORMATION_SCHEMA slowness today when I began the tests to integrate the pt-online-schema-change tool into our own… hour just to finish this query: “SELECT table_schema, table_name FROM information_schema.key_column_usage WHERE …” After setting innodb_stats… rest of the percona tools that use the MySQL INFORMATION_SCHEMA ) allowing it to momentarily set innodb_stats_on_metadata=0…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… creating tables a lot faster. You can also use pt-online-schema-change tool for online migration. Q: Should we change ROW replication to…
Post: MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server
February 28, 2013 By 5 Comments
… the Percona Toolkit bug he reported concerning this change apropos pt-online-schema-change, I discovered something about lock_wait_timeout that shocked…
Comment: pt-online-schema-change and default values
June 21, 2012 By 1 Comment
… and decides to be strict. This is what’s causing pt-online-schema-change to have a problem.
Comment: Give feedback on a pt-online-schema-change update
May 31, 2012 By 4 Comments
… PerconaTools is already my must-have ! Now my question about pt-online-schema-change, could it be possible to drop all indexes before…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… customer 
One parting idea: you may be able to leverage pt-online-schema-change from Percona Toolkit 2.1 in order to modify…
