mysql slave 线程 简书_MySQL从库提示： [Note] Multi-threaded slave statistics for channel '': seconds elapsed ...

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)