{"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 Mtron SSD \u4e0a\u7684\u6e2c\u8a66","html":"<p>\u9019\u6b21<a href=\"http:\/\/www.pixnet.net\/\">PIXNET<\/a>\u9032\u4e862\u9846 32G Mtron <a href=\"http:\/\/www.mtron.net\/English\/Product\/ProductDetail.asp?itemcode=MSP-SATA7035\">MSP-SATA70<\/a>\uff08Spec \u4e0a\u5beb\u7684\u5beb\u5165\u901f\u5ea6\u70ba 90MB\/s\uff0c\u8b80\u53d6\u901f\u5ea6\u70ba 120MB\/s\uff09\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>\u9019\u6b21\u4e00\u958b\u59cb\u5c31\u63a1\u7528 RAID 0, 4KB stripe size + XFS (4 KB Data Size) + noop disk scheduler\u3002\u6e2c\u8a66\u958b\u59cb\u6642\uff0c\u5f9eDB Master\u8907\u88fd\u8cc7\u6599\u6240\u9700\u7684\u6642\u9593\uff0c\u5927\u6982\u662f\u5169\u9846 SCSI 10k RPM + XFS \u7684 1\/3\uff0c\u7d04 70MB\/s\u3002\u63a5\u8457 replication qps \u5927\u6982\u5728 3000-4000 \u5de6\u53f3\u5f98\u5f8a\uff0c\u6700\u9ad8\u5927\u7d04\u662f 15000 qps\u3002  <\/p><p>\u5be6\u969b\u4f7f\u7528\u4e0a\uff08\u540c\u6642\u6709 SELECT \u8207 UPDATE\uff09\uff0c\u5927\u6982 8000 qps \u662f\u6975\u9650\uff0c\u63a5\u8457\u5c31\u6703\u9047\u5230 CPU Bound\uff0c\u5c0d\u65bc\u8f03\u8907\u96dc\u7684 SQL Query \uff08SELECT ... IF EXISTS\uff09\u6703\u958b\u59cb\u5361\u3002\u5982\u679c\u53ea\u8a08\u7b97\u55ae\u7d14\u7684 SELECT QUERY\uff0c\u5247\u53ef\u4ee5\u5230\u7d04 15000 qps\u3002<\/p>","type":"rich"}