美文网首页
MySQL从库提示: [Note] Multi-threaded

MySQL从库提示: [Note] Multi-threaded

作者: frankie_cheung | 来源:发表于2020-12-11 10:34 被阅读0次

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)

相关文章

网友评论

      本文标题:MySQL从库提示: [Note] Multi-threaded

      本文链接:https://www.haomeiwen.com/subject/vcfjgktx.html