设为首页 加入收藏

TOP

关于innodbpurgethread和masterthread
2015-11-21 01:46:23 来源: 作者: 【 】 浏览:0
Tags:关于 innodbpurgethread masterthread

由innodb_purge_threads控制purge线程数。

(>= 5.6.5)的版本中该值默认为1,最大值为32。默认值1表示innodb的purge操作被分离到purge线程中,master thread不再做purge操作。

The number of background threads devoted to the InnoDB purge operation. The new default and minimum value of 1 in MySQL 5.6.5 signifies that the purge operation is always performed by background threads, never as part of the master thread. Non-zero values runs the purge operation in one or more background threads, which can reduce internal contention within InnoDB, improving scalability. Increasing the value to greater than 1 creates that many separate purge threads, which can improve efficiency on systems where DML operations are performed on multiple tables. The maximum is 32.

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇mysql允许远程登录配置 下一篇mysql 提示 Writing to net

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: