SQL 精编（6）

time mysqldump -u root -p  fake_xx > fake_xx.sql
time mysqldump -u root -p  tab_xx conversations > /tmp/conversations.backup.sql

/usr/bin/mysqladmin flush-logs ; /etc/init.d/filebeat restart
mysqladmin flush-hosts -h localhost -P 3306 -u root -p
mysqladmin -u root -pPASSWORD flush-hosts flush-tables flush-threads flush-logs flush-privileges flush-status

mysqlslap --no-defaults --debug-info -uroot -p  --number-int-cols=5 --number-char-cols=10 --auto-generate-sql --auto-generate-sql-add-autoincrement --concurrency=100 --number-of-queries=10000 --iterations=3 --engine=innodb

mysqlslap --no-defaults --debug-info -uroot -p  --number-int-cols=5 --number-char-cols=10 --auto-generate-sql --auto-generate-sql-add-autoincrement --concurrency=100 --number-of-queries=10000 --iterations=10 --engine=innodb

mysqlslap --concurrency=100 --iterations=1 --create-schema='test' --query='select * from test;' --number-of-queries=10 --debug-info -uroot  -p

purge_relay_logs --user=root --password=xxxxx --workdir=/data/relay_log_dir/  

#only sp master
pt-table-checksum --nocheck-replication-filters --replicate=pt.checksums h=h102,u=test,p=test,P=3307

pt-table-checksum --nocheck-replication-filters  --nocheck-binlog-format --replicate=pt.check  h=192.168.100.201,u=test,p=test 

#only sp slave

pt-table-sync --replicate pt.checksums   h=192.168.100.202,u=test,p='test'    --sync-to-master --databases=test   --tables=t2 --print

pt-table-sync --replicate pt.checksums   h=192.168.100.202,u=test,p='test'    --sync-to-master --databases=test   --tables=t1 --print

pt-table-sync --replicate pt.checksums   h=192.168.100.202,u=test,p='test'    --sync-to-master --databases=test   --tables=t1 --execute

./mysqltuner.pl --forcemem 48288 --forceswap 4094

time nohup pt-archiver  --source h=localhost,P=3306,D=xxx,t=xxxtable,u=root,p=xxxxx --dest h=test-target,P=3306,u=root,p=xxxx,D=xpd,t=user_logins  --no-check-charset  --where 'id >= 1 '  --progress 5000  --no-delete --limit=10000 --statistics >> archive.log  2>&1 &
time nohup pt-archiver  --source h=localhost,P=3306,D=xpd,t=checkins,u=root,p=xxxx --dest h=test-target,P=3306,u=root,p=xxxx,D=xxxdb,t=xxxtable  --no-check-charset  --where '1=1 '  --progress 10000  --no-delete --limit=10000 --statistics >> archive_checkins.log  2>&1 &