Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 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 14, 2015
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 [...]
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 4, 2015
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 [...]
December 4, 2015
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 [...]
December 3, 2015
Amazon Aurora in sysbench benchmarks
In my previous post Amazon Aurora – Looking Deeper, I promised benchmark results on Amazon Aurora. Amazon used quite a [...]
December 2, 2015
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 [...]
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 [...]
December 1, 2015
How to upgrade your master server with minimal downtime
Here’s a step-by-step guide on how to invert roles for master and slave so you can perform a master server upgrade, [...]
December 1, 2015
Transporting tablespace from MySQL 5.6 to MySQL 5.7 (case study)
Recently, I was working on a MySQL support ticket where a customer was facing an issue while transporting tablespace from MySQL [...]
November 25, 2015
Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2
Introduction In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own [...]
November 16, 2015
Amazon Aurora – Looking Deeper
Recently my colleague (by Percona) Yves Trudeau and colleague (by industry) Marco Tusa published their materials on Amazon Aurora. Indeed, Amazon [...]
November 13, 2015
pt-online-schema-change and innodb_stats_persistent on MySQL 5.6
Recently we released an updated version of our Percona Toolkit with an important update for pt-online-schema-change if you use MySQL [...]
November 12, 2015
Logical MySQL backup tool Mydumper 0.9.1 now available
The new Mydumper 0.9.1 version, which includes many new features and bug fixes, is now available. You can download the code [...]
November 9, 2015
Percona Toolkit 2.2.16 is now available
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 [...]
November 5, 2015
Percona Server 5.6.27-75.0 is now available
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 [...]
November 5, 2015
Percona Server 5.5.46-37.5 is now available
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 [...]
November 4, 2015
MySQL 5.7: CHANGE REPLICATION FILTER online
MySQL 5.7 has a lot of enhancements and new features. I summarized this list previously in this blog post. Adding [...]