EmergencyEMERGENCY? Get 24/7 Help Now!

Introducing the “Version Check” Feature in Percona Toolkit

 | September 10, 2012 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Software


Recently there has been a storm of bugs and problems in all variants of MySQL including MySQL, Percona Server, and MariaDB. To list a few:

No single person is able to remember all the bugs and versions they impact. This challenge gave us an idea. Namely, we can help MySQL users by providing guidance on whether the version they are running is impacted by a specific issue.

To address this challenge, we implemented a “Version Check” feature in Percona Toolkit which will be available in the next release, version 2.1.4. To activate Version Check, you will call the tool that supports this feature with an option --version-check and the tool will connect to the Percona Version Check database. To maintain the safety of your information, the Version Check feature will use https (secure channel) to connect with Percona’s Version Check database server. Based on the Version Check database call, advice will be returned to you to provide you with visibility into any potential risks associated with any of the relevant software versions. We will store each request in web server logs and retain version number information in order to guide the development of future Version Check database version requirements.

The Version Check feature will support Percona Server, Percona XtraDB Cluster, MySQL, and MariaDB. It will also check the Percona Toolkit, Perl, and Perl::DBD module (some versions of this module have compatibility issues) versions.

Version Check must send information on your MySQL version and other covered software versions to compare to the Percona Version Check database. Because this is potentially sensitive information, the Version Check feature is an option in Percona Toolkit version 2.1.4 which is turned off by default. We believe the feature will provide a real benefit so we encourage Percona Toolkit users to try it. However, the option to try it is totally up to you and you can continue to use Percona Toolkit as before, without enabling Version Check.

Vadim Tkachenko

Vadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. Vadim leads Percona Labs, which focuses on technology research and performance evaluations of Percona’s and third-party products. Percona Labs designs no-gimmick tests of hardware, filesystems, storage engines, and databases that surpass the standard performance and functionality scenario benchmarks.

Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. Oracle Corporation and its predecessors have incorporated Vadim’s source code patches into the mainstream MySQL and InnoDB products.

He also co-authored the book High Performance MySQL: Optimization, Backups, and Replication 3rd Edition.


  • I notice that the default has changed. The latest versions of the tool have this feature enabled by default. The documentation posted online does not mention this, though. It looks like the –version-check option has changed from a string with several possible options, to a boolean that defaults to TRUE.

Leave a Reply