… by compression. If I use SSD for L2ARC, I’ll need to do the same for xfs… I am redoing my tpcc…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
@JDempster: I could give the SSD to xfs also with Flashcache and the like. Don’t forget all these jbods have a raid controller write cache in front of them. I also did the Innodb tuning. @Nils: no fuse, direct kernel support. Look here: http://zfsonlinux.org/
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
The Micron P320h SSD is an SLC-based PCIe solid-state storage device which … to provide the highest read throughput of any server-grade SSD, and at Micron’s request, I recently took some time… sysbench OLTP: It is worth noting here that EXT4 outperforms XFS by a fairly significant margin. The approximate raw numbers, in…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… you recommend EXT4 over XFS for MySQL on SSD? What about Btrfs or ZFS? Seems like with SSD the newer file systems could…
Post: Testing the Virident FlashMAX II
March 21, 2013 By 1 Comment
… test results from the Virident FlashMax 1400M, an MLC PCIe SSD device. Since that time, Virident has released the FlashMAX II… 6.3, and the filesystem used for the test was XFS, mounted with both the noatime,nodiratime options. The card was…
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: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… 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…
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…
