…benchmarks? Well, all benchmarks are lie, and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql… strict 0.5 sec, but 0.5 is …1-8 threads): The queue piles up, waiting time grows, and the final response time grows linearly up to ~30 sec, where benchmark…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
As you might have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30. It is interesting to compare with… at the graphs provided in these benchmarks and see what value is best for MySQL 5.1 and for MySQL 5.0 respectively ? Both versions do… for MySQL 5.0 to see if they are possible to be reclaimed. Finally – if I would be doing QA, and benchmarks as…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6… those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… compared MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks I… see XtraDB is somewhat 1.5x better than InnoDB in standard 5.1.30 and even more than InnoDB-plugin-1.0.2 And there…
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… bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2… post. And last one workload I tried is TPCC-like benchmark (you can get it on https://launchpad.net/perconatools), with…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1-falcon…-cache=512 –net_read_timeout=30 –net_write_timeout=30 –back_log=128 Method of benchmark: 1. Prepare table with 1,000,000 records (about…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l….37 0.61 130224.59 4.92 65112.30 2.46 240.73 0.30 0.56 0.55 29.49 Device…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… with 346GB of RAM , and I ran the tpcc-mysql benchmark with 500W (about 50GB of data) on the FusionIO … settings in a short period of time, I used 30-minute runs, which may not be long enough to …52679.93 NOTPM. This is 1.4x better than we have with the stable line in MySQL 5.5.8. But, finally, let …
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… get the following results: 13GB: MySQL 5.5.8 – 23,513 NOTPM, Percona Server – 30,436 NOTPM, advantage: 1.29x 52GB: MySQL 5.5.8 – 71,774 NOTPM, Percona Server – 88,792 NOTPM, advantage: 1.23x 144GB: MySQL 5.5.8 – 78… for high MySQL performance, and we tune Percona Server to get the most from such hardware. Actually, from my benchmarks, I see…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…the MySQL 5.5 code line. The answer: Yes, we are. My benchmarks here are based on Percona Server 5.5.7….MySQL 5.5.8 we have regular dips (3 times per hour) from 24900 NOTPM to 17700 NOTPM (dips of around 30… best choice is innodb_buffer_pool_instances=1, as we implemented buffer pool scalability in …
