EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live 2017: Day Two Keynotes

 | April 26, 2017 |  Posted In: Big Data, InnoDB, Insight for DBAs, Insight for Developers, MySQL, MySQL 8.0, Percona Live

Percona Live 2017

Welcome to the second day of the Percona Live Open Source Database Conference 2017, and the second set of Percona Live keynotes! It’s a bit rainy outside today, but that isn’t bothering the Percona Live attendees (we’re all indoors learning about new open source technologies)! Day two of the conference kicked off with another four keynote […]

Read More

New MariaDB Dashboard in Percona Monitoring and Management Metrics Monitor

 | April 3, 2017 |  Posted In: Events and Announcements, InnoDB, Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Monitoring and Management, Percona Server, Percona Software, PMM

MariaDB

In honor of the upcoming MariaDB M17 conference in New York City on April 11-12, we have enhanced Percona Monitoring and Management (PMM) Metrics Monitor with a new MariaDB Dashboard and multiple new graphs! The Percona Monitoring and Management MariaDB Dashboard builds on the efforts of the MariaDB development team to instrument the Aria Storage Engine Status Variables related […]

Read More

Percona Server for MySQL 5.7.17-12 is Now Available

 | March 24, 2017 |  Posted In: Events and Announcements, MySQL, Percona Server, TokuDB

Percona Server for MySQL 5.7.17-12

Percona announces the GA release of Percona Server for MySQL 5.7.17-12 on March 24, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.7.17, including all the bug fixes in it, Percona Server for MySQL […]

Read More

Open Source Databases on Big Machines: Disk Speed and innodb_io_capacity

 | March 1, 2017 |  Posted In: MySQL, open source databases, OpenSource Databases on big machines

In this blog post, I’ll look for the bottleneck that prevented the performance in my previous post from achieving better results. The powerful machine I used in the tests in my previous post has a comparatively slow disk, and therefore I expected my tests would hit a point when I couldn’t increase performance further due to the disk speed. […]

Read More

Percona Server for MySQL 5.7.17-11 is now available

 | February 3, 2017 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

Percona PAM

Percona announces the GA release of Percona Server for MySQL 5.7.17-11 on February 3, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.17, including all the bug fixes in it, Percona Server for MySQL 5.7.17-11 is the current GA release in the Percona Server for MySQL 5.7 series. […]

Read More

Percona Live Featured Tutorial with Frédéric Descamps — MySQL InnoDB Cluster & Group Replication in a Nutshell: Hands-On Tutorial

 | January 26, 2017 |  Posted In: High-availability, MySQL, Percona Live

Percona Live Featured Tutorial

Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read More

Webinar Wednesday January 25, 2017: Percona Server for MySQL 5.7 Key Performance Algorithms

 | January 23, 2017 |  Posted In: MySQL, Technical Webinars

Percona Server for MySQL 5.7.17-12

Please join Laurynas Biveinis, Percona’s Technical Director – Engineering, on January 25, 2017, at 7 am EST (UTC-8) as he discusses “Percona Server for MySQL 5.7: Key Performance Algorithms.” In this webinar, Laurynas will discuss selected areas of InnoDB and Percona Server for MySQL 5.7 internals as they relate to buffer pool management and flushing […]

Read More

Open Source Databases on Big Machines: Does READ COMMITTED Scale on 144 Cores?

 | January 19, 2017 |  Posted In: open source databases, OpenSource Databases on big machines

READ COMMITTED

In the second post in my series on open source databases on big machines, we’ll look at whether READ COMMITTED scales with multiple cores. The default transaction level for InnoDB is REPEATABLE READ. A more permissive level is  READ COMMITTED, and is known to work well. While the  REPEATABLE READ level maintains the transaction history up to the start of the transaction, […]

Read More

The Impact of Swapping on MySQL Performance

 | January 13, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, PMM

In this blog, I’ll look at the impact of swapping on MySQL performance.  It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL’s case) is standard practice to make sure there is enough free […]

Read More