by Sveta Smirnova | Sep 11, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL
In this post, we will discuss the best way to update an InnoDB table manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default....
by Manjot Singh | Jun 28, 2017 | MySQL, Security
Welcome to Part 2 in a series of blog posts on MySQL encryption at rest. This post covers InnoDB tablespace encryption. At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL...
by Colin Charles | Jun 19, 2017 | MariaDB, MySQL
This blog post looks at the recent MariaDB Server 10.2 GA release. Congratulations to the MariaDB Foundation for releasing a generally available (GA) stable version of MariaDB Server 10.2! We’ll definitely spend the next few weeks talking about MariaDB Server...
by Manjot Singh | Jun 6, 2017 | MySQL, Security
In this first of a series of blog posts, we’ll look at MySQL encryption at rest. At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL needs to be encrypted “at...
by Hrvoje Matijakovic | May 26, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server for MySQL 5.7.18-15 on May 26, 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...
by Agustín | May 22, 2017 | Insight for DBAs, MariaDB, MySQL, Percona Software
In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series. As mentioned in the previous post, in this blog we will look at how to check on ICP counters on...
by Hrvoje Matijakovic | May 12, 2017 | MySQL, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.18-14 on May 12, 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...
by Alexander Rubin | May 8, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll review how a hung MySQL transaction can cause the InnoDB history length to grow and negatively affect MySQL performance. Recently I was helping a customer discover why SELECT queries were running slower and slower until the server restarts...
by Michael Coburn | May 4, 2017 | MongoDB, Monitoring, MySQL, Percona Software
I heard a frequent question at last week’s Percona Live conference regarding Percona Monitoring and Management (PMM): How much disk space should I allocate for PMM Server? First, let’s review the three components of Percona Monitoring and Management that...
by Dave Avery | Apr 26, 2017 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
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...
by Marco Tusa | Apr 10, 2017 | Insight for DBAs, MySQL, Percona Software
If you met one of the (few) MySQL consultants around the globe and asked him/her to review your queries and/or schemas, I am sure that he/she would tell you something regarding the importance of good primary key(s) design. Especially in the case of InnoDB, I’m...
by Michael Coburn | Apr 3, 2017 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Events, Percona Software
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...
by Hrvoje Matijakovic | Mar 24, 2017 | MySQL, Percona Events, Percona Software
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...
by Sveta Smirnova | Mar 1, 2017 | MySQL, Open Source
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...
by Hrvoje Matijakovic | Feb 3, 2017 | MySQL, Percona Events, Percona Software
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...
by Dave Avery | Jan 26, 2017 | Insight for DBAs, MySQL, Percona Live
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...
by Dave Avery | Jan 23, 2017 | MySQL, Webinars
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...
by Sveta Smirnova | Jan 19, 2017 | Open Source
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...
by Peter Zaitsev | Jan 13, 2017 | Insight for DBAs, MySQL
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...
by Peter Zaitsev | Dec 28, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to...
