by Yura Sorokin | Mar 24, 2023 | Insight for DBAs, Insight for Developers, MySQL
In MySQL Server 8.0.32, Oracle fixed Bug #105761:“mysqldump make a non-consistent backup with ‐‐single-transaction option” (this commit)which caused a wave of complaints from users who could no longer do backups with the mysqldump utility... by Yura Sorokin | Aug 10, 2022 | Insight for DBAs, MySQL, Percona Software, Storage Engine
In Percona Server for MySQL 8.0.29-21, we added one more patch that helps us to build server code on macOS. To be precise here, we still could do this even before this patch but only partially. Now it is possible to build RocksDB Storage Engine as well.A word of... by Yura Sorokin | Jun 30, 2022 | Insight for DBAs, MySQL, Percona Software, Security
Imagine you need to design an online system for storing documents on a per-user basis where nobody, including database administrators, would be able to change the content of those documents without being noticed by document owners.In Percona Server for MySQL... 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...