MariaDB

Community-developed, commercially supported fork of MySQL.

Repair

If DB is running but a table is corrupt:

mysqlcheck -A | grep -v OK

If mysqlcheck does not work or DB does not start:

echo "innodb_force_recovery=1" >> /etc/mysql/my.cnf
service mysql start

Reorganizes the storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table.

OPTIMIZE TABLE `matomo_log_visit`;

Start:

START SLAVE;

Stop:

STOP SLAVE;

Status:

SHOW SLAVE STATUS \G

mysqldump --single-transaction $DB_NAME > dump.sql

--single-transaction: Sends a START TRANSACTION SQL statement to the server before dumping data. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when BEGIN was issued without blocking any applications.

List running sql queries:

show processlist;
SHOW FULL PROCESSLIST;

Delete all binary logs.

RESET MASTER;