by Valentina Lago | Aug 6, 2020 | MongoDB, MySQL, Percona Events, PostgreSQL
In the lead up to Percona Live Online, we are excited to introduce Percona Tech Days! Percona Tech Days are free, half-day events dedicated to the most popular open source database technologies: MySQL, MongoDB, and PostgreSQL. Each day, we’ll be focusing on one...
by Tibor Korocz | Aug 6, 2020 | Benchmarks, MySQL, Percona Software
Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I will share the results of using it to run MySQL in comparison with an Intel device that had a similar capacity. First of all, why do we need another storage...
by Yves Trudeau | Aug 4, 2020 | MariaDB, MySQL, Storage Engine
This post has been written in collaboration with Nicolas Modalvsky of e-planning. Nicolas and I recently worked together on a tuning engagement involving MyRocks on MariaDB. While it is easy to find online articles and posts about InnoDB performance, finding...
by Marco Tusa | Aug 3, 2020 | Insight for DBAs, Insight for Developers, MySQL
A small thing that provides a huge help. The other day I was writing some code to process a very large amount of items coming from a social media API. My items were ending in a queue in MySQL and then needed to be processed and eventually moved. The task was not so...
by Vadim Tkachenko | Jul 30, 2020 | Benchmarks, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More MySQL and MariaDB on NVMe Storage – The Great Equalizer Continuing with the...
by Vadim Tkachenko | Jul 29, 2020 | Benchmarks, MariaDB, MySQL
Continuing with the checkpointing topic I restarted a month ago with MongoDB and followed with PostgreSQL, I wanted to check how MySQL and MariaDB perform. It was actually some time when I last looked into MySQL in this regard, so I am curious how new MySQL versions...
by Sveta Smirnova | Jul 28, 2020 | MySQL, Percona Software
I got this question on the “How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster (PXC)” webinar and wanted to answer it in a separate post. Will RSU have an effect on GTID consistency if replication PXC cluster to another cluster? Answer for...
by Sri Sakthivel | Jul 27, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
I would say that innodb_rollback_on_timeout is a very important parameter. In this blog, I am going to explain “innodb_rollback_on_timeout” and how it affects the transaction behavior at the MySQL level. I describe two scenarios with practical tests, as it would be...
by Vadim Tkachenko | Jul 27, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MariaDB, MySQL
There were two new releases in the OpenSource Analytical Databases space, which made me want to evaluate how they perform in the Star Schema Benchmark. I covered Star Schema Benchmarks a few times before: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB...
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 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 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. ...
