… huge difference when the workload is IO bound and the query time drops from 2534.41s down to under a minute. MySQL 5.6… making much of a difference here. Now let’s take a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer…=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1 Handler_mrr_init N/A 112 3 1133 1 1 Handler_mrr_key_refills…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1 Created_tmp_tables 1 1 1 1 1…difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.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 optimizer… enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…different…1.97g mysql-data sb owi-ao 20.00g mysql-data-201202230150 sb swi-a- 5.00g mysql-data 0.00 mysql-data-201202230153 sb swi-a- 5…
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.0.4Ratio… of magnitude better compared to MySQL results on 10G database. TPC does discourage from comparing results against different database sizes so let…
Post: MySQL 5.1 went to GA. Was it a good move ?
December 10, 2008 By 4 Comments
… this has anything to do with MySQL 5.1 stability. I know people who are happy with MySQL 6.0 and Falcon stability for months now… bright side MySQL 5.1 “GA” quality was much better than MySQL 5.0 quality when it was released. Though the question remains, was MySQL 5.1 release as…. Here is actually there another challenge comes from – MySQL does not make a difference between which release is recommended (offered by default…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…0.8 comes with many nice features: Works with MySQL 5.1 and MariaDB 5.1…different data centers. This provides a HA solution for MySQL setups in the Cloud. E.g. with current state of MySQL…
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
… MySQL installation, or a new one. The answer is different for …MySQL 5.6. For older applications running MySQL 5.0, I’d say upgrade to 5.5 directly, skipping over 5.1. MySQL 5.0…5.5. Everyone on 5.0 just needs to be upgrading, even super-conservative companies. For applications running MySQL 5.1…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent, though we do not think results will differ…. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6% slower with 8…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…0.0 0.0 0.0 0.0 0.0 2.5 0% 0 23.2 sdi2 0.0 0.0 0.0 0.0 0.0 2.0 0% 0 23.2 sdj5 0.0 0.0 0.0 0.0 0.0 1.0 0% 0 23.2 sdi4 0.0 0.0 0.0 0.1 0.0 2.2 1% 0 23.2 sdi3 0.0 0.0 0.0 0.1 0.0 2.5 1% 0 23.2 sdj3 0.0 0.0 0.0 0.1 0.0…
