Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 22, 2015
EXPLAIN FORMAT=JSON: everything about attached_subqueries, optimized_away_subqueries, materialized_from_subquery
EXPLAIN FORMAT=JSON The regular [crayon-696e87f826310507859891-i/] command already provides some information about subquery optimization. For example, you can find out if the [...]
December 21, 2015
Better high availability: MySQL and Percona XtraDB Cluster with good application design
High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is [...]
December 18, 2015
Performance Schema: Measure Multi-Threaded Slave Activity
Performance Schema In many types of database workloads, using a multi-threaded slave from 5.6+ helps improve replication performance. I’ve had [...]
December 17, 2015
used_key_parts: EXPLAIN FORMAT=JSON provides insight into which part of multiple-column key is used
In the previous post for this ongoing “used_columns array can help to choose them wisely. There is one more type of multiple-column [...]
December 16, 2015
Using dbsake to recover table structure from .frm files and process mysqldump output
We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there [...]
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 [...]