by Pep Pla | Jul 5, 2023 | Insight for DBAs, Insight for Developers, MySQL
Fragmentation is a common concern in some database systems. Highly fragmented tables can affect performance and resource allocation. But reducing fragmentation often involves rebuilding the table completely. This blog post will discuss fragmentation and its impact on... by Pep Pla | Nov 3, 2022 | Hardware and Storage, Insight for DBAs, MySQL, Open Source
Raspberry PI is a small single-board computer (SBCs) developed by the Raspberry Pi Foundation in association with Broadcom. This tiny computer is extremely popular and widely used in many areas. Thanks to its size, low cost, and low energy requirements, it can be used... by Pep Pla | Dec 30, 2021 | MongoDB, Monitoring, MySQL, Percona Software
Percona Monitoring and Management 2 (PMM2) is the database monitoring suite assembled and developed by Percona. It is based on standard open source components and custom-made software integrations. PMM2 helps you reduce complexity, optimize performance, and improve... by Pep Pla | Jun 25, 2021 | Insight for DBAs, MySQL, Percona Software
Don’t Try This at Home! Disclaimer: The procedure described in this blog post is not officially supported by Percona XtraBackup. Use it under your responsibility. I tested and used it successfully, but your mileage may vary.Note from the author: Wikipedia... by Pep Pla | Jan 19, 2021 | Benchmarks, Insight for DBAs, MySQL, Percona Software
Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a replica from another server.The Clone Plugin, available since MySQL 8.0.17, is a great feature that allows cloning databases out of the...