Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 15, 2015
Act Quickly for Percona Live Super Saver rate – Plus an added incentive!
Our Super Saver discount rate for Percona Live 2016 is only available ‘til December 31st! This rate gets you all [...]
December 14, 2015
used_columns: EXPLAIN FORMAT=JSON tells when you should use covered indexes
In the “MySQL Query tuning 101” video, Alexander Rubin provides an excellent example of when to use a covered index. [...]
December 10, 2015
rows_examined_per_scan, rows_produced_per_join: EXPLAIN FORMAT=JSON answers on question “What number of filtered rows mean?”
At the end of my talk LinuxPiter conference, a user asked me a question: “What does the EXPLAIN ‘filtered’ field mean, [...]
December 8, 2015
attached_condition: How EXPLAIN FORMAT=JSON can spell-check your queries
When you work with complicated queries, especially ones which contain subqueries, it is easy to make a typo or misinterpret [...]
December 2, 2015
Fixing errant transactions with mysqlslavetrx prior to a GTID failover
Errant transactions are a major issue when using GTID replication. Although this isn’t something new, the drawbacks are more notorious [...]
November 2, 2015
A first look at RDS Aurora
Recently, I happened to have an onsite engagement and the goal of the engagement was to move a database service [...]
October 29, 2015
MySQL 5.7 first impressions on group-replication
During the last few weeks I’ve been testing and playing a bit with the new group-replication plugin available for MySQL [...]
October 20, 2015
Slow query graphs using Performance Schema and Graphite
I love graphs. They just make things easier when it comes to finding patterns. I also love visibility. Having the [...]
October 13, 2015
MySQL query digest with Performance Schema
Query analysis is a fantastic path in the pursuit to achieve high performance. It’s also probably the most repeated part [...]
October 9, 2015
When mysqld kills mysqld
The other day a colleague and friend of mine, Peter Boros, had a case where one of our clients had [...]
October 7, 2015
Apache Spark and MySQL for Data Analysis
What is Apache Spark? Apache Spark is a cluster computing framework, similar to Apache Hadoop. Wikipedia has a great description [...]
October 1, 2015
Capture database traffic using the Performance Schema
Capturing data is a critical part of performing a query analysis, or even just to have an idea of what’s going [...]
September 16, 2015
Webinar: Introduction to MySQL SYS Schema follow up questions
Thanks to all who attended my webinar Introduction to MySQL SYS Schema. This blog is for me to address the [...]
September 14, 2015
Webinar: Writing Application Code for MySQL High Availability Followup Questions
Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability. This blog is for [...]
September 10, 2015
Percona Server audit log plugin best practices
Auditing your database means tracking access and changes to your data and db objects. The Audit Log Plugin has been shipped [...]
August 18, 2015
Featured Talk: The Future of Replication is Today: New Features in Practice
In the past years, both MySQL 5.6, MySQL 5.7 and MariaDB 10 have been successful implementing new features. For many [...]
August 17, 2015
MySQL is crashing: a support engineer’s point of view
In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help [...]
August 13, 2015
MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13)
Welcome to the final – but most important – episode in the MySQL QA Series. In it, I present my vision [...]
August 11, 2015
MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash
My server is crashing… Now what? This special episode in the MySQL QA Series is for customers or users experiencing a crash. [...]
August 4, 2015
MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How
Today’s episode is all about Valgrind – from the pro’s to the con’s, from the why to the how! This episode [...]