mysql中常用操作使用的shell脚本

获取日志文件中最小日志号

[root@localhost ~]# mysqlbinlog /var/lib/mysql/bin-log.000005 | grep "end_log_pos" | awk '{print $7}' | sort -n | head -n1

249

获取日志文件中最大日志号

[root@localhost ~]# mysqlbinlog /var/lib/mysql/bin-log.000005 | grep "end_log_pos" | awk '{print $7}'| sort -n | tail -n1

1574

同时获取最小日志号和最大日志号

mysqlbinlog /var/lib/mysql/bin-log.000005 | grep "end_log_pos" | awk '{print $NF}' | awk 'BEGIN {min=2^63-1; max=0} {if($1<min) min=$1; if($1>max) max=$1} END {print "Minimum log_pos: " min "\nMaximum log_pos: " max}'

获取备份日志号

grep "^-- CHANGE MASTER TO" /tmp/backup_test_2021-01-26-02-20.sql|awk '{print $6}'|sed 's/MASTER_LOG_POS=//g'

获取所有日志文件

ls /var/lib/mysql | grep -E "^bin-log.[0-9]+"