{"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 \u5728\u5275\u898b SSD \u4e0a\u7684\u6e2c\u8a66","html":"<p>\u770b\u4e86 <a href=\"http:\/\/feedblog.org\/2008\/01\/30\/24-hours-with-an-ssd-and-mysql\/\">Kevin Burton \u7684\u6587\u7ae0 <\/a>, PIXNET \u6c7a\u5b9a\u627e\u76ee\u524d\u5e02\u5834\u4e0a\u8cb7\u7684\u5230\u7684 SSD \u4f86\u6e2c\u8a66\u8dd1 MySQL\uff0c\u5f8c\u4f86\u662f\u9032\u4e864\u9846 <a href=\"http:\/\/shop.transcend.com.tw\/product\/ItemDetail.asp?ItemID=TS32GSSD25-M\">\u5275\u898b32GB MLC SSD<\/a>\uff0c\u88dd\u5728 8-way\u300112G RAM \u7684 Debian Linux \u4e0a\uff0c\u8dd1 MySQL 5.1 Slave\uff0c\u7528 MyISAM \u7576 backend\u3002\u6700\u5927\u7684 MyISAM Table \u5927\u6982\u6709 3GB\u3002<\/p>  <p>\u4e00\u958b\u59cb\u6211\u5011\u7528 64KB stripe size \u8dd1 RAID0\uff0c\u4f46\u662f\u5c31\u5982 DK \u8aaa\u7684\u6158\u4e0d\u5fcd\u7779\uff0c\u7528 XFS \u6bcf\u79d2\u7684 replication qps \u5927\u6982\u5728 5~20 \u4e0a\u4e0b\u5f98\u5f8a\uff0c\u6539\u7528 EXT3 \u4e5f\u6c92\u6709\u9577\u9032\uff0c\u95dc\u6389 disk scheduler \u4e5f\u6c92\u7528\uff0c\u65bc\u662f\u6211\u5011\u8a66\u8457\u6539 stripe size \u5230 4KB\uff0c\u4e0d\u904e\u4e5f\u6c92\u6709\u986f\u8457\u589e\u52a0\uff0c\u5c0d\u55ae\u4e00\u5927 Table \u7684 qps \u9084\u662f\u53ea\u6709 5~20\uff0c\u4e0d\u904e\u82e5\u662f\u5c0d\u5c0f\u4e00\u9ede\u7684 Table \u5012\u662f\u53ef\u4ee5\u5230 300 \u5de6\u53f3\u3002\u5f8c\u4f86\u6211\u5011\u60f3\u7e7c\u7e8c\u964d\u4f4e stripe size\uff0c\u4f46\u767c\u73fe\u4e0d\u7ba1\u662f LVM \u9084\u662f md(4) \u90fd\u53ea\u652f\u63f4\u6700\u4f4e 4KB\u3002<\/p>  <p>\u6700\u5f8c\u767c\u73fe\uff0c\u9019\u9846\u5275\u898b SSD \u53ea\u652f\u63f4\u5230 UDMA Mode 4\uff0c\u800c\u4e14<a href=\"http:\/\/www.transcend.com.tw\/support\/dlcenter\/datasheet\/SSD25%20Datasheet%20v1.04.pdf\">\u898f\u683c<\/a>\u88e1\u9762\u5beb random write \u53ea\u6709\u5927\u6982 1.6MB\/s\uff0c\u4f46\u662f\u5e73\u5e38\u6211\u5011\u7684 replication write \u5c31\u5927\u6982\u8981 3MB\/s\uff0cpeak \u5230 11MB\/s\uff08XFS\uff09\uff0c\u800c\u5275\u898b SLC \u7684 SSD \u5927\u6982\u4e5f\u53ea\u652f\u63f4\u5230 4MB\/s\uff0c\u9084\u662f\u592a\u6162\u3002<\/p>  <p>\u7d50\u8ad6\uff1a\u53f0\u7063\u5e02\u5834\u4e0a\u76ee\u524d\u7684 SSD \u6548\u80fd\u9084\u4e0d\u5920\u597d\uff0c\u800c\u570b\u5916\u7684 Mtron \u9084\u592a\u8cb4\uff0cC\/P\u503c\u4e0d\u5920\u597d\uff0c\u5169\u9846 32G \u5c31\u53ef\u4ee5\u591a\u52a0\u4e00\u53f0\u6a5f\u5668\u4e86\u3002<\/p>","type":"rich"}