(this is cross-post from http://www.ssdperformanceblog.com/) While PCI-e Flash cards show great performance, I am often asked about alternatives, as price for PCI-e cards is still significant and not acceptable for small companies and startups. Intel 320 SSD appears to be a popular drive with a quite acceptable price. I wrote about write performance of these [...]
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.
Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
Mat Keep’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB’s scalability as the number of cores in the server increases. Vadim runs lots of benchmarks that measure what happens under increasing concurrency while holding the hardware constant, but not as many with varying numbers of [...]
On Benchmarks on SSD
July 14, 2010 By 3 Comments
(cross post from SSD Performance Blog ) To get meaningful performance results on SSD storage is not easy task, let’s see why. There is graph from sysbench fileio random write benchmark with 4 threads. The results were taken on PCI-E SSD card ( I do not want to name vendor here, as the problem is [...]
SLC vs MLC
July 14, 2010 By Leave a Comment
(cross posting from SSDPeformanceBlog.com ) All modern solid state drives use NAND memory based on SLC (single level cell) or MLC (multi level cell) technologies. Not going into physical details – SLC basically stores 1 bit of information, while MLC can do more. Most popular option for MLC is 2 bit, and there is movement [...]
FlashCache: tpcc workload with FusionIO card as cache
June 2, 2010 By 20 Comments
This run is very similar what I had on Intel SSD X25-M card, but now I use FusionIO 80GB SLC card. I chose this card as smallest available card (and therefore cheapest. On Dell.com you can see it for about $3K). There is also FusionIO IO-Xtreme 80GB card, which is however MLC based and it [...]
PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
Finally I was able to run PBXT 1.0.11 pre-GA in tpcc-like workload, apparently there was bug with did not allow me to get the result earlier, and I am happy to see that PBXT team managed it. For initial runs I took tpcc 100 warehouses ( about 10GB of data) which fully fits into memory [...]
FlashCache: tpcc workload
May 25, 2010 By 18 Comments
This is my last post in series on FlashCache testing when the cache is placed on Intel SSD card. This time I am using tpcc-like workload with 1000 Warehouses ( that gives 100GB of data) on Dell PowerEdge R900 with 32GB of RAM, 22GB allocated for buffer pool and I put 70GB on FlashCache partition [...]
FlashCache: more benchmarks
May 18, 2010 By 15 Comments
Previously I covered simple case with FlashCache, when data fits into cache partitions, now I am trying to test when data is bigger than cache. But before test setup let me address some concern (which I also had). Intel X25-M has a write cache which is not battery backuped, so there is suspect you may [...]
FlashCache: first experiments
May 10, 2010 By 18 Comments
I wrote about FlashCache there, and since that I run couple benchmarks, to see what performance benefits we can expect. For initial tries I took sysbench oltp tests ( read-only and read-write) and case when data fully fits into L2 cache. I made binaries for FlashCache for CentOS 5.4, kernel 2.6.18-164.15, you can download it [...]
