… now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on … Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced… Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our …
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
… have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30. It is interesting to compare with… the graphs provided in these benchmarks and see what value is best for MySQL 5.1 and for MySQL 5.0 respectively ? Both versions… MySQL 5.0 to see if they are possible to be reclaimed. Finally – if I would be doing QA, and benchmarks as…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… 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… Method of benchmark: 1. Prepare table with 1,000,000 records (about 350Mb of data on disk) 2. Run each query for 1, 4…: http://www.mysqlperformanceblog.com/files/benchmarks/innodb-myisam-falcon.html (Note: This benchmark is synthetic micro benchmarks focusing on particular simple data access…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… individual queries. We also packaged the toolset we used for benchmarks so you can repeat them if you like. It can… 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… complex analytics queries, in particular those presented in TPC-H benchmark are still subpar even with changes which are currently seen…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here… dropped OS caches by `echo 1 > /proc/sys/vm/drop_caches` and restarting mysqld) 5.1 – time 1 hour 14 min 36.90 sec 6.0 – time 1 hour 6 min 2.21…
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 … couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very… a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…, so I ran benchmark to check new results and also compare overall performance of InnoDB in 5.0 and 5.1 before and after… page http://www.mysqlperformanceblog.com/files/benchmarks/innodb_scale.html (Note: This benchmark is synthetic micro benchmarks focusing on particular simple data access…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The… Method of benchmark: 1. Prepare table with 1,000,000 records (about 350Mb of data on disk) 2. Run each query for 1, 4… hard for InnoDB even with all scalability fixes exist in 5.1.16 tree. I think InnoDB team should solve this problem…
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… 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…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… Percona’s R900 machine. The scripts and results are on Benchmark Wiki and the relevant my.cnf settings were innodb_buffer… found at the Benchmark Wiki with the rest of the scripts and results) and here are the updated 5.6.2 results… the moment seems to be the one in Percona Server 5.1. MySQL 5.6.2 multiple purge threads have major issues and…
