EmergencyEMERGENCY? Get 24/7 Help Now!

Webinars: Common (but deadly) MySQL mistakes

 | January 13, 2014 |  Posted In: Insight for DBAs, Insight for Developers, MySQL Webinars

On January 22 I’ll be presenting the first of a series of two new webinars focusing on avoiding common MySQL mistakes: How to Avoid Common (but Deadly) MySQL Operations Mistakes. “Don’t bother me with DBA ‘best practices,’ we have real work to get done.” So go the famous last words from overworked IT managers (we’ve […]

Read More

How Percona tested Percona Server 5.6: A world premiere in advanced testing

 | November 11, 2013 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, MySQL, Percona Server

8PM. One of the servers found a critical bug. Hop online and discuss, log bug. 10PM. Patch ready. 10:30PM. New build ready. 10:45PM. New RQG run initiated. This was by no means an uncommon sight during the months of testing that went into Percona Server 5.6, in fact it was commonplace. At a certain point, […]

Read More

QA: Advanced Option Combinatorics (Pairwise Testing): Combinatorial mysqld Option Test Case Generation

 | November 11, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

How do we ensure that, when we have 35+ testable option combinations for mysqld, we test each and every combination of them? For example: will a different innodb_log_file_size combined with more innodb_log_files_in_group and a modified innodb_fast_shutdown setting truly not affect Percona’s log archiving feature? Most option-related bugs are caused by the setting of 1 or […]

Read More

How to Extract All Running Queries (Including the Last Executed Statement) from a Core File?

 | November 11, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

This post builds on the How to obtain the “LES” (Last Executed Statement) from an Optimized Core Dump? post written about a year ago. A day after that post was released, Shane Bester wrote an improved version, How to obtain all executing queries from a core file on his blog. Reading that post is key […]

Read More

Join my Oct. 2 webinar: ‘Implementing MySQL and Hadoop for Big Data’

 | October 1, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars

MySQL DBAs know that integrating MySQL and a big data solution can be challenging. That’s why I invite you to join me this Wednesday (Oct. 2) at 10 a.m. Pacific time for a free webinar in which I’ll walk you through how to implement a successful big data strategy with Apache Hadoop and MySQL. This […]

Read More

Percona Live London 2013: an insider’s view of the schedule

 | September 18, 2013 |  Posted In: Benchmarks, Events and Announcements, Hadoop, Hardware and Storage, Hive, Insight for DBAs, Insight for Developers, MySQL, Percona Live, Percona XtraBackup

With the close of call for papers earlier this month, the Percona Live London conference committee was in full swing this past week reviewing all of the many submissions for November’s Percona Live London MySQL Conference. The submissions are far ranging and cover some really interesting topics, making the lineup for Percona Live London really strong! […]

Read More

How InnoDB promotes UNIQUE constraints

 | September 10, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB table with an odd structure (no PRIMARY key, but multiple UNIQUE constraints). This got me thinking about how InnoDB promotes UNIQUE constraints to the role of PRIMARY KEYs. The documentation is pretty clear: [DOCS] When […]

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.