by Sri Sakthivel | Aug 7, 2020 | Insight for DBAs, Insight for Developers, MySQL
Rewriting a MySQL query for performance is an important process that every DBA should be aware of so they can fix the wrong queries on runtime without code changes on the application end. ProxySQL has great support for rewriting the queries, which Alkin Tezuysal...
by Matt Yonkovit | Aug 5, 2020 | Database Trends, Insight for DBAs, Security
How many times have we seen this headline lately: “X million records leaked in data breach”? The answer is, too many! In fact, because “millions of records” are starting to leak so frequently, larger news outlets are not covering the “smaller” leaks as often as they...
by Agustín | Aug 4, 2020 | Cloud, Insight for DBAs, Monitoring, Percona Software
In this blog, we are going to see how to compile a Percona Monitoring and Management 2 (PMM v2) client in ARM. For this, we are going to use an AWS EC2 ARM instance with Amazon Linux 2. Installing Dependencies First, let’s get some basic packages out of the way,...
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 Lalit Choudhary | Jul 29, 2020 | Insight for DBAs, Insight for Developers, Percona Software
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build not only the best open-source database products but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source...
by Ibrar Ahmed | Jul 28, 2020 | Insight for DBAs, Insight for Developers, PostgreSQL
The PostgreSQL 13 Beta is out in the testing phase with a rich feature set. It is a very good learning effort to participate in the testing of one of the finest databases in the world. It does not matter how much development, coding, and administration experience you...
by Vadim Tkachenko | Jul 28, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Continuing with the checkpointing topic I started a month ago with my blog post MongoDB Checkpointing Woes, this time I want to review how PostgreSQL performs in this area. After this, I will be taking a look at MySQL and MariaDB. If anything, it will be fair not only...
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 Corrado Pandiani | Jul 24, 2020 | Insight for DBAs, Insight for Developers, MongoDB
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 Rachel Pescador | Jul 22, 2020 | Database Trends, Insight for DBAs, MongoDB
Many of us use and love relational databases… until we try and use them for purposes that aren’t their strong point. Queues, caches, catalogs, unstructured data, counters, and many other use cases, can be solved with relational databases, but are better served by...
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 Michal Nosek | Jul 20, 2020 | Insight for DBAs, MongoDB, Percona Software
Every database environment should require a robust backup strategy as its a fundamental requirement to running a successful and robust database. No matter the size of the database, the function of the application, or how technologically advanced a company is, backups...
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 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 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 Steve Hoffman | Jul 7, 2020 | Insight for DBAs, Monitoring, Percona Software
Many years ago I was banned from touching anything of critical importance as far as production infrastructure goes…something about “the leadership curse”, so the multiple layers of monitoring and notifications I once wrestled with were now overkill for my needs....
