多线程复制之最佳实践-亲试ok-20201020
目前只运行了一个 sql线程
mysql> show processlist;
+----+-------------+-----------+------+---------+---------+--------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------------+-----------+------+---------+---------+--------------------------------------------------------+------------------+
| 23 | system user | | NULL | Connect | 4143722 | Waiting for master to send event | NULL |
| 24 | system user | | NULL | Connect | 252 | Slave has read all relay log; waiting for more updates | NULL |
| 37 | root | localhost | NULL | Query | 0 | starting | show processlist |
+----+-------------+-----------+------+---------+---------+--------------------------------------------------------+------------------+
3 rows in set (0.00 sec)
#停止slave
mysql> stop slave;
Query OK, 0 rows affected, 1 warning (0.00 sec)
#目前默认的并发参数
mysql> show variables like 'slave_parallel_type';
+---------------------+----------+
| Variable_name | Value |
+---------------------+----------+
| slave_parallel_type | DATABASE |
+---------------------+----------+
1 row in set (0.00 sec)
mysql> set global slave_parallel_type='logical_clock';
Query OK, 0 rows affected (0.00 sec)
mysql> set global slave_parallel_workers=4;
Query OK, 0 rows affected (0.00 sec)
mysql> show processlist ;
+----+-------------+-----------+------+---------+------+--------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------------+-----------+------+---------+------+--------------------------------------------------------+------------------+
| 37 | root | localhost | NULL | Query | 0 | starting | show processlist |
| 38 | system user | | NULL | Connect | 31 | Waiting for master to send event | NULL |
| 39 | system user | | NULL | Connect | 30 | Slave has read all relay log; waiting for more updates | NULL |
| 40 | system user | | NULL | Connect | 31 | Waiting for an event from Coordinator | NULL |
| 41 | system user | | NULL | Connect | 31 | Waiting for an event from Coordinator | NULL |
| 42 | system user | | NULL | Connect | 31 | Waiting for an event from Coordinator | NULL |
| 43 | system user | | NULL | Connect | 31 | Waiting for an event from Coordinator | NULL |
+----+-------------+-----------+------+---------+------+--------------------------------------------------------+------------------+
7 rows in set (0.00 sec)
创建时间：2021-12-22 09:25
넶浏览量：0
