工作中用到的命令
一些工作中用到的命令,用到方恨没记住,所以记录下
######MySQL############
#初始化mysql,即安装mysql系统表
scripts/mysql_install_db --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data --defaults-file=/opt/mysql/my.cnf
#查看binlog
/app/mysql/bin/mysqlbinlog -v --base64-output=DECODE-ROWS /app/mysql/log/mysql-bin.000020 |grep -A '10' 380002923
#mysql slave开启主从同步
change master to master_host='10.0.0.151',master_port=3306,master_user='replication',master_password='copy@Up360',master_log_file='mysql-bin.000539',master_log_pos=313118432;
#GTID模式下,开启mysql主从同步
change master to master_host='10.0.0.196', master_user='replication',master_password='copy@Up360',master_auto_position=1;
SET GLOBAL gtid_purged="c777888a-b6df-11e2-a604-080027635ef5:1-4"
#mysql主从复制 跳过复制错误
mysql>slave stop;
mysql> set GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
mysql>slave start;
#GTID模式下,跳过复制错误
mysql> STOP SLAVE;
Query OK, 0 rows affected (0.00 sec)
mysql> SET SESSION GTID_NEXT = ’7a07cd08-ac1b-11e2-9fcf-0010184e9e08:1131′;
Query OK, 0 rows affected (0.00 sec)
mysql> BEGIN; COMMIT;
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> SET SESSION GTID_NEXT = AUTOMATIC;
Query OK, 0 rows affected (0.00 sec)
mysql> START SLAVE;
#mysql 测试语句
./mysqlslap --concurrency=100,500,1000 --iterations=20 --number-int-cols=4 --number-char-cols=35 --auto-generate-sql /
--auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=wirte --engine=innodb --number-of-queries=1000 --verbose -h127.0.0.1 -P 3306 -uroot -p
mysqlslap --delimiter=";" --query="select * from up360_olclass.h_homework_english" --concurrency=50 --iterations=200
#主从数据对比
pt-table-checksum --no-check-binlog-format --no-check-replication-filters --recursion-method=processlist --replicate=test.checksums --databases=sakila --tables=film_actor -h 192.168.6.85 -P3306 -u checksums -p checksums
pt-table-checksum --nocheck-binlog-format --nocheck-plan --nocheck-replication-filters \
--replicate=pt.checksums --set-vars innodb_lock_wait_timeout=120 --databases up360_olclass --tables stat_u_english_rank -u'sysdba' -p'TR6GrXEd3g' -h 10.0.0.152
#####系统命令##传输文件或目录##########
scp -rpvC -i6000 -P627 ./20160405.zip root@10.0.0.152:/backup
scp -rpvC -i6000 -P627 /app/mysql/data/up360_olclass 10.0.0.196:/app/mysql/data/
scp -rpvC -i6000 -P627 /app/mysql/data/up360_user 10.0.0.196:/app/mysql/data/
scp -rpvC -i6000 -P627 /app/mysql/data/{eol,ibdata1,ibdata2,ib_logfile0,ib_logfile1,mysqlperformance_schema,up360_manage} 10.0.0.196:/app/mysql/data/
chmod -R mysql.mysql /app/mysql
#使用nc传输文件或目录(速度更快)
nc -l -p 12345 |tar zxvf -
tar czvf - /var/lib/myql/data |nc -q 1 server2 12345
#rsync
/usr/bin/rsync -vzrtopgSxP --timeout=600 --exclude-from=/home/mysql/exclude.list back@10.0.0.151::mysql_back --password-file=/etc/rsync.passwd /app/mysql/data
/usr/bin/rsync -vzrtopgSxP --timeout=600 --exclude-from=/home/mysql/exclude.list copy@192.168.18.52::mysql_back /app/mysql/data
# lz4+scp 传输大文件
#双方都要安装 yum install lz4
time tar -c pa.dump |pv|lz4 -B4|ssh root@123.207.254.57 "lz4 -d |tar -xC /opt/pa.dump"
#awk if 语句
tailf localhost_access_log.2016-09-18.txt |awk '{if($11>3){print $7,$11}}'
©著作权归作者所有:来自51CTO博客作者paniho的原创作品,如需转载,请注明出处,否则将追究法律责任