You are here

MySQL Performance Blog

MySQL Performance Blog
Checked: 3 years 4 months ago
Updated: 3 years 4 months ago
Update every: 2 hours

Percona's Data performance and scalability blog
Subscribe to MySQL Performance Blog

Prometheus as an Engine for MySQL Monitoring

MySQL Performance Blog - Thu, 14/01/2016 - 3:23pm
When I first discovered Graphite years ago, I was very impressed with its monitoring capabilities.  Compared to many RRD-based tools that were popular at the time (like Cacti), Graphite separated the captured data and graphs, ...

Play the Percona Powerball Pool!!

MySQL Performance Blog - Tue, 12/01/2016 - 6:25pm
percona powerballThe Only Sure Thing is Percona Powerball Pool Everyone is talking about the upco

Percona Server 5.6.28-76.1 is now available

MySQL Performance Blog - Tue, 12/01/2016 - 2:30pm
Percona is glad to announce the release of Percona Server 5.6.28-76.1 on January 12, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.28, including all the bug ...

Percona Server 5.5.47-37.7 is now available

MySQL Performance Blog - Tue, 12/01/2016 - 2:10pm
Percona is glad to announce the release of Percona Server 5.5.47-37.7 on January 12, 2016. Based on MySQL 5.5.47, including all the bug fixes in it, Percona Server 5.5.47-37.7 is now the current stable release ...

Percona Monitoring Plugins 1.1.6 release

MySQL Performance Blog - Tue, 12/01/2016 - 6:01am
Percona is glad to announce the release of Percona Monitoring Plugins 1.1.6. Changelog: Added new RDS instance classes to RDS scripts. Added boto profile support to RDS scripts. Added AWS region support and ability to ...

Bare-metal servers for button-push database-as-a-service

MySQL Performance Blog - Mon, 11/01/2016 - 5:50pm
Enterprises’ demand flexibility, scalability and efficiency to keep up with the

MongoDB revs you up: What storage engine is right for you? (Part 2)

MySQL Performance Blog - Mon, 11/01/2016 - 5:48pm

Percona XtraDB Cluster 5.6.27-25.13 is now available

MySQL Performance Blog - Mon, 11/01/2016 - 12:16pm
Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on January 11, 2016. Binaries are available from the downloads area or from our software repositories. Percona XtraDB Cluster 5.6.27-25.13 is now the ...

ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing

MySQL Performance Blog - Sat, 09/01/2016 - 6:25am
EXPLAIN FORMAT=JSONWe’ve already discussed using the ORDER BY clause with subqueries. You can also, however, use the [crayon-5690aff4d4839416071471-i/] clause with sorting results of one of the columns. Actually, this is most common way to use this clause. Sometimes such queries ...

Apache Spark with Air ontime performance data

MySQL Performance Blog - Fri, 08/01/2016 - 1:28am
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, I used the recently released Apache Spark 1.6.0 for this experiment, and I will play with “Airlines ...

MongoDB revs you up: What storage engine is right for you? (Part 1)

MySQL Performance Blog - Wed, 06/01/2016 - 6:31pm

Differentiating Between MongoDB Storage Engines The tremendous data growth of the last decade has affected almost all aspects of applications and application use. Since nearly all applications interact with a database at some point, this means ...

The post MongoDB revs you up: What storage engine is right for you? (Part 1) appeared first on MySQL Performance Blog.

grouping_operation, duplicates_removal: EXPLAIN FORMAT=JSON has all details about GROUP BY

MySQL Performance Blog - Tue, 05/01/2016 - 1:45am

In the previous EXPLAIN FORMAT=JSON is Cool! series blog post, we discussed the  [crayon-568b3fc49b43b984658518-i/]  member (which is child of [crayon-568b3fc49b44d051216498-i/]). Let’s now focus on the [crayon-568b3fc49b456131010417-i/]  and other details of [crayon-568b3fc49b45d091965110-i/]  processing. [crayon-568b3fc49b464060166912-i/] simply shows the details of what happens ...

Percona Server for MongoDB 3.0.8-1.2 is now available

MySQL Performance Blog - Mon, 04/01/2016 - 7:37pm

Percona is pleased to announce the release of Percona Server for MongoDB 3.0.8-1.2 on January 4, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open ...

The post Percona Server for MongoDB 3.0.8-1.2 is now available appeared first on MySQL Performance Blog.

Database Performance Webinar: Tired of MySQL Making You Wait?

MySQL Performance Blog - Wed, 30/12/2015 - 8:05pm

Too often developers and DBAs struggle to pinpoint the root cause of MySQL database performance issues, and then spend too much time in trying to fix them. Wouldn’t it be great to bypass wasted guesswork ...

