|
|
About a month ago, I published the results of MySQL 5.x performance with logging. The
results covered several versions, from 5.0.45 to 5.1.33.
Among the conclusions of the post was the consideration that
MySQL 5.0.x is faster than MySQL 5.1 in read only operations.
I hinted that better results may come for MySQL 5.1. When I
wrote that post I had, in fact, an ace up my sleeve, because
I had already benchmarked the performance of MySQL 5.4, using the same criteria shown
in my previous post. The results, as you can see from the
charts below, tell that you don't need to downgrade to 5.0 to
achieve the performance you want, but MySQL 5.4 may be the
right choice. |
| MySQL 5.1 + 5.4 read-only logging performance |
| MySQL 5.1 + 5.4 read-only logging performance |
| MySQL 5.0 read-only Logging performance |
| MySQL 5.0 read-only Logging performance |
| MySQL 5.1 + 5.4 binlog performance |
| MySQL 5.1 + 5.4 binlog performance |
| MySQL 5.0 binlog performance |
| MySQL 5.0 binlog performance |
A piece of trivia. On April 9, users of MySQL Sandbox may have
noticed that I left a clue of what was about to happen. Among the
accepted versions, you could see "5.3, 5.4. 5.5" :-)