MySQL Archives - ASRblogger

Get the database size in MySQL

This article outlines the process of determining the size of a MySQL database and assessing the available free space within it. Determine the database size: Execute the following MySQL query…

asrblogger April 24, 2024No Comments

MySQL

How To Find Queries Taking Longer Than N Seconds in MYSQL ?

MySQL Server - Version 5.1 and later The simplest way to find long running queries are to look at the process list. There are various options how to do this…

asrblogger June 8, 2023No Comments

MySQL

MEB Backup & Restore in MySQL

MySQL Enterprise Backup provides enterprise-grade backup and recovery for MySQL. It delivers hot, online, non-blocking backups on multiple platforms including Linux, Windows, Mac & Solaris. MySQL supports the following backup…

asrblogger April 26, 2023No Comments

MySQL

MySQL HA DR Setup

/etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.10 mysql-prim.localdomain mysql-prim 192.168.56.11 mysql-dr.localdomain mysql-dr User to install and configure mysql: avs Install MySQL [avs@mysql-master ~]$ sudo dnf…