… the 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… using Galera’s rolling schema upgrade feature. If that won’t work with your change (i.e., your change will prevent replication from working if you only do it on some nodes), then I’d suggest pt-online-schema-change…
Post: Percona Toolkit versions 2.0.5 and 2.1.2 released
June 12, 2012 By 1 Comment
… the latest versions of the tools. The complete list of changes is on Launchpad for 2.0.5 and 2.1… of the changes in version 2.1.2, which is the current development focus: We fixed several bugs in pt-table-sync… versions that don’t support it reliably. We enhanced pt-table-checksum and pt-online-schema-change to add even more safety checks, and to…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… upgrade, you still need to keep into account possible query changes, replication etc. Q: Is it possible to move MyISAM to… a lot faster. You can also use pt-online-schema-change tool for online migration. Q: Should we change ROW replication to MIXED during Upgrade? I… resolved in all cases – sometimes queries just need to be changed or supplemented with hints to get to old execution plans…
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 tested… 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 migration… hour just to finish this query: “SELECT table_schema, table_name FROM information_schema.key_column_usage WHERE …” After setting innodb_stats…
Comment: Give feedback on a pt-online-schema-change update
March 23, 2012 By 4 Comments
Hi Very interesting and important changes, I have faced some of the problems with the pt-online-schema-change which are: – Primary Key with multiple… any plan to fix this, are there plans for future change ? – Column names in quotes – as we have reserved words as… worked around by allowing the sleep time to be dynamically changed via a file. will this also handle the part of…
Post: MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server
February 28, 2013 By 5 Comments
… server[/caption] Like Ovais said in Implications of Metadata Locking Changes in MySQL 5.5, the hot topic these days is… locking change in MySQL 5.5. As I began to dig into the Percona Toolkit bug he reported concerning this change apropos pt-online-schema-change…
Comment: pt-online-schema-change and default values
June 21, 2012 By 1 Comment
… for column v, it changes its mind and decides to be strict. This is what’s causing pt-online-schema-change to have a problem.
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… were not allowed to make any query or application logic changes so we chose to implement the Barracuda file format and… customer 
One parting idea: you may be able to leverage pt-online-schema-change from Percona Toolkit 2.1 in order to modify the…
