by Dmitriy Kostiuk | May 31, 2018 | MySQL, Percona Events, Percona Live, Percona Software, Security, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.22-22 on on May 31, 2018. 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....
by Dmitriy Kostiuk | Apr 24, 2018 | MySQL, Percona Events, Percona Live, Percona Software, Security, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.21-21 on on April 24, 2018. 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....
by Dmitriy Kostiuk | Apr 16, 2018 | Insight for DBAs, MariaDB, 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...
by Sveta Smirnova | Mar 27, 2018 | Insight for DBAs, MySQL, Storage Engine
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...
by Nickolay Ihalainen | Feb 22, 2018 | Hardware and Storage, Insight for DBAs, Monitoring, MySQL
The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of defense. Even if you lost all data from a production server, physical backups (data files snapshot created with an offline copy or with...
by Dmitriy Kostiuk | Feb 19, 2018 | MySQL, Percona Events, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.21-20 on February 19, 2018. 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....
by Yves Trudeau | Feb 8, 2018 | Hardware and Storage, Insight for DBAs, MySQL
While preparing a post on the design of ZFS based servers for use with MySQL, I stumbled on the topic of fsync call performance. The fsync call is very expensive, but it is essential to databases as it allows for durability (the “D” of the ACID acronym)....
by Peter Zaitsev | Feb 5, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll look into four ways MySQL executes GROUP BY. In my previous blog post, we learned that indexes or other means of finding data might not be the most expensive part of query execution. For example, MySQL GROUP BY could potentially be...
by Michael Coburn | Jan 16, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Webinars
Join Percona’s Product Manager Michael Coburn as he presents MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2 on Thursday, January 18, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Register Now Tags: Percona...
by Dmitriy Kostiuk | Jan 8, 2018 | MySQL, Percona Events, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.20-19 on January 3, 2018. 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....
by Peter Zaitsev | Jan 5, 2018 | MySQL, Webinars
Thank you for attending my webinar on Wednesday, December 20, 2017, InnoDB Performance Optimization. In this blog, I will provide answers to the Q & A for the webinar. Are the T2 CPUs similar to the M4 series? I would expect them to be similar. Amazon does not...
by Peter Zaitsev | Dec 18, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents InnoDB Performance Optimization on Wednesday, December 20, 2017, at 11:00 am PST / 2:00 pm EST (UTC-8). InnoDB is one of the most commonly used storage engines for MySQL and Percona Server for MySQL. It...
by Hrvoje Matijakovic | Dec 14, 2017 | MySQL, Percona Events, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.20-18 on December 14, 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....
by Alexander Rubin | Dec 4, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog post, I investigate a case of spiking InnoDB Rows inserted in the absence of a write query, and find internal temporary tables to be the culprit. Recently I was investigating an interesting case for a customer. We could see the regular spikes on a graph...
by Vadim Tkachenko | Nov 20, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at some of the facets of InnoDB page compression. Somebody recently asked me about the best way to handle JSON data compression in MySQL. I took a quick look at InnoDB page compression and wanted to share my findings. First, the...
by Peter Zaitsev | Oct 31, 2017 | Monitoring, MySQL, Percona Software
In this blog post, I’ll walk through some of the improvements to the Percona Monitoring and Management (PMM) MySQL dashboard in release 1.4.0. As the part of Percona Monitoring and Management development, we’re constantly looking for better ways to visualize...
by Peter Zaitsev | Oct 18, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size. Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction...
by Alexander Rubin | Oct 1, 2017 | Insight for DBAs, MySQL
In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance. Background questions Q: Why million...
by Jervin Real | Sep 25, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at how to avoid shared locks from subqueries. I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query: MySQL update ibreg set k=1 where id in (select id from ibcmp where id >...
by Lorraine Pocklington, Community Manager | Sep 25, 2017 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Live
Welcome to the first day of the Percona Live Open Source Database Conference Europe 2017: Tutorials day! Technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source...
