ITPub博客

首页 > 数据库 > MySQL > MySQL 5.5 -- innodb_purge_threads

MySQL 5.5 -- innodb_purge_threads

原创 MySQL 作者:Steven1981 时间:2010-12-22 15:22:09 0 删除 编辑
在之前版本,碎片回收操作是主线程的一部分,这经定期调度的方式运行,但会阻塞数据库的其他操作;[@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).

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/703656/viewspace-1043463/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    127
  • 访问量
    837867