{"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 SSD \u7684\u6e2c\u8a66\u4e4b\u4e00","html":"<p>\u6700\u8fd1 <a href=\"http:\/\/www.pixnet.net\/\">PIXNET<\/a> \u6e2c\u8a66\u4e86\u53e6\u5916\u4e09\u6b3e SSD\uff08<a href=\"http:\/\/www.mtron.net\/English\/Product\/pc_msd3000.asp\">Mtron 3000<\/a>\u3001<a href=\"http:\/\/www.mtron.net\/English\/Product\/pc_msd1000.asp\">Mtron 1000<\/a>\u3001<a href=\"http:\/\/www.memoright.com\/en\/showpro.asp?id=236&amp;lb=5&amp;action=pptt2\">MemoRight MR25.2-032<\/a>\uff09\u8dd1 MySQL \u7684\u6548\u80fd\uff0c\u4e26\u4e14\u8ddf <a href=\"http:\/\/www.mtron.net\/English\/Product\/ec_msp7000.asp\">Mtron 7000<\/a> \u7cfb\u5217\u505a\u4e86\u6bd4\u8f03\u3002\u4e4b\u524d\u6e2c\u8a66\u7684 Mtron 7000 \u7cfb\u5217\u8cc7\u6599\u53ef\u4ee5\u5728<a href=\"http:\/\/jnlin.org\/2008\/05\/07\/290\/\">\u9019\u88e1<\/a>\u8207<a href=\"http:\/\/jnlin.org\/2008\/04\/12\/279\/\">\u9019\u88e1<\/a>\u627e\u5230\u3002<\/p> <p>\u4ee5\u4e0b\u7684\u6e2c\u8a66\u74b0\u5883\uff0c\u9664\u4e86 Mtron 1000 \u7cfb\u5217\u662f\u4f7f\u7528 Intel E5410 \u7684 CPU \u4ee5\u5916\uff0c\u5176\u4ed6\u7684\u74b0\u5883\u90fd\u662f 8-way E5450 CPU\u300112G RAM \u7684 Debian Linux\uff0c\u8dd1 MySQL 5.1 Slave\uff0c\u7528 MyISAM \u7576 backend\u3002\u6700\u5927\u7684 MyISAM Table \u5927\u6982\u6709 3GB\u3002<\/p> <ul> <li><u>Mtron 3000 \u7cfb\u5217<\/u>\uff1a\u5be6\u969b\u4f7f\u7528\u7684\u6642\u5019\uff0c\u611f\u89ba\u7684\u51fa\u4f86\u4e0a\u8ddf Mtron 7000 \u7cfb\u5217\u6709\u5dee\u3002\u5728\u6e2c\u8a66\u74b0\u5883\u4e2d\uff0c\u5c0d\u8b80\u53d6\u4f86\u8aaa\uff0c\u5230 CPU Bound \u7684\u6642\u5019\uff0cIO \u5927\u6982\u4f7f\u7528\u4e86 70%\u3002\u5e73\u5747 MySQL \u7684 QPS (Query Per Second)\u7d04 5000~6000\u3002\u5c0d\u5927\u91cf\u7684\u5beb\u5165\uff08\u540c\u6642\u4e5f\u6709\u8b80\u53d6\uff09\u4f86\u8aaa\uff0c\u5373\u4f7f\u6c92\u5230 CPU Bound\uff08\u5927\u6982 \u5728 3000 qps\uff09\uff0cIO \u6703\u6eff\u8f09\u3002<\/li> <li><u>Mtron 1000 \u7cfb\u5217<\/u>\uff1a\u9700\u8981 slow start\u3002\u4f7f\u7528\u4e0a\u7684\u611f\u89ba\u8ddf SCSI 15krpm \u5169\u9846\u786c\u789f\u4f5c\u6210\u7684 RAID 0 \u5dee\u4e0d\u591a\uff0c\u8b80\u53d6\u6bd4 SCSI \u786c\u789f\u5feb\uff0c\u4f46\u662f\u5beb\u5165\u6bd4\u8f03\u6162\u3002\u5728\u6e2c\u8a66\u74b0\u5883\u4e2d\uff0c\u5230 IO Bound \u7684\u6642\u5019\u5927\u7d04\u53ef\u4ee5\u9054\u5230 4000 qps\u3002<\/li> <li><u>MemoRight MR25.2-032<\/u>\uff1a\u5728\u6e2c\u8a66\u74b0\u5883\u4e2d\uff0c\u5230 CPU bound \u6642\uff0cIO usage \u7d04 45%\uff0c\u5e73\u5747 QPS \u5927\u7d04 6000 \u4e0a\u4e0b\u3002iostat \u88e1\u9762\u986f\u793a\u7684 iowait% \u6bd4\u8f03\u9ad8\uff0c\u5927\u7d04\u662f 6%\uff0c\u800c Mtron \u5927\u6982 1%\u3002\u540c\u6642\u6709\u8b80\u53d6\u8207\u5beb\u5165\u7684\u6642\u5019\uff0cMemoright \u7684\u8b80\u53d6\u6bd4 Mtron \u5dee\u3002\u7576 Mtron 7000 \u8ddf 3000 \u7684 IO Usage \u662f 10 % \u7684\u6642\u5019\uff0cMemoright \u7684 IO usage \u5927\u6982 35%\u3002\u9047\u5230\u5c0d\u5927\u91cf\u7684\u5beb\u5165\uff08\u540c\u6642\u4e5f\u6709\u8b80\u53d6\uff09\u4f86\u8aaa\uff0c<br \/>Memoright \u7684 IO usage \u5927\u6982 90%\uff0cMtron 3000 \u5927\u6982 100 %\uff0cMtron 7000 \u5927\u6982 50%\u3002<\/li><\/ul> <p>\u76ee\u524d\u6211\u5011\u6b63\u5728\u60f3\u8fa6\u6cd5\u53d6\u5f97 STEC \u8207 Ritek \u7684 SSD \u4f86\u6e2c\u8a66\uff0c\u5982\u679c\u6709\u63a8\u85a6\u7684\u5ee0\u5546\u4e5f\u6b61\u8fce\u7559\u8a00\u3002<\/p>","type":"rich"}