…IO performance of this card. The benchmark methodology I described in previous posts…response times: We still see small hiccups in throughput and response times even for small amount of threads. For 8 threads the 95% response time… affect MySQL performance, and I am going to run some MySQL workloads …
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… peak throughput at 8 threads. And response time: For 8 threads, we may expect 0.62ms response time. In general I have very good experience with this card, and it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… internal cache or something. To understand better what kind of response time we should expect, I ran random read sync IO mode… throughput at 16-32 threads. And response time: For 16 threads, we may expect 0.96ms response time, which increases to 1.62ms under… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…It really makes sense to test it under MySQL workload, but before getting to that, let …, rev 107053 Following the format of previous benchmarks, first is random write async 16KB case. … Throughput: Response time: For same cases (i.e. 4 threads) we see some interesting patterns. As for response time, …
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response time is way more important metric to compare… queue piles up, waiting time grows, and the final response time grows linearly up to ~30 sec, where benchmark stops, because the queue is…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for a… was gathering during the benchmarks, the reason was in fact lower number of IO operations and higher response time – so it seems in…
Post: Benchmarks of new innodb_flush_neighbor_pages
January 17, 2012 By 6 Comments
… it have ? Let’s run some benchmarks. We repeated the same benchmark I ran in Disaster MySQL 5.5 flushing, but now we… ProLiant DL380 G6 First results from HP ProLiant. Throughput graph: Response time graph (axe y has logarithmic scale): As you see with… and response time) from Cisco UCS 250 server: You see, on this server we have longer and deeper periods when MySQL stuck in…
Post: Introducing tpce-like workload for MySQL
February 8, 2010 By 3 Comments
We have been using tpcc-mysql benchmark for long time, and there many results published in our blog, but that’… looking into different benchmarks, and one of them is TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we… count of 11 different transactions per 10 secs and 90% response time. and final result [TradeResult(TR) transaction] Succeed: 150243 Lated: 0…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… worked on some of the previous SpecJAppServer Benchmarks several years ago while being employed by MySQL. These are great results, plus they… the database ? Or does it mean MySQL did not scale well to 8 cores on this benchmark ? Now lets look at Java… was done to deal with “dips” which can affect peak response times a lot. The fuzzy checkpointing could be done a lot…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… to add support for Percona XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve… I am going to run different benchmarks, I expect that for simple master-slave setups the response time and throughput will be affected… for synchronous not-getting-behind slaves. With additional nodes, the response time will only increase. And in multi-nodes setups, the performance…
