Skip to content

Instantly share code, notes, and snippets.

View romach's full-sized avatar

Roman Cherepanov romach

View GitHub Profile

in /etc/ssh/sshd_config

# Change to no to disable tunnelled clear text passwords
#PasswordAuthentication no

Uncomment the second line, and, if needed, change yes to no.

Then run

service ssh restart

sudo lsof mysql-slow.log

First method

Delete log file:

rm mysql-slow.log

Flush logs on MySql server:

FLUSH LOGS;
docker pull centurylink/dockerfile-from-image
alias dfimage="docker run -v /var/run/docker.sock:/var/run/docker.sock --rm centurylink/dockerfile-from-image"
dfimage selenium/node-firefox-debug
lsb_release -a
npm install -g browser-sync
browser-sync start --server --files "*.*"
#create backup
backup_dir="/root/backup_test/"
innobackupex --host=localhost --socket=/var/run/mysqld/mysqld.sock --user=root --password=root --slave-info --extra-lsndir=${backup_dir} --stream=xbstream --compress ${backup_dir} | gzip > ${backup_dir}/backup_$(date +%Y%m%d%H%M%S)_full.xbstream.gz
### restore
datadir="/var/lib/mysql/"
gzip --keep --decompress /root/backup_test/backup_20180524190136_full.xbstream.gz
# clean up datadir
rm -rf ${datadir}/*
nginx -s reload
docker stats --format "table {{.ID}}\t{{.Name}}\t{{.CPUPerc}}\t{{.MemUsage}}"