June 19, 2013

Comment: Is MySQL 5.6 slower than MySQL 5.5?

Marc, I have now updated the language to state it is 5.5 being X% faster not 5.6 being X% slower as this is how math was done.

Comment: Is MySQL 5.6 slower than MySQL 5.5?

Marc, First about math. Might be wording is not aligned with this. What I …

Post: Announcing Percona Server 5.5.28-29.3

… Rows_examined instead. Bug fixed #721176 (Alexey Kopytov). Fixed unsigned math error in fsp_reserve_free_extents that in some specific…

Post: Quickly finding unused indexes (and estimating their size)

….  A page in Innodb is (usually) 16k, so some simple math here should help us know how much disk space an…

Comment: What CPU Architecture do you prefer for running MySQL In production

Strange math here! As of my vote it says Intel – 93% – 384 votes AMD – 16% -66 votes Sparc – 2% – 10 votes ARM/PPC – 1% 5 + 4 votes Total voters: 415 Though 469 votes have been cast

Post: Edge-case behavior of INSERT...ODKU

…’ve used in my demonstration table – INT UNSIGNED. Do the math. The maximum value for an auto-increment INT UNSIGNED is…

Post: Automation: A case for synchronous replication

Just yesterday I wrote about math of automatic failover today I’ll share my thoughts about …

Comment: The Math of Automated Failover

… failover as checks are run immediately. Importantly, thanks for the Math and surely these all posts have a lot of take…

Post: How to find MySQL queries worth optimizing ?

… it also a huge oversimplification. You can do such simple math only to the queries without aggregate functions/group by and…

Comment: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks

… transactions get larger you are dealing with the sort of math that Jim Gray described in “The Dangers of Replication and…