HandlerSocket on SSD
We all enjoyed Yoshinori announcement of HandlerSocket, the plugin to MySQL which open NOSQL way to access data stored in InnoDB. The published results are impressive, but I want to understand some, that’s why I run couple more experiments. In blog post Yoshinori used the case when all data fits into memory, and one of question I had what if we put data on SSD ( FusionIO 320GB MLC in this experime
SSDã¨TokyoTyrantã‚„MySQLã®æ€§èƒ½æ¤œè¨¼
2. 2 経緯 • 今後ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—リ開発ã§SSDã‚„ TokyoTyrantãªã©ã‚’使ã„ãŸã„ • メーカーã•ã‚“ã®ãŠã‹ã’ã§ã€SSDæ載サーãƒã® 評価機を2週間借りられるã“ã¨ã«ãªã£ãŸ • 是éžæ¤œè¨¼ã—ãŸã„ï¼ 3. 3 目的 • SSDæ載サーãƒã¯30万円ãらã„プラスã«ãªã‚‹ ã®ã§ã€è²»ç”¨å¯¾åŠ¹æžœã‚’知りãŸã„ • SSDã¨HDDã®æ€§èƒ½ã‚„特徴ã«ã¤ã„ã¦èª¿æŸ»ã™ã‚‹ • 特ã«ã€TokyoTyrantãªã©ã®ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã¨ã®ç›¸ 性ã«ã¤ã„ã¦èª¿æŸ»ã™ã‚‹ 4. 4 サーãƒã‚¹ãƒšãƒƒã‚¯ãƒ»æ¤œè¨¼ç’°å¢ƒ • サーãƒã‚¹ãƒšãƒƒã‚¯ – CPU: 「Xeon E5502 @ 1.87GHz〠×２(Dual)×２ – DISK • SSD RAID1 46GB （OSã€ãƒã‚°ç‰ç”¨ï¼‰ • SSD RAID1 46GB （データ用） • HDD(10000RPM) RAID1 67GB（データ用） – OS: CentOS 5 (è¨å®šã¯ã»ã¨ã‚“ã©ã„ã˜ã£ã¦ã„
Should I buy a Fast SSD or more memory?
While a scale-out solution has traditionally been popular for MySQL, it’s interesting to see what room we now have to scale up – cheap memory, fast storage, better power efficiency. There certainly are a lot of options now – I’ve been meeting about a customer/week using Fusion-IO cards. One interesting choice I’ve seen people make however, is buying an SSD when they still have a lot of pages r
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}