… point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO… xfs 4 threads: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs…. This is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5…vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l… MRR works. What else worth to mention here is that MySQL is wrong choosing index scan here. If we try to…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… are any difference. Recently Tweakers.net published comparison of MySQL 5.0.20a vs 5.0.32bk as well as matching PostgreSQL 8.2… concurrency. The results for MySQL 5.0.20a vs 5.0.32bk are also extremely interesting: 1) For single CPU 5.0.32 is actually… peak performance for 5.0.32 is also much larger than for 5.0.20 – some 630 vs 540 tps. 4) The bad news…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are vanilla MySQL, not Percona… overhead. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5.0 grammar…
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
Working on large upgrade of MySQL 4.1 running Innodb to MySQL 5.0 and doing oprofile analyzes we found very interesting issue … of seconds being considered fast operation, as it is in MySQL 4.1 But why buf_get_latched_pages_number ? Because this… much higher for MySQL 5.0 compared to MySQL 4.1 It was something like 2-3 for MySQL 4.1 vs 40-60 for MySQL 5.0 At…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… serious bugs are. Large Team, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small tight knit team was working… of them use 5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4.1 was out for years and yet I would say no more than 5% of…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 … # Rows sent 7.15M 0 56.36k 4.19 0.99 360.95 0.99 # … # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # … kind of hardware provides better balance of CPU vs IO utilization as well as as simple …
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… fix for this scalability problem and it is merged into MySQL 5.0.30 “Enterprise” but according to the tests I’ve… see MySQL 4.1 actually scaled pretty well with Niagra, suffering slow regression with increased concurrency rather than quick drop. In MySQL 5.0… seen much better on this picture Linux vs Solaris comparison is also pretty interesting. With MySQL Linux has higher peak but Solaris…
