Emergency

Percona Data Performance Blog

Latest articles from our experts:
MongoDB 3.2 WiredTiger in iiBench

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 should outperform IO-optimized …

Read More
 
used_columns: EXPLAIN FORMAT=JSON tells when you s...

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 select name from City where CountryCode = ’USA’ and District = ’Alaska’ and population > 10000 and adds the index cov1(CountryCode, District, population, name) on table City. With …

Read More
 
Percona Server 5.7.10-1 first RC available

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 …

Read More
 
Percona Server for MongoDB 3.0.7-1.0 is now availa...

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.

Read More
 
rows_examined_per_scan, rows_produced_per_join: EX...

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 …

Read More
 
attached_condition: How EXPLAIN FORMAT=JSON can sp...

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 a  column not found error, sometimes you can get strange …

Read More
 
Percona Server 5.6.27-76.0 is now available

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 …

Read More
 
Percona Server 5.5.46-37.6 is now available

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 …

Read More
 
Amazon Aurora in sysbench benchmarks

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 …

Read More
 
Upcoming Webinar: MySQL 5.7 in a Nutshell

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, …

Read More
 


InnoDB Posts
InnoDB and TokuDB on AWS

In a recent post, Vadim compared the performance of Amazon Aurora and Percona Server on AWS. This time, I am comparing write throughput for InnoDB and TokuDB, using the same workload (sysbench oltp/update/update_non_index) and a similar set-up (r3.xlarge instance, …

Read More
 
Using dbsake to recover table structure from .frm ...

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 …

Read More
 


Insight for DBAs Posts
Better high availability: MySQL and Percona XtraDB...

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 …

Read More
 
Using dbsake to recover table structure from .frm ...

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 …

Read More
 


Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.

Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below.

No, thank you. Please do not ask me again.