
| 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" :-)
0 comments:
Post a Comment