MySQL从库提示： [Note] Multi-threaded
2020-12-11 本文已影响0人
frankie_cheung
mysql> show variables like '%pending%';
+-----------------------------+----------+
| Variable_name | Value |
+-----------------------------+----------+
| slave_pending_jobs_size_max | 16777216 |
+-----------------------------+----------+
1 row in set (0.00 sec)
mysql> set global slave_pending_jobs_size_max=16777216*3;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%pending%';
+-----------------------------+----------+
| Variable_name | Value |
+-----------------------------+----------+
| slave_pending_jobs_size_max | 50331648 |
+-----------------------------+----------+
1 row in set (0.00 sec)
