great write up, heres a video I did on my SSD: http://www.youtube.com/watch?v=gZJ-pPeE5lA
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… to random IO caused by the COW (Copy on Write). SSD‘s solved the issue for us, plus we still benefit from the improved speed of having SSD‘s. SSD are more costly than spinning media, but the speed…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… httpd logs, they are as fast as older SSDs. But the newer SSDs are as big, and much faster than the 300GB…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… not hitting a bottleneck caused by compression. If I use SSD for L2ARC, I’ll need to do the same for…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… MLC L2ARCs like Samsung 840 Pro or Intel DC S3700 SSDs. BTW, Is percona ever going to support OmniOS?
Comment: ZFS on Linux and MySQL
May 26, 2013 By 17 Comments
Nice post Yves! Had any chance to try using ZFS volumes via iSCSI? Also why no mention of using SSD drives for L2ARC?
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/
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
… RAM and a very fast LSI MegaRaid backed storage with SSD Cache. Aurimas worked on that machine a month ago.
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… it becomes the bottleneck. Also, keep in mind that while SSDs are a lot faster than regular spinning disk, a PCIe flash card is still massively faster than an SSD, both in terms of throughput and in terms of latency… in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card is about 3x faster. By using a…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… We call this configuration B. The next one contained four SSD-specific optimizations based partially on some earlier work that I… configuration C (shown in the graph as the blue line – SSD config) which shows the most consistent performance. The others all… cache device, vCache shines. Compared to a deployment with no SSD cache whatsoever, FlashCache still does quite well, massively outperforming the…
