MySQL 5.5的innodb_purge_threads怎么使用

这篇文章主要讲解了“MySQL 5.5的innodb_purge_threads怎么使用”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“MySQL 5.5的innodb_purge_threads怎么使用”吧！

在之前版本，碎片回收操作是主线程的一部分，这经定期调度的方式运行，但会阻塞数据库的其他操作；

到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怎么使用”的内容了，经过本文的学习后，相信大家对MySQL 5.5的innodb_purge_threads怎么使用这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是，小编将为大家推送更多相关知识点的文章，欢迎关注！