As a Sysadmin we often require backing up several databases to meet the SLA or system requirements. Sometimes we need…
The MySQL Federated storage engine for the MySQL relational database management system is a storage engine which allows a user…
Before enabling a new engine, check for already installed engines. To do so login in to mysql and execute following…
To Reset any Mysql Database you need to perform following operations Stop the MySQL server Locate my.cnf and add following…
List Size of all Mysql Database SELECT table_schema AS “Database”, ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS “Size…