EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Toolkit 2.2.13 is now available

 | January 26, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona is pleased to announce the availability of Percona Toolkit 2.2.13.  Released January 26, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source. This release is […]

Read More

How a set of queries can be killed in MySQL using Percona Toolkit’s pt-kill

 | November 19, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona Toolkit

You might have encountered situations where you had to kill some specific select queries that were running for long periods and choking the database. This post will go into more detail with an example of report query offloading. Report query (select) offloading to a slave server is a common practice to reduce the workload of the […]

Read More

Avoiding MySQL ALTER table downtime

 | November 18, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Managed Services, Percona Remote DBA

MySQL table alterations can interrupt production traffic causing bad customer experience or in worst cases, loss of revenue. Not all DBAs, developers, syadmins know MySQL well enough to avoid this pitfall. DBAs usually encounter these kinds of production interruptions when working with upgrade scripts that touch both application and database or if an inexperienced admin/dev […]

Read More

Optimizing MySQL for Zabbix

 | November 14, 2014 |  Posted In: High-availability, InnoDB, MySQL

This blog post was inspired by my visit at the annual Zabbix Conference in Riga, Latvia this year, where I gave a couple of talks on MySQL and beyond. It was a two day single-track event with some 200 participants, a number of interesting talks on Zabbix (and related technologies) and really well-organized evening activities. […]

Read More

Data inconsistencies on MySQL replicas: Beyond pt-table-checksum

 | November 4, 2014 |  Posted In: MySQL, Percona Toolkit

Percona Toolkit’s pt-table-checksum is a great tool to find data inconsistencies between a MySQL master and its replicas. However it is sometimes not enough to know that there are inconsistencies and let pt-table-sync fix the issue: you may want to know which exact rows are different to identify the statements that created the inconsistency. This […]

Read More

Percona Toolkit for MySQL with MySQL-SSL Connections

 | October 16, 2014 |  Posted In: MySQL, Percona Toolkit

I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections aren’t widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be accessing MySQL over public internet or even over a public “private” […]

Read More

How to avoid hash collisions when using MySQL’s CRC32 function

 | October 13, 2014 |  Posted In: MySQL, Percona Toolkit

Percona Toolkit’s  pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently between MySQL tables. The tools by default use the CRC32. Other good choices include MD5 and SHA1. If you have installed the FNV_64 user-defined function, pt-table-sync will […]

Read More

MySQL Replication: ‘Got fatal error 1236’ causes and cures

 | October 8, 2014 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Support

MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need to act promptly regarding replication errors to continue […]

Read More

Percona Toolkit 2.2.11 for MySQL is now available

 | September 30, 2014 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona is pleased to announce the availability of Percona Toolkit 2.2.11.  Released on Sept. 25, Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source. This release contains […]

Read More

Syncing MySQL slave table with pt-online-schema-change

 | September 17, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

I recently encountered a situation in which after running Percona Toolkit’s pt-table-checksum on a customer system, 95% of the table on the MySQL master was different on the MySQL slave. Although this table was not a critical part of the infrastructure, from time to time, writes to the table from the master would break replication. […]

Read More

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.