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 to showcase the database name and its size in megabytes: Determine the amount of available space: Execute the subsequent query to observe the available free … Read more
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 depending on your version and whether you have the Sys Schema installed. The Sys Schema session View In MySQL 5.6 or later with the Sys … Read more
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 types: Logical backup Logical backup outputs a database structure in a .sql file by generating the CREATE or INSERT statements. Later, this file can be … Read more
/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 Configure MySQL master node mysql.conf Change binlog and data dir Startup with default setup and then we will proceed to change data and bin logdirectory: 1. Start mysql (both … Read more