Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 28, 2014
How to avoid common (but deadly) MySQL development mistakes
MySQL software developers are under pressure to do more in less time and create applications that adapt to ever-changing requirements. [...]
February 11, 2014
WITHer Recursive Queries?
Over the past few years, we’ve seen MySQL technology advance in leaps and bounds, especially when it comes to scalability. [...]
January 14, 2014
InnoDB file formats: Here is one pitfall to avoid
UPDATED: explaining the role of innodb_strict_mode and correcting introduction of innodb_file_format Compressed tables is an example of an InnoDB feature [...]
January 13, 2014
Webinars: Common (but deadly) MySQL mistakes
On January 22 I’ll be presenting the first of a series of two new webinars focusing on avoiding common MySQL [...]
December 26, 2013
2 cases for MySQL server overload
Your MySQL server is overloaded. You see hundreds of running queries in the SHOW PROCESSLIST taking many seconds to run, [...]
November 11, 2013
How Percona tested Percona Server 5.6: A world premiere in advanced testing
8PM. One of the servers found a critical bug. Hop online and discuss, log bug. 10PM. Patch ready. 10:30PM. New [...]
November 11, 2013
QA: Advanced Option Combinatorics (Pairwise Testing): Combinatorial mysqld Option Test Case Generation
How do we ensure that, when we have 35+ testable option combinations for mysqld, we test each and every combination [...]
November 11, 2013
How to Extract All Running Queries (Including the Last Executed Statement) from a Core File?
This post builds on the How to obtain the “LES” (Last Executed Statement) from an Optimized Core Dump? post written [...]
October 10, 2013
SSL Performance Overhead in MySQL
NOTE: This is part 1 of what will be a two-part series on the performance implications of using in-flight data [...]
October 6, 2013
How can we bring query to the data?
Baron recently wrote about sending the query to the data looking at distributed systems like Cassandra. I want to take [...]
October 1, 2013
Join my Oct. 2 webinar: ‘Implementing MySQL and Hadoop for Big Data’
MySQL DBAs know that integrating MySQL and a big data solution can be challenging. That’s why I invite you to [...]
September 18, 2013
Percona Live London 2013: an insider’s view of the schedule
With the close of call for papers earlier this month, the Percona Live London conference committee was in full swing this [...]
September 10, 2013
How InnoDB promotes UNIQUE constraints
The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB [...]
August 26, 2013
MySQL Security Webinar: Follow-up Q&A
Thanks to everyone who attended last week’s webinar on MySQL security; hopefully you’ve all gone out and set SELinux to [...]
August 15, 2013
Percona University at Washington, D.C. – Sept. 12
Following our events earlier this year in Raleigh, Montevideo, Buenos Aires, Toronto and Portland, we bring Percona University to Washington, [...]
August 1, 2013
Schema Design in MongoDB vs Schema Design in MySQL
For people used to relational databases and doing MySQL database design, using NoSQL solutions such as MongoDB brings interesting challenges. [...]
July 31, 2013
InnoDB Full-text Search in MySQL 5.6: Part 3, Performance
This is part 3 of a 3 part series covering the new InnoDB full-text search features in MySQL 5.6. To [...]
July 26, 2013
Checking B+tree leaf nodes list consistency in InnoDB
If we have InnoDB pages there are two ways to learn how many records they contain: PAGE_N_RECS field in the [...]
July 19, 2013
What kind of queries are bad for MySQL?
In writing a recommendation for our Web development team on how to use MySQL, I came up with the following [...]
June 22, 2013
Setting up MySQL SSL and Secure Connections
There are different articles on how to setup MySQL with SSL but it’s sometimes difficult to end up with a [...]