linux回炉第二十五天

reset master;
reset slave all;

半同步复制
主主复制
GTID

[mysqld]
read_only
super_read_only

select @@server_id;

set global general_log=ON;

MHA+Mycat

PXC

MGR

TiDB

mysqlslap -a -uroot -p123456
mysqlslap -a -c 100 -uroot -p123456
mysqlslap -a --concurrency=50,100 --number-of-queries 1000 --iterations=5 --engine=myisam,innodb --debug-info -uroot -p123456
mysqlslap -a --concurrency=50,100 --number-of-queries 1000 --iterations=5 --engine=myisam,innodb -uroot -p123456

last
lastb
last -x
dmesg
cat /var/lib/dmesg

journatctl