EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live London: Top Ten reasons to attend Nov. 3-4

 | September 16, 2014 |  Posted In: MySQL, Percona Live

Percona Live London 2014 is fast approaching – November is just around the corner. This year’s conference, November 3-4, will be even bigger and better than last year thanks to the participation of leading MySQL experts the world over (including you!). The Percona Live London MySQL Conference is a great event for users of any […]

Read More

Prevent MySQL downtime: Set max_user_connections

 | July 29, 2014 |  Posted In: Insight for DBAs, MySQL

One of the common causes of downtime with MySQL is running out of connections. Have you ever seen this error? “ERROR 1040 (00000): Too many connections.” If you’re working with MySQL long enough you surely have. This is quite a nasty error as it might cause complete downtime… transient errors with successful transactions mixed with […]

Read More

Why TokuDB hates Transparent HugePages

 | July 23, 2014 |  Posted In: MySQL, TokuDB

If you try to install the TokuDB storage engine on a modern Linux distribution it might fail with following error message: 2014-07-17 19:02:55 13865 [ERROR] TokuDB will not run with transparent huge pages enabled. 2014-07-17 19:02:55 13865 [ERROR] Please disable them to continue. 2014-07-17 19:02:55 13865 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled) You might be curious […]

Read More

MySQL Backup Service from Percona

 | June 17, 2014 |  Posted In: MySQL, Percona Backup Service, Percona Managed Services, Percona XtraBackup, Percona XtraDB Cluster

The Percona Backup Service managed service launched today. It ensures properly configured backups run successfully as scheduled on customer provided backup storage – whether on premise, in the cloud, or a hybrid. Backup issues or production data recovery are efficiently handled by Percona Managed Services technicians with deep knowledge of MySQL. As we state in […]

Read More

Architecture and Design of MySQL-powered applications: June 11 Webinar

 | June 9, 2014 |  Posted In: Insight for Developers, MySQL, Technical Webinars

The architecture of MySQL-powered applications is one of my favorite topics to talk about. It’s a very important topic because if you do not get the architecture right then you’re very likely to fail with your project – either from the standpoint of failing with performance, high availability or security requirements… or failing to deliver […]

Read More

Do not trust vmstat IOwait numbers

 | June 3, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, Percona Cloud Tools, Percona Server

I’ve been running a benchmark today on my old test box with conventional hard drives (no raid with BBU) and noticed something unusual in the CPU utilization statistics being reported. The benchmark was run like this:

Which means: create 64 threads and hammer the database with queries as quickly as possible. As the test […]

Read More

How MySQL ‘queries’ and ‘questions’ are measured

 | May 29, 2014 |  Posted In: Insight for DBAs, MySQL

MySQL has status variables “questions” and “queries” which are rather close but also a bit different, making it confusing for many people. The manual describing it might not be very easy to understand:

In a nutshell if you’re not using prepared statements the big difference between those is what “Questions” would count stored procedure calls as […]

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.