Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 15, 2016
Making Apache Spark Four Times Faster
This is a followup to my previous post Apache Spark with Air ontime performance data. To recap an interesting point [...]
January 9, 2016
ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing
We’ve already discussed using the ORDER BY clause with subqueries. You can also, however, use the [crayon-68dd37df24ecb231540168-i/] clause with sorting results of one of [...]
January 7, 2016
Apache Spark with Air ontime performance data
There is a growing interest in Apache Spark, so I wanted to play with it (especially after Alexander Rubin’s Using Apache Spark post). To start, [...]
January 4, 2016
grouping_operation, duplicates_removal: EXPLAIN FORMAT=JSON has all details about GROUP BY
In the previous blog post, we discussed the [crayon-68dd37df263ee686749170-i/] member (which is child of [crayon-68dd37df263f3716406421-i/]). Let’s now focus on the [crayon-68dd37df263f5403824104-i/] and [...]
December 29, 2015
2016 Percona Live Tutorials Schedule is UP!
We are excited to announce that the tutorial schedule for the Percona Live Data Performance Conference 2016 is up! The schedule [...]
December 29, 2015
EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY
Another post in the EXPLAIN FORMAT=JSON is Cool! series! In this post, we’ll discuss how the EXPLAIN FORMAT=JSON provides optimization details for [crayon-68dd37df26dbc719372244-i/] and [crayon-68dd37df26dc1615252911-i/] operations in [...]
December 28, 2015
EXPLAIN FORMAT=JSON provides insights on optimizer_switch effectiveness
The EXPLAIN FORMAT=JSON is Cool! series showed an example of the query [crayon-68dd37df27719678178878-i/], where the subquery was materialized into a temporary table [...]
December 22, 2015
EXPLAIN FORMAT=JSON: everything about attached_subqueries, optimized_away_subqueries, materialized_from_subquery
EXPLAIN FORMAT=JSON The regular [crayon-68dd37df27eb3623506486-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 [...]