{"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 on Mtron SSD \u4e4b\u4e8c","html":"<p>\u6211\u5011\u628a E5410 \u63db\u6210 E5450 \u518d\u505a\u4e86\u4e00\u6b21\u6e2c\u8a66\uff0c\u767c\u73fe\u9019\u6b21\u9084\u662f\u5361\u5728 CPU Bound\uff0c\u4f46\u662f\u6bd4\u8d77 E5410 \u4f86\u8aaa\u6709\u6548\u80fd\u4e0a\u7684\u6539\u9032\uff08\u540c\u6a23\u662f\u5be6\u969b\u4e0a\u7dda\uff0cE5410 \u7684 qps \u6975\u9650\u662f 8000\uff0c\u5e73\u5747\u662f 4000 \u5de6\u53f3\uff1bE5450 \u6975\u9650\u4e5f\u662f 8000\uff0c\u4f46\u662f\u5e73\u5747\u53ef\u4ee5\u5230 5000\uff09\u3002\u63a5\u8457\u6211\u5011\u8abf\u6574\u4e86 thread_concurrency \u8207 thread_cache_size \u4e4b\u5f8c\uff0c\u5e73\u5747 qps \u53ef\u4ee5\u5230 6000\u3002<\/p> <p>\u53e6\u5916\uff0c\u9019\u6b21\u767c\u73fe\u5927\u6982\u6709 40% \u7684 CPU Time \u88ab system \u5403\u6389\u4e86\u3002\u6709\u6c92\u6709\u5c0d Linux \u6bd4\u8f03\u719f\u7684\u9577\u8f29\u53ef\u4ee5\u6559\u4e00\u4e0b\u600e\u9ebc\u770b\u9019\u4e9b CPU \u662f\u88ab\u7528\u5230\u54ea\u88e1\u53bb\u4e86\uff1f<\/p>","type":"rich"}