EmergencyEMERGENCY? Get 24/7 Help Now!

Percona XtraBackup 2.3.3 is now available

 | December 17, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

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, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

Read More

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

 | December 16, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL

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 Nieto about how we can recover structures from .frm files using MySQL utilities. This works pretty well and we prefer […]

Read More

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

 | December 15, 2015 |  Posted In: Percona Live, Performance Schema

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 Data Performance Conference is the premier open source event for the data performance ecosystem. It is the place to be […]

Read More

MongoDB 3.2 WiredTiger in iiBench

 | December 15, 2015 |  Posted In: Benchmarks, MongoDB

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 RocksDB and PerconaFT in in-memory workloads, but it demonstrates performance degradation when we move into IO workloads. There are reports that WiredTiger […]

Read More

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

 | December 14, 2015 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL, MySQL 101

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 Alex’s query tuning experience, making the right index decision is simple – but what about us mere mortals? If a query is more […]

Read More

Percona Server 5.7.10-1 first RC available

 | December 14, 2015 |  Posted In: Events and Announcements, InnoDB, MySQL, Percona Server for MySQL, Percona Software, TokuDB

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 fixes from latest Percona Server 5.6 release (currently Percona Server 5.6.27-76.0). New Features: Percona Server 5.7.10-1 is not available on […]

Read More

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

 | December 10, 2015 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, MySQL

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 percentage of rows that were actually needed, against the equal or bigger number of resolved rows. While the user was happy […]

Read More

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

 | December 8, 2015 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, MySQL

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 results instead. Like finding 4079 countries in Antarctica:

Or not finding any cities in Georgia:

I used a standard world […]

Read More

Percona Server 5.6.27-76.0 is now available

 | December 4, 2015 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

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 fixes in it, Percona Server 5.6.27-76.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

Read More