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
… on Write). SSD‘s solved the issue for us, plus we still benefit from the improved speed of having SSD‘s. SSD are more… no cost difference. ZFS provides built in checksumming and double write buffering, so make sure these are turned off in InnoDB…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… fast, that for linear writes, like httpd logs, they are as fast as older SSDs. But the newer SSDs are as big, and…
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: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… need to start writing massive amounts of data to disk. I could go out and buy a bunch of SSDs and RAID… a Samsung 830 in the laptop I’m using to write this comment on. It’s pretty fast. But it’s… much closer to memory speed than a regular SSD or HDD RAID), I can write data out to spinning disk at a…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…_threads = 16 innodb_write_io_threads = 16 We call this configuration B. The next one contained four SSD-specific optimizations based partially… would be cached (i.e., no special treatment of sequential writes) and with a 50% dirty page threshold. Again, for comparison… about 12500. FlashCache came in around 7500 or so. Sysbench writes came in just under 8000 for vCache + time-based flushing…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… note the transaction produces 4 INSERTs and workload is very write intensive. So what are results in this case: InnoDB gradually…/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep…_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native…
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… peak capacity somewhere between 32 and 64 threads, and synchronous write tops out somewhere between 64 and 128 threads. The latency… MySQL? Exact results vary, depending upon the usual factors (read/write ratio, working set size, buffer pool size, etc.) but overall…
Comment: Death match! EBS versus SSD price, performance, and QoS
May 13, 2013 By 55 Comments
… write latencies which continue to be a problem. The AWS instance we use (for our SQL Server) does have two ephemeral SSDs… the tlogs there which addresses most of the issues surrounding write latency. I agree with the main contention of this article that write latency is a problem on AWS but I have managed…
Post: Intel 320 SSD write performance - contd.
September 28, 2011 By 8 Comments
… SSD write performance before, but I was not satisfied with these results. Somewhat each time on Intel 320 SSD I was getting different write… experiment as in previous post, this is sysbench fileio random write on different file size, from 10GiB to 140GiB with 10GiB… each run. This leads me to conclusion that write performance on Intel 320 SSD is decreasing in time, and actually it is…
