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 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 David Quilty | Jun 26, 2020 | MySQL, Open Source, Webinars
Join Sveta Smirnova, MySQL Engineer at Percona, as she discusses modern solutions for modern database loads. MySQL is famous for working well in high performing environments. This is the reason why it is the most popular backend for web applications. But our view of...
by Sri Sakthivel | Jun 24, 2020 | Insight for DBAs, MySQL
Usually, database people are familiar with table fragmentation with DELETE statements. Whenever doing a huge delete, in most cases, they are always rebuilding the table to reclaim the disk space. But, are you thinking only DELETEs can cause table fragmentation?...
by Fernando Laudares Camargos | Jun 23, 2020 | Monitoring, MySQL, Percona Software
by Rick Golba | Jun 23, 2020 | Insight for DBAs, MySQL, Percona Software
Percona is pleased to announce the release of Percona Distribution for MySQL. Following our recent releases of Percona Distribution for MongoDB and Percona Distribution for PostgreSQL, we have assembled the best and most critical enterprise components for MySQL,...
by Peter Zaitsev | Jun 17, 2020 | Monitoring, MySQL, Percona Software
The RED Method (Rate, Errors, Duration) is one of the more popular performance monitoring approaches. It is often applied to Monitoring Microservices though there is nothing that prevents it from being applied to databases like MySQL. In Percona Monitoring and...
by David Quilty | Jun 16, 2020 | MySQL, Open Source, Webinars
Join Peter Zaitsev, CEO at Percona, as he discusses database challenges and the concepts of open source and open core. Over the years, open source companies have tried to bring products to market and maximize their revenue streams. To date, the most popular open...
by Mykola Marzhan | Jun 12, 2020 | Insight for DBAs, MySQL, Security
In most cases, MySQL password instructions provide information on changing MySQL user passwords on the production system (e.g., reset root password without restart). It is even recommended to change passwords regularly for security reasons. But still, sometimes DBA...
by Max Dudin | Jun 11, 2020 | Insight for DBAs, MySQL, Security
Day-to-day database operation requires, from an administrator, deep knowledge of db internals and security issues, in particular things like SQL injections. In order to prevent such kind of an attack, we have included go-sql-driver into our code for secure placeholder...
by David Quilty | Jun 11, 2020 | MySQL, Percona Software, Webinars
In this webinar, Sveta Smirnova, MySQL Engineer at Percona, will uncover nuances of Percona XtraDB Cluster (PXC) schema upgrades and point out details you need to give extra attention to. Percona XtraDB Cluster (PXC) is a 100% synchronized cluster in regards to DML...
