Jul 03, 2025 |
Insight for DBAs, MySQL, PostgreSQL
Welcome to this first installment of the blog series, which explores how PostgreSQL and MySQL deal with different aspects of relational databases. This post is about how to handle torn pages. As a long-time open source database administrator, I have always been fascinated by the differences in how these two databases handle various challenges and […]
Jul 05, 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 InnoDB. What is fragmentation? We say that something is fragmented when it is formed by parts that are […]
Nov 03, 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 to collect data in remote locations or from sensor devices. We […]
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 the security of your business-critical database environments, no matter where they are located or deployed. This blog post […]
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 defines clickbait as text (or a link) that is designed to attract attention and […]
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 box. It is easy to rebuild a replica or to add new nodes […]