…/18/xtradb-benchmarks-15x-gain/ are too marketing, and we should show other results also. Here is the run for CPU Bound,or it would be more correctly to say in-cache benchmark, because there is a lot of CPU remains idle. This run is exactly the same as Disk Bound but with…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… and ran few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
… : 6 cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM Disks do no matter, as I ran clear CPU-bound benchmarks. The raw results of benchmarks are available here: http://spreadsheets.google.com/pub… page http://www.mysqlperformanceblog.com/files/benchmarks/innodb_scale.html (Note: This benchmark is synthetic micro benchmarks focusing on particular simple data access…
Post: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
… check how it works in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer… Google Spreadsheet (it is also being update with my next CPU benchmarks, and benchmark on SSD & FusionIO), also I post graph there: Results…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…, without them I would not be able to run benchmarks. Description of benchmark: We used table “normal” table structure which corresponds to… also use CPU bound workload in this case (no disk IO) to see how efficient storage engines are in terms of CPU usage….mysqlperformanceblog.com/files/benchpbxt/res.html (Note: This benchmark is synthetic micro benchmarks focusing on particular simple data access patterns. Results for…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… on new storage engine – show me benefits. So there is benchmark I made on one our servers. It is Dell 2950…-disks utilization. Also results may be different if load is CPU bound. I compared MySQL 5.1.30 trees – MySQL 5.1….30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks I used scripts that emulate TPCC load and datasize 40W…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… also use CPU bound workload in this case (no disk IO) to see how efficient storage engines are in terms of CPU usage…: http://www.mysqlperformanceblog.com/files/benchmarks/innodb-myisam-falcon.html (Note: This benchmark is synthetic micro benchmarks focusing on particular simple data access…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
We’ve recently done benchmarks comparing different MySQL versions in terms of their CPU efficiently in TPC-C like Workload. We did… be recognized by older Innodb versions. Note: These are completely CPU bound test conditions, data fits to buffer pool furthermore data and… usually shows synchronization is the issue. Barracuda format uses more CPU while delivering better performance so it is probably better with…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
I had found pile of MySQL and PostgreSQL benchmarks on various platforms which I have not seen before. Very … used – it turns out Both are used in the benchmark. This is CPU bound benchmark with working set fitting in memory. MySQL and PostrgreSQL… less with increased concurrency. Note: I have not validated these benchmarks and as I already mentioned they do not have full…
Post: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
… (Dell PowerEdge R815), I decided to run some simple sysbench benchmark to compare how both CPUs perform and what kind of… to rerun benchmark after upgrade Cisco to CentOS 6 ( will be it even released or it is dead ? ). For benchmark I took… into memory, so it is full CPU bound benchmark. The full numbers, script and config are on our Benchmark Wiki, there are some graphs…
