{"version":"1.0","provider_name":"Jui-Nan Lin&#039;s Blog","provider_url":"https:\/\/jnlin.org","author_name":"jnlin","author_url":"https:\/\/jnlin.org\/author\/jnlin\/","title":"MySQL \u7684 Thread Pool (Percona \u7248\u672c) \u5be6\u6e2c","html":"MySQL Thread Pool \u7684\u4ecb\u7d39\u53ef\u4ee5\u53c3\u8003 Percona \u7684\u6587\u7ae0\uff1a<a href=\"http:\/\/www.mysqlperformanceblog.com\/2014\/01\/23\/percona-server-improve-scalability-percona-thread-pool\/\"><\/a>\uff0c\u4ee5\u53ca DK \u7684\u4ecb\u7d39\uff1a<a href=\"http:\/\/blog.gslin.org\/archives\/2014\/01\/25\/4181\/mysql-%E4%B8%8A%E7%9A%84-thread-pool\/\">MySQL \u4e0a\u7684 Thread Pool\u2026<\/a>\r\n\r\n\u4e00\u8a00\u4ee5\u853d\u4e4b\uff1a\u8cc7\u6e90\u4f7f\u7528\u91cf\u6709\u6e1b\u5c11\uff0c\u4f46\u770b\u4e0d\u51fa\u660e\u986f\u7684\u6548\u80fd\u6539\u5584\uff0c\u53ef\u80fd\u662f\u8ca0\u8f09\u9084\u4e0d\u5920\u5927\u3002\r\n\r\nMySQL Thread \u6578\u91cf\uff08\u958b\u555f Thread Pool \u524d\uff09\uff1a\r\n<a href=\"http:\/\/jnlin.pixnet.net\/album\/photo\/148024071-mysql_threads-month-old.png\"><img src=\"\/\/ext.pimg.tw\/jnlin\/1391596149-4056505462.png\"\/><\/a>\r\n\r\nMySQL Thread \u6578\u91cf\uff08\u958b\u555f Thread Pool \u5f8c\uff09\uff1a\r\n<a href=\"http:\/\/jnlin.pixnet.net\/album\/photo\/148024065-mysql_threads-month-new.png\"><img src=\"\/\/ext.pimg.tw\/jnlin\/1391596149-4205786559.png\"\/><\/a>\r\n\r\nSystem Thread \u6578\u91cf\uff08\u958b\u555f Thread Pool \u524d\uff09\uff1a\r\n<a href=\"http:\/\/jnlin.pixnet.net\/album\/photo\/148024074-threads-month-old.png\"><img src=\"\/\/ext.pimg.tw\/jnlin\/1391596150-2100488873.png\"\/><\/a>\r\n\r\nSystem Thread \u6578\u91cf\uff08\u958b\u555f Thread Pool \u5f8c\uff09\uff1a\r\n<a href=\"http:\/\/jnlin.pixnet.net\/album\/photo\/148024068-threads-month-new.png\"><img src=\"\/\/ext.pimg.tw\/jnlin\/1391596150-2691326413.png\"\/><\/a>\r\n\r\n\u53ef\u4ee5\u770b\u5230\u5728\u540c\u6a23\u7d04 2000 \u500b MySQL Thread \u7684\u60c5\u6cc1\u4e0b\uff0c\u958b\u555f Thread Pool \u7684 System Thread \u6578\u91cf\u53ea\u6709\u7d04 200 \u500b\uff1b\u958b\u555f\u524d\u7d04\u9700\u8981 3000 \u500b Thread\u3002\u5169\u5f35\u5716\u662f\u4f7f\u7528\u914d\u5099\u5b8c\u5168\u76f8\u540c\u7684\u5169\u53f0\u6a5f\u5668\u6e2c\u8a66\u7684\u3002","type":"rich"}