Did you see this when you are migrating from your lovely MySQL
5.1 to MySQL 5.5?
Oh, sorry, you remain attached to your pretty 4.1. Yes, I know,
MyISAM has become so important in your life…
Ok, seriously, I would like to share this little observation I
made recently when switching to MySQL 5.5 on one slave.
You can see below two graphs for the transactional activity,
there is exactly the same volume of update,
delete and insert queries :
MySQL 5.1
But the gray area represents the number of commit per
second.
I find that I have much more commit with MySQL 5.5,
why? …