EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server

 | February 28, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

Like Ovais said in Implications of Metadata Locking Changes in MySQL 5.5, the hot topic these days is MySQL 5.6, but there was an important metadata 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, I discovered something about lock_wait_timeout that shocked me.  From the […]

Read More

MySQL net_write_timeout vs wait_timeout and protocol notes

 | July 8, 2007 |  Posted In: Insight for DBAs

In my previous post I mentioned you might need to increase net_write_timeout to avoid connection being aborted and now I think I should have better explained that. MySQL uses a lot of different timeout variables at different stages. For example when connection is just being established connect_timeout is used. When server waits for another query […]

Read More

MySQL “Got an error reading communication packet” errors

 | May 16, 2016 |  Posted In: MySQL

Galera Error Failed to Report Last Committed

In this blog post, we’ll discuss the possible reasons for MySQL “Got an error reading communication packet” errors, and how to address them. In Percona’s managed services, we often receive customer questions on communication failure errors – where customers are faced with intermittent “Got an error reading communication packets” messages. I thought this topic deserved […]

Read More

Percona XtraBackup 2.3.2 GA is now available

 | October 22, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.3.2 GA on October 22nd, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. […]

Read More

Percona XtraBackup 2.2.9 is now available

 | February 17, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.2.9 on February 17, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

Read More

Schema changes in MySQL for OpenStack Trove users

 | November 24, 2014 |  Posted In: MySQL, OpenStack

People using OpenStack Trove instances can hit a common issue in the MySQL world: how to perform schema change operations while minimizing the impact on the database server? Let’s explore the options that can allow online schema changes. Summary With MySQL 5.5, pt-online-schema-change from Percona Toolkit is your best option for large tables while regular […]

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

ScaleArc: Benchmarking with sysbench

 | March 31, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, Percona Live, Percona MySQL Consulting

ScaleArc recently hired Percona to perform various tests on its database traffic management product. This post is the outcome of the benchmarks carried out by Uday Sawant (ScaleArc) and myself. You can also download the report directly as a PDF here. The goal of these benchmarks is to identify the potential overhead of the ScaleArc […]

Read More

Introducing backup locks in Percona Server

 | March 11, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona Software, Percona XtraBackup

TL;DR version: The backup locks feature introduced in Percona Server 5.6.16-64.0 is a lightweight alternative to FLUSH TABLES WITH READ LOCK and can be used to take both physical and logical backups with less downtime on busy servers. To employ the feature with mysqldump, use mysqldump –lock-for-backup –single-transaction. The next release of Percona XtraBackup will […]

Read More

Before every release: A glimpse into Percona XtraDB Cluster CI testing

 | February 21, 2014 |  Posted In: MySQL, Percona Software, Percona XtraDB Cluster

I spoke last month at linux.conf.au 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the Developer,Testing, Release and CI miniconf. Here is the video of the presentation: Here is the presentation itself: Percona XtraDB Cluster before every release: Glimpse into CI […]

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.