在之前版本,碎片回收操作是主线程的一部分,这经定期调度的方式运行,但会阻塞数据库的其他操作;[@more@]到5.5以后,可以将这个线程独立出来 ;方法:innodb_purge_threads =1
这个应该能让碎片回收得更及时而且不影响其他线程的操作;
Improved Purge Scheduling
- The InnoDB purge operation is a type of garbage collection that runs
periodically. In previous versions, the purge was part of the master thread, meaning that it could
block other database operations when running. In MySQL 5.5 this operation can run in its own
thread, allowing for more concurrency. Users can control whether the purge operation is split into its
own thread with the innodb_purge_threads configuration option, which can be set to 0 (the
default) or 1 (for a single separate purge thread).
MySQL 5.5 -- innodb_purge_threads
原创
©著作权归作者所有:来自51CTO博客作者小叔叔书的原创作品,请联系作者获取转载授权,否则将追究法律责任
上一篇:Centos7.5 mysql5.7.26二进制安装方式
下一篇:How to solve mysql warning: “InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings mi
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
innodb purge操作
Purge搜集的几个感觉不错的文章一、http://
mysql 主键 回滚 -
【原创】MySQL 5.5 的COMPRESSED INNODB 表
COMPRESSED INNODB ENGINE NOTE.
MYSQL INNODB COMPRESSED 5.5