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

Act Quickly for Percona Live Super Saver rate – Plus an added incentive!

MySQL Performance Blog - Tue, 15/12/2015 - 10:43pm

Our Super Saver discount rate for Percona Live 2016 is only available ‘til December 31st! This rate gets you all the excellent and amazing opportunities that Percona Live offers, at a discount. The Percona Live ...

The post Act Quickly for Percona Live Super Saver rate – Plus an added incentive! appeared first on MySQL Performance Blog.

MongoDB 3.2 WiredTiger in iiBench

MySQL Performance Blog - Tue, 15/12/2015 - 6:30pm

MongoDB 3.2 was recently released with WiredTiger as the default storage engine. In just over five years, MongoDB has evolved into a popular database. MongoDB 3.0 supported “pluggable storage engines.” The B-Tree-based WiredTiger shoule outperform IO-optimized ...

The post MongoDB 3.2 WiredTiger in iiBench appeared first on MySQL Performance Blog.

used_columns: EXPLAIN FORMAT=JSON tells when you should use covered indexes

MySQL Performance Blog - Mon, 14/12/2015 - 11:04pm

In the “MySQL Query tuning 101” video, Alexander Rubin provides an excellent example of when to use a covered index. On slide 25, he takes the query [crayon-566f661460fb6797259620-i/] and adds the index [crayon-566f661460fc9538594041-i/] on table [crayon-566f661460fd1535255488-i/]. With ...

Percona Server 5.7.10-1 first RC available

MySQL Performance Blog - Mon, 14/12/2015 - 9:36pm

Percona is glad to announce the first release candidate of Percona Server 5.7.10-1 on December 14, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. This release contains all the bug ...

The post Percona Server 5.7.10-1 first RC available appeared first on MySQL Performance Blog.

Percona Server for MongoDB 3.0.7-1.0 is now available

MySQL Performance Blog - Mon, 14/12/2015 - 5:00am

Percona is pleased to announce the GA release of Percona Server for MongoDB 3.0.7-1.0 on December 14, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Percona Server for MongoDB is an enhanced, ...

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

rows_examined_per_scan, rows_produced_per_join: EXPLAIN FORMAT=JSON answers on question “What number of filtered rows mean?”

MySQL Performance Blog - Thu, 10/12/2015 - 11:00pm

At the end of my talk “Troubleshooting MySQL Performance” at the LinuxPiter conference, a user asked me a question: “What does the EXPLAIN ‘filtered’ field mean, and how do I use it?” I explained that this is the ...

attached_condition: How EXPLAIN FORMAT=JSON can spell-check your queries

MySQL Performance Blog - Tue, 08/12/2015 - 6:49pm

When you work with complicated queries, especially ones which contain subqueries, it is easy to make a typo or misinterpret column name. While in many cases you will receive [crayon-566728b665e7c802778575-i/] error sometimes you can get strange ...

The post attached_condition: How EXPLAIN FORMAT=JSON can spell-check your queries appeared first on MySQL Performance Blog.

Percona Server 5.6.27-76.0 is now available

MySQL Performance Blog - Fri, 04/12/2015 - 4:54pm

Percona is glad to announce the release of Percona Server 5.6.27-76.0 on December 4, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.27, including all the bug ...

The post Percona Server 5.6.27-76.0 is now available appeared first on MySQL Performance Blog.

Percona Server 5.5.46-37.6 is now available

MySQL Performance Blog - Fri, 04/12/2015 - 4:52pm

Percona is glad to announce the release of Percona Server 5.5.46-37.6 on December 4, 2015. Based on MySQL 5.5.46, including all the bug fixes in it, Percona Server 5.5.46-37.6 is now the current stable release ...

The post Percona Server 5.5.46-37.6 is now available appeared first on MySQL Performance Blog.

Amazon Aurora in sysbench benchmarks

MySQL Performance Blog - Thu, 03/12/2015 - 5:22pm

In my previous post Amazon Aurora – Looking Deeper, I promised benchmark results on Amazon Aurora. There are already some results available from Amazon itself: https://d0.awsstatic.com/product-marketing/Aurora/RDS_Aurora_Performance_Assessment_Benchmarking_v1-2.pdf. There are also some from Marco Tusa: http://www.tusacentral.net/joomla/index.php/mysql-blogs/175-aws-aurora-benchmarking-blast-or-splash.html. Amazon used ...

Upcoming Webinar: MySQL 5.7 in a Nutshell

MySQL Performance Blog - Wed, 02/12/2015 - 10:35pm

Join Alexander Rubin, Principal Consultant, Percona as he provides an overview of MySQL 5.7 features. Wednesday, December 9, 2015 10:00AM PST (GMT -08:00). MySQL® 5.7 is a great release that has a lot to offer, ...

The post Upcoming Webinar: MySQL 5.7 in a Nutshell appeared first on MySQL Performance Blog.

Fixing errant transactions with mysqlslavetrx prior to a GTID failover

MySQL Performance Blog - Wed, 02/12/2015 - 6:05pm

Errant transactions are a major issue when using GTID replication. Although this isn’t something new, the drawbacks are more notorious with GTID than with regular replication. The situation where errant transaction bite you is a ...

