… same 2.2TB Virident FlashMAX II as the cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system… memory but still fits into the cache device, vCache shines. Compared to a deployment with no SSD cache whatsoever, FlashCache still does quite…_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
…_pool 3GB). Filesystem – XFS mounted with nobarrier option. Graphical results are here and average results: RAID10 – 7439.850 TPM SSD – 10681.050….mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While results for SSD (note it is single…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 12 Comments
… customers are looking for cheaper alternatives. SATA SSD is an options. There is many products …. Hardware for tests: HP ProLiant DL380 G6, filesystem: ext4, mounted with nobarrier. The results for … drops – the drive periodically cleans an internal cache or something. To understand better what kind …
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… useful space Intel drives: Intel 320 SSD 600GB HDD drives: Seagate Cheetah 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size… however allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… de facto filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or… to share earlier results what I have. I use STEC SSD drive 200GB SLC SATA (my thanks to STEC for providing…=${size}G prepare sync echo 3 > /proc/sys/vm/drop_caches for numthreads in 4 do sysbench –test=fileio –file-total…
Post: FlashCache: first experiments
May 10, 2010 By 18 Comments
…) * SSD-2: Intel X25-M 160GB ( 2 gen ) ( Model Number: INTEL SSDSA2M160G2GC, Firmware Revision: 2CV102HA ) * FlashCache: build over SSD-1 or SSD-2 * Filesystem…: Directly on RAID Directly on SSD Data stored on RAID, but caching in FlashCache ( which located on SSD) The results for Read-Only…
Comment: Effect from innodb log block size 4096 bytes
January 5, 2011 By 19 Comments
… to read whole 8K if the page is not yet cached and then write 4K.. – so there is a difference, but… 7-8MB/s write speed from the filesystem it’s hard to claim that for SSD using 512 bytes buffered writes is… to SSD there are first 7-MB of data came into the filesystem buffer and only then they are flushed to SSD.. – so…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… should be safe running Intel X25-M with enabled write cache. Second issue I faced, and which took quite efforts to… I had too many cache misses so results were not impressive, I had to move to standard for filesystems 4K blocks. For… gives about 70GB of data. I allocated 35GB for cache on SSD and I used 16GB and 10GB buffer pool sizes. I…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… know lots of people want to try out the intel SSD‘s, some simple config changes I’d make to get… formatting to match the SSD (see here: http://thunk.org/tytso/blog/2009/02/20/aligning-filesystems-to-an-ssds-erase-block-size…=/var/lib/mysqlnonssd/ 8) Make sure you bypass the OS caches innodb_flush_method=O_DIRECT 9) We get the best…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…*Quad Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read sizes (matches … in such condition – normal case is to allocate cache memory to buffer pool so IOs will mostly … Innodb team will put on their roadmap. With SSD coming this will be important. And it is …
