MySQL5.5的innodb_purge_threads怎么使用-创新互联
这篇文章主要讲解了“MySQL 5.5的innodb_purge_threads怎么使用”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“MySQL 5.5的innodb_purge_threads怎么使用”吧!
创新互联于2013年开始,是专业互联网技术服务公司,拥有项目网站设计、成都网站设计网站策划,项目实施与项目整合能力。我们以让每一个梦想脱颖而出为使命,1280元大理州做网站,已为上家服务,为大理州各地企业和个人服务,联系电话:18982081108在之前版本,碎片回收操作是主线程的一部分,这经定期调度的方式运行,但会阻塞数据库的其他操作;到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怎么使用这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是创新互联,小编将为大家推送更多相关知识点的文章,欢迎关注!
本文题目:MySQL5.5的innodb_purge_threads怎么使用-创新互联
网站地址:http://pwwzsj.com/article/cdeecg.html