by Vasanthakumar | Feb 12, 2025 | KnowledgeBase, MySQL
XtraBackup is one of Percona’s primary backup offerings, and it is well-known among DBAs as one of the primary open-source utilities for performing hot backups. The tool is known to avoid locking databases during its backup procedures – of course, it has a...
by Vasanthakumar | Oct 9, 2024 | MySQL
Query optimization is a key feature in all databases. In this blog, I try to offer my own experiences with query optimization. This blog explains the methods for achieving query optimization in MySQL along with directions on how one can do it. Topics: 1....
