Pep Pla, Author at Percona Database Performance Blog Wed, 06 Sep 2023 20:43:23 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png Pep Pla, Author at Percona Database Performance Blog 32 32 76301791 The Impacts of Fragmentation in MySQL https://www.percona.com/blog/the-impacts-of-fragmentation-in-mysql/ https://www.percona.com/blog/the-impacts-of-fragmentation-in-mysql/#respond Wed, 05 Jul 2023 13:14:06 +0000 https://www.percona.com/blog/?p=89186 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 separate or […]]]> https://www.percona.com/blog/the-impacts-of-fragmentation-in-mysql/feed/ 0 89186 Raspberry on the Rocks: Build Percona Server for MySQL With MyRocks on Your Raspberry Pi https://www.percona.com/blog/raspberry-on-the-rocks-build-percona-server-for-mysql-with-myrocks-on-your-raspberry-pi/ https://www.percona.com/blog/raspberry-on-the-rocks-build-percona-server-for-mysql-with-myrocks-on-your-raspberry-pi/#respond Thu, 03 Nov 2022 12:10:26 +0000 https://www.percona.com/blog/?p=83420 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 […]]]> https://www.percona.com/blog/raspberry-on-the-rocks-build-percona-server-for-mysql-with-myrocks-on-your-raspberry-pi/feed/ 0 83420 Percona Monitoring and Management 2 Test Drive Using VirtualBox and SSH Tunnels https://www.percona.com/blog/percona-monitoring-and-management-2-test-drive-using-virtualbox-and-ssh-tunnels/ https://www.percona.com/blog/percona-monitoring-and-management-2-test-drive-using-virtualbox-and-ssh-tunnels/#respond Thu, 30 Dec 2021 13:01:45 +0000 https://www.percona.com/blog/?p=79462 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 will […]]]> https://www.percona.com/blog/percona-monitoring-and-management-2-test-drive-using-virtualbox-and-ssh-tunnels/feed/ 0 79462 Percona XtraBackup for Windows https://www.percona.com/blog/percona-xtrabackup-for-windows/ https://www.percona.com/blog/percona-xtrabackup-for-windows/#comments Fri, 25 Jun 2021 12:48:21 +0000 https://www.percona.com/blog/?p=76919 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 to entice […]]]> https://www.percona.com/blog/percona-xtrabackup-for-windows/feed/ 1 76919 The MySQL Clone Wars: Plugin vs. Percona XtraBackup https://www.percona.com/blog/the-mysql-clone-wars-plugin-vs-percona-xtrabackup/ https://www.percona.com/blog/the-mysql-clone-wars-plugin-vs-percona-xtrabackup/#comments Tue, 19 Jan 2021 17:20:55 +0000 https://www.percona.com/blog/?p=73732 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 to […]]]> https://www.percona.com/blog/the-mysql-clone-wars-plugin-vs-percona-xtrabackup/feed/ 6 73732