… have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the…-time, –interval, –iterations) standard. If you hadn’t noticed, one tool would run forever by default, while the other would run… more changes in addition to those highlights. For example, three tools were removed, and there were several bug fixes. See https…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records(ibdata1… structure from InnoDB dictionary. Why do we need a new tool anyway? It is absolutely critical to have an accurate table…. Download the latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary parsers…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
… get your tables back with page_parser and constraints_parser tools. You can check the docs how to do it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start . The biggest challenge here is to… table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques#recovering_the_data_dictionary
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day,” but as promised, here are…’ll have to install ActivePerl first. Q: Are these MySQL tools able to be run against Amazon RDS instances? A: It depends. Most MySQL tools can connect to remote hosts and will work with Amazon…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… “free account” in this case is really just a marketing tool. Well, I admit there are companies that also use the “Open Source” mark as a marketing tool, too – we often can see this in products based on…
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
….2 prints too many string values Some tools don’t have –help or –version Some tools use @@hostname without /*!50038*/ pt-stalk…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… servers with thousands of connections. Enter pt-query-digest. The tool supports its share of format parsers, but the one that… ‘raw’ log parser. If you specify –format rawlog, then the tool expects the input to have one query per line, and…
Comment: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… used 2.1. 
If you fork something and develop a tool separately I can help you figure out the code (because….2. I have high hopes for this incarnation of the tool.
Comment: Is Synchronous Replication right for your app?
May 20, 2013 By 18 Comments
… be chunked into smaller transactions via pt-archiver and similar tools. I do believe that’s the “right” solution. second comment…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… for all of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL…
