by Yura Sorokin | Jul 27, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
What is the easiest way to generate a sequence of integers in MySQL? In other words, which “SELECT <something>” statement should I write to get 0, 1, 2, … N – 1? This is the question I have been struggling with for years and it looks like...
by Daniel Guzmán Burgos | Jul 22, 2020 | Insight for DBAs, Monitoring, Percona Software, Security
The Security Threat Tool has been available since Percona Monitoring and Management 2.6.0 (PMM) and starting from that first release it is proving to be a severely-needed feature. If you’re not familiar with the Security Threat Tool (STT), it helps you to ensure...
by Rick Golba | Jul 21, 2020 | Cloud, MySQL, Percona Software
On July 21, 2020, Percona delivered an updated version of our Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) focused on easing deployment and operations management of a clustered MySQL environment. Included in the Percona Distribution for MySQL, our...
by George O. Lorch III | Jul 21, 2020 | MySQL, Percona Software
On Monday, July 13, 2020, Oracle released MySQL 8.0.21. This release contained a few new changes that cause issues with Percona XtraBackup. First, this release introduced the ability to temporarily disable InnoDB redo logging (see the work log and documentation). If...
by Sami Ahlroos | Jul 20, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
The Percona Kubernetes Operator for Percona XtraDB Cluster can send backups to Amazon S3 or S3-compatible storage. And every now and then at Support, we are asked how to send backups to Google Cloud Storage. Google Cloud Storage offers an “interoperability mode” which...
by Sri Sakthivel | Jul 17, 2020 | Benchmarks, Insight for DBAs, MariaDB, Storage Engine
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More MariaDB 10.5 has an excellent engine plugin called “S3”. The S3 storage engine is based...
by Roman Misyurin | Jul 16, 2020 | Monitoring, Percona Software
We’ve been improving the Query Analytics component of Percona Monitoring and Management (PMM). Here’s a summary of what we’ve done, beginning with a reminder of what PMM is and what it’s for. Database Troubleshooting and PMM Troubleshooting...
by Peter Zaitsev | Jul 15, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
When I speak about MySQL performance troubleshooting (or frankly any other database), I tend to speak about four primary resources which typically end up being a bottleneck and limiting system performance: CPU, Memory, Disk, and Network. It would be great if when...
by Sri Sakthivel | Jul 9, 2020 | Insight for DBAs, MySQL
In this blog, I will look at the tool binlog2sql, designed by Cao Danfeng. The tool will help to decode the MySQL binary logs and extract the raw SQL, which also helps to generate the ROLLBACK statements for point in time recovery (PITR) using the “flashback” feature....
by Daniel Guzmán Burgos | Jul 9, 2020 | Cloud, MySQL, Percona Software
You got yourself a Kubernetes cluster and are now testing our Percona Kubernetes Operator for Percona XtraDB Cluster. Everything is working great and you decided that you want to increase the number of Percona XtraDB Cluster (PXC) pods from the default 3, to let’s...
by Michael Patrick | Jul 8, 2020 | Monitoring, MySQL, Open Source
by Marco Tusa | Jul 7, 2020 | Insight for DBAs, MySQL
Why another article on this, Marco? MySQL deadlocks is a topic covered many times, including here at Percona. I suggest you review the reference section at the end of this post for articles on how to identify deadlocks and from where they are generated. So why another...
by David Quilty | Jul 7, 2020 | MySQL, Webinars
Join Peter Zaitsev, Percona CEO, as he discusses MySQL 8 Observability. Broken MySQL means broken application, so maintaining insights in MySQL operational performance is critical. Thankfully, MySQL 8 offers a lot in terms of observability to resolve problems quickly...
by Michael Patrick | Jul 6, 2020 | Insight for DBAs, MySQL
When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL. Below are some of the most important of these settings to help you get started. Swappiness The first thing to look at is what swappiness is set to. ...
by Daniel Guzmán Burgos | Jul 3, 2020 | Cloud, MySQL, Percona Software, ProxySQL
The Percona Kubernetes Operator for Percona XtraDB Cluster(PXC) comes with ProxySQL as part of the deal. And to be honest, the behavior of ProxySQL is pretty much the same as in a regular non-k8s deployment of it. So why bother to write a blog about it? Because what...
by Tate McDaniel | Jul 1, 2020 | Insight for DBAs, Monitoring, MySQL
One of the most common errors encountered in the MySQL world at large is the infamous Error 1040: Shell ERROR 1040 (00000): Too many connections 1 ERROR 1040 (00000): Too many connections What this means in practical terms is that a MySQL instance has reached...
by David Quilty | Jul 1, 2020 | Monitoring, Percona Software, Security, Webinars
Data breaches seem to be a daily occurrence, so much so that seeing an article about the latest company to fall victim draws little attention outside of those immediately impacted. That is of course unless that company is yours and data security is your...
by Marco Tusa | Jul 1, 2020 | MySQL, Percona Software, ProxySQL
In real life, there are frequent cases where getting a running application to work correctly is strongly dependent on consistent write/read operations. This is no issue when using a single data node as a provider, but it becomes more concerning and challenging when...
by Leonardo Bacchi Fernandes | Jun 30, 2020 | Insight for DBAs, MySQL
In this blog post, we will briefly explore the OS tool strace. It is not widely used due to its performance impacts, and we don’t recommend using it in production. Still, it is amazing at helping you understand some things that happen in MySQL, where the OS is...
by Przemysław Malkowski | Jun 29, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option. Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona...
