Monica Silva
Database Administrator
Monica is a certified MySQL Database Administrator working with multiple clients to provide professional MySQL services. She is currently working towards her AWS Cloud Practitioner certification.
![Holland Backup Manager [ERROR] Insufficient Disk Space](https://virtual-dba.com/wp-content/uploads/Holland-Backup-Manager-_ERROR_-Insufficient-Disk-Space.jpg "Holland Backup Manager [ERROR] Insufficient Disk Space")
Holland Backup Manager [ERROR] Insufficient Disk Space
If you’re reading this blog, you know that Holland Backup Manager is an easy and efficient way to configure backups. Most of the issues I have experienced are user errors, specifically how I configured the backups. The following error is one such example:... read more
Getting MySQL User Info: Limitations and Possibilities
A client recently asked me if I could get the hostname or IP address of every server a MySQL user was using to connect for the past 30 days. I never thought of retrieving login information retrospectively. I wasn’t sure if I could. Spoiler alert: it is only... read more
Unused Indexes: Should They Stay or Should They Go
Unused indexes warrant an evaluation for several reasons. It can be a red flag that the MySQL Optimizer is not choosing to use the index, meaning that the index is not worth the effort to use. Additionally, unused indexes can take up valuable disk space. In MySQL... read more
Prevent Xtrabackup Failures for MySQL after Linux OS Patching
Patching the operating system is essential to keeping your server secure and performing optimally. Patching is as easy as running an apt-get update and apt-get upgrade. However, this can cause some unintended consequences. For one, MySQL server will also be upgraded... read more
Automating Log Rotation with Logrotate
Rotating MySQL logs is important because logs can take up a lot of disk space if left unmanaged. For example, an untuned database can lead to a lot of slow queries being logged. The error log can become large if it includes notes and warnings. Additionally, binlogs... read more