… seconds. Ratio 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.0… those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There is a…
Post: MySQL 6.0 Subquery optimizations are published.
February 6, 2008 By 4 Comments
… in MySQL 6.0 which is far from all the issues but still very good number. If you had issues with subqueries in MySQL 4.1 or 5.0 and pulled away from using them I’d encourage you to try MySQL 6.0 and see… in Progress and Plans, Benchmarks and Test Results Hopefully in the future we’ll see more MySQL teams being proactive with publishing…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…’ve recently done benchmarks comparing different MySQL versions in terms of their CPU efficiently in TPC-C…. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6% … us there are some workloads when MySQL 5.1 is slower than 5.0, and same applies to the new …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for a… said, benchmark was running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket… in_prg {540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% 0.0 0.6 85% 0 Misaligned: #ts device…
Post: Quick look at Ubuntu 6.06
June 13, 2006 By 3 Comments
… talks around new coming Ubuntu 6.06, so I decided to make quick benchmarks. I used sysbench 0.4.6 oltp-read-only workload… if we are using the same version of MySQL. So I used MySQL 5.0.22 and my box Dual Core Athlon 3800… per sec, more is better): InnoDB threads Ubuntu 6.06 Suse 10.0 Suse/ Ubuntu ratio 1 478.66 536.91 1…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… work on “High Performance MySQL, 3rd edition”, Baron asked me to compare different MySQL version in some simple benchmark, but on decent hardware… (more is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52… 6994.04 Scripts and results are also on our Launchpad Benchmark project (function() { var po = document.createElement(‘script’); po.type = ‘text…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… #!/bin/bash NUMROW=100000 COUNT=0 while [ "$NUMROW" -gt "$COUNT" ] do UUID=`uuidgen` mysql test -e “insert into…of MySQL. For the benchmark, I used an old PII 350 MHz computer, I think for such CPU bound benchmarks,… gain is negative up to the point, around 6.4MB where no more sort merge pass are…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It …MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am going to run different benchmarks…terms of features and performance. Update (6-Jun-2011): It was my misunderstanding…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… in recent MySQL 5.0 versions. In this presentations we will look into which problems are fixed. MySQL and Social Networks benchmarks We’re… MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL 6.0 are different from MySQL 5.0 – we…
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
… notes about little gains in MySQL 6.0. Do not get this post wrong. I’m not saying MySQL 6.0 SubQuery optimizations are non existent…-H queries or queries from any other benchmarks, rather they look at the queries which MySQL Users have problem with and first… make it into final MySQL 6.0 release. Summary: Poor MySQL 6.0 performance on TPC-H queries does NOT mean to quantify MySQL Optimizer Team work…
