… this is good for SSD, or something else (i.e. xfs) should be used. Traditionally our recommendation is xfs, and it comes to… to share earlier results what I have. I use STEC SSD drive 200GB SLC SATA (my thanks to STEC for providing… running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result significantly…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
… the overwrite DIO performance problem: http://oss.sgi.com/archives/xfs/2012-02/msg00219.html Now that the prerequisite fixes have… check this was the problem – I don’t have a SSD available right now, so I ran the tests on a… throughput being in GB/s sync async threads throughput throughput XFS ext4 XFS ext4 1 1.90/124k 1.41/92k 1…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… up again. Long story is: I started with puting XFS on SSD and running very primitive test with INSERT INTO fs VALUES… case of system failure. Running this test with default XFS setting I saw SSD was doing 50 writes / s, this is something…/03/xfs-write-barriers/ ), but again with enable write-cache you may lose transactions. So in final conclusion: 1. Intel SSD X25E…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint controller, FusionIO card) on our working horse… 3GB). Filesystem – XFS mounted with nobarrier option. Graphical results are here and average results: RAID10 – 7439.850 TPM SSD – 10681.050 TPM….mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While results for SSD (note it is single…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… have a chance to test a system with Intel 320 SSD drives (NewRelic provided me with an access to the server… Intel drives: Intel 320 SSD 600GB HDD drives: Seagate Cheetah 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size=4096, mount… however allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… data+indexes) XFS Filesystem mounted with nobarrier option. Tests run with: RAID10 with BBU over 8 disks Intel SSD X25-E 32GB… performance by about five times (or 2x with an Intel SSD). To get the same improvement with memory, you would… memory slots already filled?) Does your budget allow to install SSD cards? (You may still need more than one, since they…
Comment: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 19, 2010 By 15 Comments
…? I mean this: http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/ http://www…
Comment: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 19, 2010 By 15 Comments
…? I mean this: http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/ http://www…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
… on ext3 vs xfs on SSD card, the results are: Interesting facts: – xfs is 25% faster ext3 – the gaps on SSD is more visible… mention I have strange results on xtradb running it on xfs on RAID10, I have results about 2times slower than for ext3. I am not sure yet – is it xtradb or xfs problem, and why it appears only on RAID10, but not SSD.
Post: FlashCache: first experiments
May 10, 2010 By 18 Comments
… ( 1 gen firmware) ( Model Number: SSDSA2SH032G1GN INTEL, Firmware Revision: 045C8621) * SSD-2: Intel X25-M 160GB ( 2 gen ) ( Model Number: INTEL…, Firmware Revision: 2CV102HA ) * FlashCache: build over SSD-1 or SSD-2 * Filesystem XFS, builds as: mkfs.xfs -f -d su=16384,sw=40 /dev…* are placed on separate RAID partition ( not on FlashCache or SSD) * Benchmark: sysbench oltp ( read-only and read-write modes), 80mln…
