… RAM and a very fast LSI MegaRaid backed storage with SSD Cache. Aurimas worked on that machine a month ago.
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: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… memory but still fits into the cache device, vCache shines. Compared to a deployment with no SSD cache whatsoever, FlashCache still does quite…=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M…_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep…=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M…_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4…
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… in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card is about 3x faster. By using a… Facebook FlashCache. I’d never even heard of the STEC caching solution prior to your comment. Maybe another Perconian will have…
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?
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… results inconsistent. In short words using Intel SSD X25-E card with enabled write-cache (which is default and most performance mode… N commited transactions. So now time to turn off write-cache on SSD – all transactions are in place now, but write speed… 10 So in conclusion to warranty Durability with SSD we have to disable write-cache which can affect performance results significantly (I…
Post: L2 cache for MySQL
October 25, 2012 By 13 Comments
The idea to use SSD/Flash as a cache is not new, and there are different solutions for this, … buffer pool. Fortunately, there is a project in progress Flash_Cache_For_InnoDB by David which implements this. David helped us… on RAID data on SSD (Intel SSD 910) data on RAID with L2 cache on Intel SSD 910, and size of cache is 150GB As…
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… results are here and average results: RAID10 – 7439.850 TPM SSD – 10681.050 TPM FusionIO – 17372.250 TPM However what should….mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While results for SSD (note it is single…
Post: Intel 520 SSD in MySQL sysbench oltp benchmark
May 21, 2012 By 11 Comments
… does not affect MySQL workload significantly, and single Intel 520 SSD gives much better throughput and response time comparing with traditional… that this card does not have capacitor to protect write cache, so if you worry about data protection in case of… outage it is better to disable write cache on this card and use write cache from RAID controller (i.e. LSI-9260…
