From /var/log/mariadb/mariadb.log, something like 1150515 12:10:45 InnoDB: Completed initialization of buffer pool 2150515 12:10:45 InnoDB: Fatal error: cannot allocate memory for the buffer pool 3150515 12:10:45 [ERROR] Plugin 'InnoDB' init function returned error. 4150515 12:10:45 [ERROR] Plugin …

Maximum number of table joins is 61 as per https://stackoverflow.com/questions/23389820/what-is-the-maximum-number-of-table-joins-in-mariadb Tested out as follows: 1CREATE TABLE t (i INT(10) NOT NULL); 2select * 3from t a01 join t a02 join t a03 join t a04 join t a05 join t a06 join t a07 join t a08 join t a09 join t …

Get replication status, and look for "Seconds_Behind_Master"

1mysql> show slave status\G;

1mysql> select distinct(TABLE_SCHEMA) from information_schema.tables; 2+--------------------+ 3| TABLE_SCHEMA | 4+--------------------+ 5| information_schema | 6| drcongo | 7| mysql | 8| performance_schema | 9| pseademo | 10| pseairaq | 11| sys | 12+--------------------+ 1314mysql> select count(*) from …

1mysql -s --skip-column-names -ne "use DB_to_Use; show tables;"

See https://serverfault.com/questions/42789/how-to-increase-memory-usage-in-mysql-server-to-improve-speed

1mysqldump -u<username> -p<password> --no-create-db myDB -h localhost > mysql.backup That way, it would strip the original database name and NOT become a problem when importing to another database name. See …

1root@rh:~# /usr/local/bin/automysqlbackup /etc/automysqlbackup/rh.conf 2Parsed config file "/etc/automysqlbackup/automysqlbackup.conf" 34grep: /home/icasimpan/.my.cnf: No such file or directory 5grep: /home/icasimpan/.my.cnf: No such file or directory 6# Checking for permissions to write to folders: 7base …

In a machine 'rh', tested automysqlbackup cron job if it would work and got the issue below: 1[root@rh icasimpan]# /usr/local/bin/automysqlbackup /etc/automysqlbackup/rh.conf 2Parsed config file "/etc/automysqlbackup/automysqlbackup.conf" 34# Checking for permissions to write to folders: 5base folder /var/lib …