In /var/logs/newrelic 1[root@example.com newrelic]# grep -i newrelic.com newrelic-daemon.log 22019/01/21 06:09:53.115267 (12209) Info: Reporting to: https://rpm.newrelic.com/accounts/76083/applications/159251100 32019/01/21 06:37:43.147116 (12209) Info: Reporting to: …

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 …

In this example, we want to sync example.com except 'example.com/temp_uploads' 1rsync -avz --exclude 'example.com/temp_uploads' example.com /var/www_backups NOTE: exclude files are always relative to current directory. to exclude multiple directories, just use an additional '--exclude' statement. details in …

1rsync -avz -e "ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null" \ 2--progress /var/www/html/example.com/docroot me@example.org:/var/www/html/example.org/

1rsync -Pav -e "ssh -i $HOME/.ssh/somekey" username@hostname:/from/dir/ /to/dir/

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 …