mysqladmin ext -i1 | awk '/Queries/{q=$4-qp;qp=$4}/Threads_connected/{tc=$4}/Threads_running/{printf "%5d %5d %5d\n", q, tc, $4}'
awk '/^# Time:/{print $3, $4, c; c=0}/^# User/{c++}' slow.log
主库:
create user repl;
grant replication slave, replication client on *.* to repl@'192.168.237.%' identified by 'repl';
从库:
change master to master_host='192.168.237.129', master_user='repl', master_password='repl', master_log_file='mysql-bin.000001', master_log_pos=0;
start slave;
binlog分析:
mysqlbinlog --no-defaults --set-charset=utf8 mysql-bin.000001
mysqladmin create sbtest
sysbench --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password= \
--test=/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua --oltp_tables_count=2 --oltp-table-size=100000 --rand-init=on prepare