I’m not big fan on flow control functions like IF or CASE used in MySQL Queries as they are often abused… types of pages because they often have different performance profile. mysql> select count(*) cnt, avg(wtime) avw, sum(if(wtime>0… distinct pages which tends to have significantly lower cache hit rate.
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…that provides advanced functionality for MySQL. We have a team of dedicated MySQL developers working on the server…on the features is paid at a special rate for “internal work” (as opposed to working for… Where It All Begins Our open-source efforts flow from our company values. We believe that …
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
… Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted… after PPC 2009 there was available version mysql-galera-0.6, which had serious flow, to setup a new node you had… increasing amount of nodes you write to, your transaction rollback rate may increase, especially if you working on the same dataset…