The post Database Performance Webinar: Tired of MySQL Making You Wait? appeared first on MySQL Performance Blog.

2016 Percona Live Tutorials Schedule is UP!

MySQL Performance Blog - Tue, 29/12/2015 - 9:24pm

We are excited to announce that the tutorial schedule for the Percona Live Data Performance Conference 2016 is up! The schedule shows all the details for each of our informative and enlightening Percona Live tutorial sessions, ...

The post 2016 Percona Live Tutorials Schedule is UP! appeared first on MySQL Performance Blog.

EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY

MySQL Performance Blog - Tue, 29/12/2015 - 8:39pm

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-5683026550870772518911-i/] and  [crayon-5683026550882438771706-i/] operations in conjunction with [crayon-568302655088e480902004-i/] and  [crayon-568302655089c478222391-i/].  [crayon-56830265508ab633748052-i/] can print details on how a subquery in [crayon-56830265508b8374547610-i/] is optimized: [crayon-56830265508c0989181837/] The ...

EXPLAIN FORMAT=JSON provides insights on optimizer_switch effectiveness

MySQL Performance Blog - Mon, 28/12/2015 - 7:20pm

The previous post in the EXPLAIN FORMAT=JSON is Cool! series showed an example of the query [crayon-5681b0e640014827276115-i/], where the subquery was materialized into a temporary table and then joined with the outer query. This is known as a semi-join optimization. ...

Percona Server for MongoDB storage engines in iiBench insert workload

MySQL Performance Blog - Wed, 23/12/2015 - 5:39pm

We recently released the GA version of Percona Server for MongoDB, which comes with a variety of storage engines: RocksDB, PerconaFT and WiredTiger. Both RocksDB and PerconaFT are write-optimized engines, so I wanted to compare ...

The post Percona Server for MongoDB storage engines in iiBench insert workload appeared first on MySQL Performance Blog.

EXPLAIN FORMAT=JSON: everything about attached_subqueries, optimized_away_subqueries, materialized_from_subquery

MySQL Performance Blog - Tue, 22/12/2015 - 10:41pm

EXPLAIN FORMAT=JSON The regular [crayon-5679f2185b3f7786726815-i/] command already provides some information about subquery optimization. For example, you can find out if the subquery is dependent or not, and (since version 5.6) if it was materialized: [crayon-5679f2185b407730830883/] However, ...

Better high availability: MySQL and Percona XtraDB Cluster with good application design

MySQL Performance Blog - Mon, 21/12/2015 - 9:19pm

High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question? MySQL seems to be the most popular database solution for web-based products. Most ...

The post Better high availability: MySQL and Percona XtraDB Cluster with good application design appeared first on MySQL Performance Blog.

Performance Schema: Measure Multi-Threaded Slave Activity

MySQL Performance Blog - Fri, 18/12/2015 - 11:30pm

Performance Schema In many types of database workloads, using a multi-threaded slave from 5.6+ helps improve replication performance. I’ve had a number of users enable this feature, but have not seen anyone ask how each ...

The post Performance Schema: Measure Multi-Threaded Slave Activity appeared first on MySQL Performance Blog.

Sneak peek at the Percona Live Data Performance Conference and Expo 2016

MySQL Performance Blog - Fri, 18/12/2015 - 12:43am

On behalf of the Percona Live Conference Committee, I am excited to announce the sneak peek schedule for the Percona Live Data Performance Conference and Expo 2016! Percona Live Data Performance Conference and Expo Live 2016 will ...

The post Sneak peek at the Percona Live Data Performance Conference and Expo 2016 appeared first on MySQL Performance Blog.

used_key_parts: EXPLAIN FORMAT=JSON provides insight into which part of multiple-column key is used

MySQL Performance Blog - Fri, 18/12/2015 - 12:20am

In the previous post for this ongoing “EXPLAIN FORMAT=JSON is Cool!” series, we discussed covered indexes and how the [crayon-56735a98f016f887500716-i/]  array can help to choose them wisely. There is one more type of multiple-column indexes: composite indexes. Composite indexes ...

Percona XtraBackup 2.3.3 is now available

MySQL Performance Blog - Thu, 17/12/2015 - 1:30pm

Percona is glad to announce the release of Percona XtraBackup 2.3.3 on December 17th, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, ...

The post Percona XtraBackup 2.3.3 is now available appeared first on MySQL Performance Blog.

Using dbsake to recover table structure from .frm files and process mysqldump output

MySQL Performance Blog - Wed, 16/12/2015 - 8:34pm

We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there was no backup available. There is already a great blog post by my colleague Miguel Ángel ...

The post Using dbsake to recover table structure from .frm files and process mysqldump output appeared first on MySQL Performance Blog.

Pages

Subscribe to MySQL Performance Blog