… and below. I do not have enough space on this SSD to run this experiment that long. So there we see… easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on this size will be the…/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… EXT4 over XFS for MySQL on SSD? What about Btrfs or ZFS? Seems like with SSD the newer file systems could be…
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…
Comment: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
> “but still small enough to fit into the cache device” Do not see, why test vCache or flashcache with such condition, when you can put ssd as disk then?
Comment: Death match! EBS versus SSD price, performance, and QoS
May 13, 2013 By 55 Comments
… we use (for our SQL Server) does have two ephemeral SSDs. Since they are ephemeral I’m not comfortable putting the…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
The point at 685 sec when InnoDB performance drops, is that when data doesn’t fit all in RAM anymore? I would in general expect to see benefits from TokuDB when workload is diskbound. You could artificially reduce InnoDB buffer pool (and corresponding Tokutek setting) to have more SSD vs RAM.
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…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
… 8 threads. Random writes: There couple things to note (beside SSD is doing much worse than FusionIO). 1. Something is wrong…: – For sequential reads you can get pretty decent results from SSD (230MB/sec on 4+ threads) – Cards connected in hardware raid… single FusionIO card, however there is important point that with SSD you may “hot”remove and insert cards, while for FusionIO…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… I wanted to publish some nice benchmarks where InnoDB on SSD outperforms RAID 10, but recently I faced issue which can make previous results inconsistent. In short words using Intel SSD X25-E card with enabled write-cache (which is default… with RAID 10 So in conclusion to warranty Durability with SSD we have to disable write-cache which can affect performance…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… spinning disks. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with HDD RAID10…, disks: Seagate ST9750420AS 750GB, 2.5″, 7200RPM, 16MB, SATA. Intel SSD 910 (software RAID over 2x200GB devices) Filesystem: ext4 Software OS… face any problem working with this card. I think Intel SSD 910 is suitable to use with MySQL / Percona Server, especially…
