Buy Percona ServicesBuy Now!

How Binary Logs (and Filesystems) Affect MySQL Performance

 | May 4, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, MySQL 8.0

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a […]

Read More

Percona Live 2018: Closing Ceremony with Lightning Talks

 | April 25, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, High-availability, InnoDB, Insight for DBAs, Percona Live

Mariella ViaSat Percona Live 2018

Percona Live 2018 is officially done! The closing ceremony ends the conference with a last few lightning talks and a prize giveaway. We ended the Percona Live 2018 conference the same way we started: with talks! This year, we had our lightning talks as part of our closing ceremony. They included: Amazon Aurora MySQL and […]

Read More

Percona Live 2018: POLARDB, an InnoDB Based Shared-Everything Storage Solution

 | April 25, 2018 |  Posted In: Cloud and MySQL, InnoDB, open source databases, Percona Live

Inaam Alibaba Percona Live 2018

We’re heading into the home stretch at Percona Live 2018, but the sessions are continuing. I was able to attend a talk this afternoon given by Inaam Rana, a Database Developer at Alibaba Cloud, on PolarDB, an InnoDB based shared-everything storage solution. POLARDB provides read scale out on shared everything architecture. It features 100% backward […]

Read More

Congratulations to Our Friends at Oracle with the MySQL 8.0 GA Release!

 | April 19, 2018 |  Posted In: InnoDB, Insight for DBAs, Insight for Developers, MySQL, Percona Live

MySQL 8.0 GA

It is a great today for whole MySQL community: MySQL 8.0 was just released as GA! Geir Høydalsvik has a great summary in his “What’s New in MySQL 8.0” blog post. You can find additional information about MySQL 8.0 Replication and MySQL 8.0 Document Store that is also worth reading. If you can’t wait to upgrade to MySQL […]

Read More

Binlog and Replication Improvements in Percona Server for MySQL

 | April 16, 2018 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL

Percona Server for MySQL

Due to continuous development and improvement, Percona Server for MySQL incorporates a number of improvements related to binary log handling and replication. This results in replication specifics, distinguishing it from MySQL Server. Temporary tables and mixed logging format Summary of the fix: As soon as some statement involving temporary tables was met when using a mixed binlog format, MySQL […]

Read More

Percona Live Europe 2018 – Save the Date!

 | April 5, 2018 |  Posted In: InnoDB, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MyRocks, MySQL, Percona Live, PostgreSQL, ProxySQL, Time Series Database

Percona Live Europe 2018

We’ve been searching for a great venue for Percona Live Europe 2018, and I am thrilled to announce we’ll be hosting it in Frankfurt, Germany! Please block November 5-7, 2018 on your calendar now and plan to join us at the Radisson Blu Frankfurt for the premier open source database conference. Percona Live Europe will […]

Read More

Multi-Source Replication Performance with GTID

 | March 30, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, Replication

Multi-Source Replication with GTID

In this blog post, we’ll look at the performance of multi-source replication with GTID. Note. This blog was edited as I received some comments from Percona colleagues. I’ve updated the contents in the marked EDIT section. Thanks! Multi-Source Replication is a topology I’ve seen discussed recently, so I decided to look into how it performs […]

Read More

ANALYZE TABLE Is No Longer a Blocking Operation

 | March 27, 2018 |  Posted In: InnoDB, Insight for DBAs, MyRocks, MySQL, TokuDB

analyze table

In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table. In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops ANALYZE TABLE from invalidating query and […]

Read More

New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go

 | March 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 101, MySQL 8.0, Percona Monitoring and Management

MySQL 8.0 innodb_dedicated_server

In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable. MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these variables are not explicitly defined in my.cnf). The new MySQL 8.0 variable automatically sizes the following variables based on the RAM size of […]

Read More