EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver

 | May 6, 2013 |  Posted In: Percona Software, Percona Toolkit


During the Percona Live MySQL Conference & Expo 2013 the week before last, we quietly released Percona Toolkit 2.2.2 with a few bug fixes:

  • pt-archiver –bulk-insert may corrupt data
  • pt-heartbeat –utc –check always returns 0
  • pt-query-digest 2.2 prints unwanted debug info on tcpdump parsing errors
  • pt-query-digest 2.2 prints too many string values
  • Some tools don’t have –help or –version
  • Some tools use @@hostname without /*!50038*/
  • pt-stalk prints the wrong variable name in verbose mode when –function is used
  • And more

Percona ToolkitThe first two bugs are important. Those using pt-archiver –bulk-insert with UTF-8 data should definitely upgrade. Those using pt-heartbeat –utc should also definitely upgrade.

Users may note the revival of the –show-all option in pt-query-digest. This had been removed in 2.2.1, but resulted in too much output in certain cases.

A new –recursion-method was added to pt-table-checksum: cluster. This method attempts to auto-discover cluster nodes, alleviating the need to specify cluster node DSNs in a DSN table (–recursion-method=dsn).

See https://launchpad.net/percona-toolkit/+milestone/2.2.2 for the full list of bugs fixed in Percona Toolkit 2.2.2.

Visit https://www.percona.com/software/percona-toolkit to download Percona Toolkit 2.2.2; it’s also in our main repos.



  • hello,
    currently using 2.2.2 and
    mysql Ver 14.14 Distrib 5.5.30, for Linux (x86_64) using readline 5.1
    i am getting this since the upgrade of percona this week:

    pt-heartbeat -F/etc/my.cnf -Dpt_heartbeat –check

    The –master-server-id option must be specified because the heartbeat table pt_heartbeat.heartbeat uses the server_id column for –update or –check but the server’s master could not be automatically determined.
    Please read the DESCRIPTION section of the pt-heartbeat POD.

    any ideas why this could be happening?
    how does the master’s auto detection takes place?


    don’t know what went wrong since i upgraded

Leave a Reply


Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.