All of Percona’s open source software products, in one place, to download as much or as little as you need.
An Introduction to InnoDB Internals
All of Percona’s open source software products, in one place, to download as much or as little as you need.
Making slave pre-fetching work better with SSD
In the recent few weeks I have spent some time for creating yet another slave prefetching tool named "Replication Booster (for MySQL)", written in C/C++ and using Binlog API. Now I'm happy to say that I have released an initial version at GitHub repository. The objective of Replication Booster is same as mk-slave-prefetch: avoiding or reducing replication delay under disk i/o bound workloads. This
XtraDB 5.5版 性能調整ä¸
色々ã‚ã‚Šã¾ã—ãŸãŒã€æœ€è¿‘ã€ã‚„ã£ã¨ 5.5.x 版ã®XtraDBを開発ä¸ã§æ€§èƒ½ã‚’確èªã—ã¦ã„ã¾ã™ã€‚ SSD ã§è©¦ã—ãŸã‚Šã‚‚ã—ã¦ã„ã‚‹ã®ã§ã™ãŒã€ä»Šã¾ã§æ°—ã«ã—ã¦ã„ãªã‹ã£ãŸã“ã¨ãŒæ„外ã«é‡è¦ãªã“ã¨ã«è‰²ã€…æ°—ã¥ã„ãŸã®ã§è¦šãˆæ›¸ã。 SSD ã§æ›´æ–°ç³»ãŒå¤šã„処ç†ã§é«˜æ€§èƒ½ã‚’出ã™ã‚³ãƒ„ １．Linux native AIO を利用ã™ã‚‹ã€‚ (5.5 共通) SSDã¯IOãŒé€Ÿã„ã®ã§ï¼ˆï¼Ÿï¼‰ã€ä»Šã¾ã§é€šã‚ŠInnoDB内部ã®aioを使ã†ã¨ã¡ã‚‡ã£ã¨éžåŠ¹çŽ‡ã§ã€é‹ãŒæ‚ªã„ã¨æš«ã処ç†ã•ã‚Œãªã„リクエストãŒå‡ºã¦ãã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šãã†ã§ã™ã€‚5.5 ã§ã¯ã‚‚ã†å†…部ã®aioã«ã¯ãƒ‘ッãƒã‚’当ã¦ãšã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆé€šã‚Š Linux native AIO を使ã†ã“ã¨ã‚’推奨ã—ã¾ã™ã€‚使ãˆãªã„環境ã®äººã¯ã€ãªã‚“ã¨ã‹ä½¿ãˆã‚‹ã‚ˆã†ã«ã—ã¦ã‹ã‚‰ãƒ“ルドã—ã¦ãã ã•ã„。。。 ２．圧縮機能を利用ã—ãªã„。 データページã®åœ§ç¸®æ©Ÿèƒ½ã¯SSDã®æŠ˜è§’速ã„IOレスãƒãƒ³ã‚¹ã‚’殺ã—ã¾ã™ã€‚ã‚‚ã—もデータã®å®¹é‡ãŒSSDã«
Planet MySQL - Archives - Tables on SSD, Redo/Binlog/SYSTEM-tablespace on HD...
Planet MySQL - Archives - Tables on SSD, Redo/Binlog/SYSTEM-tablespace on HD... Your blogs, news and opinions. I recently did a disk bound DBT-2 benchmarking on SSD/HDD (MySQL 5.4.0, InnoDB). Now I'm pretty confident that storing tables on SSD, redo/Binlog/SYSTEM-tablespace on HDD will be one of the best practices for the time being. This post is a detailed benchmarking report. (This post is very
MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’用ã„ãŸIntel X25-M SSDã®è©•ä¾¡ - SH2ã®æ—¥è¨˜
X25-Mã€SSDã§æ¤œç´¢ã—ã¦ãã‚‹æ–¹ãŒéžå¸¸ã«å¤šã„ã®ã§ã€æœ¬ãƒ–ãƒã‚°å†…ã®SSD関連記事をリストã—ã¦ãŠãã¾ã™ã€‚ MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’用ã„ãŸIntel X25-M SSDã®è©•ä¾¡ (本記事) SSDã®çœŸã®æ€§èƒ½ã‚’引ã出㙠MySQL 5.1.38 InnoDB Plugin (2009/09/07) 先週末Intelã®SSDã€X25-MãŒçªç„¶7,000円ã»ã©å€¤ä¸‹ãŒã‚Šã—ãŸã®ã§ã€ã¤ã„ã«æˆ‘æ…¢ã§ããšæ‰‹ã‚’出ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚åˆã‚ã¦ã®SSDå°Žå…¥ã§ã™ã€‚ SSDã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯è¨˜äº‹ã¯å›½å†…・海外å•ã‚ãšãŸãã•ã‚“ã‚ã‚Šã¾ã™ãŒã€å®Ÿéš›ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¹—ã›ã¦è¨ˆæ¸¬ã—ãŸè¨˜äº‹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“。ãã“ã§ã€å…ˆæ—¥ã”紹介ã—ãŸtpcc-mysqlを用ã„ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ã¦ã¿ã¾ã—ãŸã€‚ データベースサームOS ： Windows XP SP3 32bit CPU ： Core2 Duo T7300 2.0GHz (EIST OFF)
DeNAæ¾ä¿¡ã•ã‚“ã®ã€ŒMySQL環境ã«ãŠã‘ã‚‹Fusion-io検証çµæžœã¨DeNAã«ãŠã‘る活用価値ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ¡ãƒ¢ - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€…
弊社ã®ä¸€éƒ¨ã®ã‚µãƒ¼ãƒ“スã§ã‚‚絶賛活èºä¸ã®Fusion-io社ã®ioDrive。 Fusion-io ioDriveã¨Fusion-io ioDrive Duoã§ã¯ã©ã¡ã‚‰ã‚‚ã€æœ€å°å®¹é‡ã®ãƒ¢ãƒ‡ãƒ«ã¯SLCåž‹ã€ãã®ã»ã‹ã¯MLC型を使ã£ã¦ã„ã‚‹ãŒã€Fusion ioDriveã®èªã¿è¾¼ã¿é€Ÿåº¦ã¯735〜770MB/sã€æ›¸ãè¾¼ã¿é€Ÿåº¦ã¯510〜750MB/sã 。Fusion ioDrive Duoã«è‡³ã£ã¦ã¯ã€èªã¿è¾¼ã¿é€Ÿåº¦ã¯1.0〜1.5GB/sã€æ›¸ãè¾¼ã¿é€Ÿåº¦ã¯ä¸€å¾‹1.5GB/sã¨ã„ã†æ•°å€¤ã‚’ãŸãŸã出ã™ã€‚ ï¼ IT Special PR：Fusion-ioã®ã‚¯ãƒ¼ãƒ«ãªæŠ€è¡“を使ã„ã“ãªã›ï¼ 今日ã¯ãƒ‡ãƒ«ã•ã‚“主催ã®ä¸‹è¨˜ã‚»ãƒŸãƒŠãƒ¼ã«ã¦ã€ã“ã®Fusion-ioã«é–¢ã™ã‚‹DELL社ã®æ¤œè¨¼çµæžœç´¹ä»‹ã‚„ã€DeNAæ¾ä¿¡ã•ã‚“ã«ã‚ˆã‚‹MySQL環境ã§ã®Fusion-io検証çµæžœãŠã‚ˆã³DeNAã§ã®åˆ©ç”¨ã«é–¢ã™ã‚‹ãŠè©±ãŒèžã‘ã‚‹ã¨ã®ã“ã¨ã ã£ãŸã®ã§ã€é€”ä¸ã‹ã‚‰ã®å‚åŠ ã§
SSD Deployment Strategies for MySQL
1. SSD Deployment Strategies for MySQL Yoshinori Matsunobu Lead of MySQL Professional Services APAC Sun Microsystems [email protected] Copyright 2010 Sun Microsystems inc The World’s Most Popular Open Source Database 1 2. What do you need to consider? (H/W layer) • SSD or HDD? • Interface – SATA/SAS or PCI-Express? • RAID – H/W RAID, S/W RAID or JBOD? • Network – Is 1GbE enough? • Memory
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ページを開ã
Secure, AI-Powered Content Management, Workflow & Collaboration
Linux and H/W optimizations for MySQL
{{#tags}}- {{label}}
{{/tags}}