… example if the 3364 opm mysql result was using memcached, how would the 120 opm postgre result be affected of such caching… postgre solution gets only 120 opm while mysql gets 3664 (even thou there are mysql results as low as 137 opm in this benchmark). I can just use a recent personal experience from the fulltext engine I am building (in perl with mysql as…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 13 Comments
… Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted…, and I am going to run my own benchmarks also. Also from benchmark you can see that communication overhead maybe significant for… see it is quite possible to make the same for Postgres. So MySQL-Postgres cluster setup is not so far ahead 
On “Company…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… plans to enable tuning of the checkpointing rate? Postgres exposes this data and allows the user to… HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN… is often not the option. Here are some benchmarks we did. Q24: INNODB has typically had problems…
Comment: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
I think what this benchmark really shows, though, is that you don’t have to … community support that MySQL has, and that is the one real advantage of MySQL. If you’re aware of how Postgres works, the choice to go with pgsql then becomes pretty clear, at least while MySQL…
