… use gzip compression. LZ4 is the best right now with benchmarks showing up to 50% more performance than even lzjb. With… MLC L2ARCs like Samsung 840 Pro or Intel DC S3700 SSDs. BTW, Is percona ever going to support OmniOS?
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
… around 100Million rows using Tokutek’s iibench.py for the benchmark on a 2-way Supermicro server with 2 Xeon X5650… RAM and a very fast LSI MegaRaid backed storage with SSD Cache. Aurimas worked on that machine a month ago.
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on this size will be the… measure that also. And, if you want to repeat this benchmark, the sysbench code is on Launchpad lp:~vadim-tk/sysbench…/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…cache device, vCache shines. Compared to a deployment with no SSD cache whatsoever, FlashCache still does quite well, massively outperforming …vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… to provide the highest read throughput of any server-grade SSD, and at Micron’s request, I recently took some time…, and the numbers are indeed quite impressive. For reference, the benchmarks for this device were performed primarily on a Dell R720… is the same machine which was used in my previous benchmark run. A small handful of additional tests were also performed…
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 more appropriate. 2) How does P320h compare to Virident? You benchmarked Virident a…
Post: On Benchmarks on SSD
July 14, 2010 By 4 Comments
… from sysbench fileio random write benchmark with 4 threads. The results were taken on PCI-E SSD card ( I do not want… of the card during benchmark. However it makes task of running benchmark on SSD trickier. It is similar to benchmarks on database but up… likely in fresh state A). As SSD market involving, we will see more and more the benchmark results, so be ready to…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
… my opinion SSD cards are not reached enough level of reliability yet (see comments to post FusionIO 320GB MLC benchmarks), however I… can see results on http://www.percona.com/docs/wiki/benchmark:ssd:start, in summary table, randwr rows) 3. For cards connected… based drives instead of SSD in my InnoDB on FusionIO benchmarks). So in summary I can say With SSD drives you can get…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…/intel-ssd-910-in-tpcc-mysql-benchmark/. Now I want to test this card against RAID over spinning disks. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910….5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h for SSD, 4h for HDD…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
I continue my benchmarks of Intel SSD 910, the raw IO results are available in my previous … card is suitable to use with MySQL. Benchmark date: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare… 5.5.27-28.1 Benchmark specification Benchmark name: tpcc-mysql Scale factor: 2500W (~250GB of data) Benchmark length: 2h, but the result…
