美文网首页
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