… several volumes. So I created 4 volumes ( I used m.large instance), and made: RAID0 on 2 volumes as:… -C /dev/md0 –chunk=256 -n 4 -l 10 -p f2 /dev/sdj /dev/sdk /dev/sdk /dev/sdm… xfs filesystem mounted with noatime,nobarrier options and for benchmark I used sysbench fileio modes on 16GB file with…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… full report and results are available on benchmark Wiki http://www.percona.com/docs/wiki/benchmark:flashcache:tpcc:start. Short version of… you can get it for 500$ ( price of Intel X25-M card) ( for this particular workload, your experience may vary!). On… my next rounds I am looking to run similar benchmarks on FusionIO card. P.S. And if CentOS team reads this post…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…table_id) inner join innodb_buffer_pool_pages_index as p using(index_id) where t.schema=’test’ group by …to be pushed out of buffer pool. Lets repeat the benchmark with innodb_old_blocks_time=1000 which will correspond … not need to do it in this case. I’m not sure if there are any bad side effects …
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… memory (or reducing amount of usable memory). The system I’m testing this on has 256MB BBU (Battery Backed up Cache….4.8: multi-threaded system evaluation benchmark There is also one trick running such larger scale benchmarks. SysBench by default has repeatable… enough to see the problem. P.S If you’re wondering which hardware I used for benchmarks – it is Dell PowerEdge 2950…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… Index creation. Keep it in mind if you decide to benchmark/compare it. If you would like to learn more about… show any benchmark numbers for it at all. But still there are some and they are pretty cool. P.S I’m also…
Comment: How reliable RAID really is
July 2, 2006 By 13 Comments
… can see benchmark data in “Performance Landscape” presentation from this site. Yes this does not make much sense but I’m not only the person to observe this behavior. Here are some benchmarks for SQL Server http://www.developersdex.com/sql/message.asp?p=580&r=4986921 My felling…
