… 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 Handler_mrr_init N/A 0 0 1 1 Handler… plan is not used, there is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area of improvement in…
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… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…t VALUES(31); Query OK, 1 row affected (0.00 sec) After …1. Disables the gap locks except for foreign-key constraint checking or duplicate-key checking. The most important difference between…different. In the following link there is a good source of information: http://dev.mysql.com/doc/refman/5.1…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in… rate (which can be different in the different part of day/week/month…(in sec) between events: 0.61, 0.43, 1.55, 0.18, 0.01, 0.76, 0.09, 1.26, … …is far from being strict 0.5 sec, but 0.5 is the mean of this…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as… ‘1‘ year AND l_discount BETWEEN 0.09 – 0.01 AND 0.09 + 0.01 AND l_quantity < 24; with execution plain (in 5.1)…5.1 – time 1 hour 14 min 36.90 sec 6.0 – time 1 hour 6 min 2.21 sec So difference…
Post: MySQL 5.1 went to GA. Was it a good move ?
December 10, 2008 By 4 Comments
… 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 for…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… to different major version, especially if you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1… one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with no…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… on the same graph to show the relationship between them. Checkpoint age is shown by the red …set innodb_doublewrite=0. Now, although throughput is not a perfect line, we see a totally different picture for … NOTPM. This is 1.4x better than we have with the stable line in MySQL 5.5.8. But, finally, …
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…_pages=0 innodb_adaptive_checkpoint=keep_average innodb_read_ahead=none For MySQL 5.5.8,… graph shows the difference between different settings of innodb_io_capacity for MySQL 5.5.8. Small innodb…1.29x 52GB: MySQL 5.5.8 – 71,774 NOTPM, Percona Server – 88,792 NOTPM, advantage: 1.23x 144GB: MySQL 5.5…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… up with load. Between the time I sampled…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…three orders of magnitude different. I don’t …
