…, so let me jump directly to results. First case is random write asynchronous 8 threads IO, the test is done just after… time is 0.69ms. Now let me get back to random write case. I will try synchronous IO varying amount of threads… am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let me review the…, first is random write async 16KB case. We can see some wave-like pattern with throughput 350-400 MiB/sec. Random reads, async… and each card shows individuals patterns and different handling of write and read IO cases. Follow @VadimTk !function(d,s,id…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…it will be 100 disk seeks to answer a random query, assuming you can get each index query … the secondary keys is simply because you are writing 4 times fewer B-tree values. The primary … that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async… DL380 G6, filesystem: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): It seems that InnoDB is… threads. The periodic drops that I observe for both random reads and random writes do not allow me to recommend this drive for…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async… DL380 G6, filesystem: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): In general it shows stable… is related to internal garbage collector activity. The results for random read case: Very stable throughput on line 222 MiB/sec…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… file” with O_DIRECT case (sysbench fileio 16 KiB blocksize random write workload): ext4 1 thread: 87 MiB/sec ext4 4 threads… one more point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5… question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems…
Post: FusionIO 320GB MLC random write performance
June 23, 2011 By Leave a Comment
I have posted results for FusionIO 320GB MLC on our ssdperformanceblog.com blog. To not duplicate content, there is link on original post:http://www.ssdperformanceblog.com/2011/06/fusionio-320gb-mlc-random-write-performance/ Follow my twitter Follow @VadimTk for further results.
Post: Intel 320 SSD random write performance
June 23, 2011 By 1 Comment
I have posted results for Intel 320 SSD on our ssdperformanceblog.com blog. To not duplicate content, there is link on original post:http://www.ssdperformanceblog.com/2011/06/intel-320-ssd-random-write-performance/ Follow my twitter @VadimTk for further results.
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… there is no overhead) for sequential writes and it gets a maximum value for fully random writes. This value can be 2 – 5… writes 379835046150144 (379.84TB) (writes) Having this info let’s take look what a lifetime we can expect under a tpcc-mysql workload… space. Please note we put a quite intensive write load during this hour. MySQL handled 25,000 updates/sec, 20,000 inserts…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have… 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important metric for write intensive workloads where there’s a lot… the two workloads that are most relevant to databases – random reads and random writes – IO alignment on a 4-disk RAID10 with standard…