The post Fixing errant transactions with mysqlslavetrx prior to a GTID failover appeared first on MySQL Performance Blog.

How to upgrade your master server with minimal downtime

MySQL Performance Blog - Tue, 01/12/2015 - 5:31pm

Here’s a step-by-step guide on how to invert roles for master and slave so you can perform a master server upgrade, and then switch roles back to the original setup. * While following this guide consider ...

The post How to upgrade your master server with minimal downtime appeared first on MySQL Performance Blog.

Transporting tablespace from MySQL 5.6 to MySQL 5.7 (case study)

MySQL Performance Blog - Tue, 01/12/2015 - 7:32am

Recently, I was working on a MySQL support ticket where a customer was facing an issue while transporting tablespace from MySQL 5.6 to MySQL 5.7. After closely reviewing the situation, I saw that while importing tablespace they were getting errors ...

The post Transporting tablespace from MySQL 5.6 to MySQL 5.7 (case study) appeared first on MySQL Performance Blog.

Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2

MySQL Performance Blog - Wed, 25/11/2015 - 3:36pm

Introduction In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon board. That implementation is great, but requires constant internet ...

The post Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2 appeared first on MySQL Performance Blog.

Amazon Aurora – Looking Deeper

MySQL Performance Blog - Mon, 16/11/2015 - 9:26pm

Recently my colleague (by Percona) Yves Trudeau and colleague (by industry) Marco Tusa published their materials on Amazon Aurora. Indeed, Amazon Aurora is a hot topic these days, and we have a stream of customer inquiries ...

The post Amazon Aurora – Looking Deeper appeared first on MySQL Performance Blog.

pt-online-schema-change and innodb_stats_persistent on MySQL 5.6

MySQL Performance Blog - Fri, 13/11/2015 - 4:46pm

Recently we released an updated version of our Percona Toolkit with an important update for pt-online-schema-change if you use MySQL 5.6. A new parameter has been added, analyze-before-swap. What does it do? Let me explain ...

The post pt-online-schema-change and innodb_stats_persistent on MySQL 5.6 appeared first on MySQL Performance Blog.

Logical MySQL backup tool Mydumper 0.9.1 now available

MySQL Performance Blog - Thu, 12/11/2015 - 3:32pm

The new Mydumper 0.9.1 version, which includes many new features and bug fixes, is now available.  You can download the code from here. A significant change included in this version now enables Mydumper to handle all schema objects!! ...

The post Logical MySQL backup tool Mydumper 0.9.1 now available appeared first on MySQL Performance Blog.

Percona Toolkit 2.2.16 is now available

MySQL Performance Blog - Mon, 09/11/2015 - 9:44pm

Percona is pleased to announce the availability of Percona Toolkit 2.2.16, released on November 9, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult ...

The post Percona Toolkit 2.2.16 is now available appeared first on MySQL Performance Blog.

Percona Server 5.6.27-75.0 is now available

MySQL Performance Blog - Thu, 05/11/2015 - 8:45pm

Percona is glad to announce the release of Percona Server 5.6.27-75.0 on November 5, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.27, including all the bug ...

The post Percona Server 5.6.27-75.0 is now available appeared first on MySQL Performance Blog.

Percona Server 5.5.46-37.5 is now available

MySQL Performance Blog - Thu, 05/11/2015 - 8:44pm

Percona is glad to announce the release of Percona Server 5.5.46-37.5 on November 5, 2015. Based on MySQL 5.5.46, including all the bug fixes in it, Percona Server 5.5.46-37.5 is now the current stable release ...

The post Percona Server 5.5.46-37.5 is now available appeared first on MySQL Performance Blog.

MySQL 5.7: CHANGE REPLICATION FILTER online

MySQL Performance Blog - Thu, 05/11/2015 - 1:16am

MySQL 5.7 has a lot of enhancements and new features. I summarized this list previously in this blog post. Adding replication filters online is one of the MySQL 5.7 features described in this manual. However, I ...

The post MySQL 5.7: CHANGE REPLICATION FILTER online appeared first on MySQL Performance Blog.

A first look at RDS Aurora

MySQL Performance Blog - Mon, 02/11/2015 - 8:23pm

Recently, I happened to have an onsite engagement and the goal of the engagement was to move a database service to RDS Aurora. Like probably most of you, I knew the service by name but ...

The post A first look at RDS Aurora appeared first on MySQL Performance Blog.

MySQL and Trojan.Chikdos.A

MySQL Performance Blog - Thu, 29/10/2015 - 4:23pm

Symantec published a blog post yesterday regarding MySQL and the Trojan.Chikdos.A as can be seen here The Symantec post gives detail into the behavior of the Trojan and it’s effects on the Windows system registry, ...

The post MySQL and Trojan.Chikdos.A appeared first on MySQL Performance Blog.

MySQL 5.7 first impressions on group-replication

MySQL Performance Blog - Thu, 29/10/2015 - 1:55pm

During the last few weeks I’ve been testing and playing a bit with the new group-replication plugin available for MySQL 5.7. Before continuing I’d like to clarify some aspects: the plugin is only available in labs ...

The post MySQL 5.7 first impressions on group-replication appeared first on MySQL Performance Blog.

Pages

Subscribe to MySQL Performance Blog