… are looking for cheaper alternatives. SATA SSD is an options. There is many products based on MLC technology, and Intel 320 I… it appears there is no a reliable way in the Linux asynchronous IO library to get time metrics for particular IO… giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk on Percona Live MySQL Conference 2012…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… it appears there is no a reliable way in the Linux asynchronous IO library to get time metrics for particular IO… oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If you are interested more in SSD and MySQL questions – I… giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk on Percona Live MySQL Conference 2012…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or something else… 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux. Let’s test “async” mode in sysbench, and now we…-time=3600 –max-requests=0 –num-threads=$numthreads –rand-init=on –file-num=1 –file-extra-flags=direct –file-fsync-freq…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
…: I’d say SSDs show comparable results with FusionIO on 16+ threads, however on 4-8 threads difference is significant. On SSD you can get… for research, I think there some serialization in Linux software raid or Linux scheduler or on Adaptec hardware level. 2. Cards connected in…. like I put InnoDB transactional logs on rotation based drives instead of SSD in my InnoDB on FusionIO benchmarks). So in summary I…
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… cycles, after which it gets unusable. And obviously the SSD card based on MLC NAND has a limited lifetime. There is a… there are some facts that can help you to estimate. On Linux you can look into the /proc/diskstats file, which shows… on regular RAID is much less than on SSD and you do not know what your throughput will be when you put workload on SSD…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… Linux swap / Solaris Partition 2 does not end on cylinder boundary. /dev/sda3 1738 145649 1155959808 83 Linux Partition 3 does not end on… Linux swap / Solaris Partition 2 does not end on cylinder boundary. /dev/sda3 27920384 2339839999 1155959808 83 Linux Partition 3 does not end on… in 512-bytes internally. This however gets more complicated with SSD drives which often operate in 4kbyte units, though this is…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… HT for original Heikkis answer. Q26: You also say on Unix/Linux only one read-ahead can happen at the same time… algorithm. I’m also wondering if you would recommend using SSD for this purpose, and how much performance gain there might… special options or tricks that should be implemented on larger servers? HT: I think Linux often likes to use about 20 % of…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
…, which I will discuss: Because Virident has competition in the SSD market, they have stated their goals to distinguish themselves from…, SSD-based cards have special characteristics; the throughput declines when space utilization increases. Virident’s design/programming minimizes this decline. RAID5 on… used in benchmarks include: Server: Cisco UCS C250, running Oracle Linux 6.1 and Percona Server 5.5.15 Client: HP…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… Raid cards these days are rarely as good as linux in maximising throughput, even the PCI-E x8 variants…tytso/blog/2009/02/20/aligning-filesystems-to-an-ssds-erase-block-size/) 5) Set the drive mount in…Relocate the innodb log files to a directory on a seperate partition on a standard HDD. It’ll help …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…, and there’s no shortage of articles on the topic on this blog. I wanted to write a …why this is still useful if you can use Linux native AIO. These can also be rendered useless …be ‘estimate’ (good default) and ‘keep_average’ designed for SSD type storage. Running Percona Server and using this …
