… heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed… see it is quite possible to make the same for Postgres. So MySQL-Postgres cluster setup is not so far ahead 
On “Company…
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
Comment: MySQL wins C'T Database Contest
August 30, 2006 By 27 Comments
… these results when the postgre solution gets only 120 opm while mysql gets 3664 (even thou there are mysql results as low as… (in perl with mysql as backend) where it in the beginning (2-3 months ago) had a performance of below 50 posts… that to retrieve just one column from mysql over DBI/DBD there is a performance difference of 51,155 fetches for the…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 16, 2007 By 22 Comments
… “lower” characters ! Yes I often use this too, in MySQL and in Postgres, it is just one of the tricks of the… the way. Recently I had a huge search query (in Postgres) which was horrendously slow. It has various conditions like GPS… sort and limit the temp table and fetch it – I perform all my joins from the temp table (no freaky IN…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… 3x performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of the checkpointing rate? Postgres exposes… in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent… you’re scaling out you can get better performance by using couple of MySQL Servers on single node. You can make them…
Comment: Partially OpenSourced
April 21, 2008 By 21 Comments
… offer MySQL performance & tuning consulting for $100. That’s something different than a 3-day performance & tuning gig from MySQL for $6.000. As MySQL… need enterprise features from an open source database, look for Postgres or Ingres.
Comment: High Rate insertion with MySQL and Innodb
June 2, 2012 By 17 Comments
… –oltp-range-size=1 –num-threads=16 –mysql-db=test –mysql-user=root –db-driver=mysql run got no more than aprox. 1 core fully loaded on 8 cores cpu… even with tokudb (just performance was quite better) just moved to postgres and got ~100x better performance utilising all cores
Comment: Finding your MySQL High-Availability solution – The questions
October 18, 2009 By 36 Comments
… MySQL really the right decision? PostGIS is a mature solution that might well be ideal for a variety of reasons. HA Postgres… capacity can easily decrease performance. 2.8 Security. Most communication is in the clear. 2.9 The MySQL database does not replicate… performance can be less than ideal with NDB. This is just off the top of my head… *I recently passed the MySQL…
Comment: MySQL wins C'T Database Contest
August 31, 2006 By 27 Comments
… some tests several months ago, and Postgres _with transactions_ was about 15%..25% slower than MySQL w/o transactions. Informix with transaction… respect to the effort, I suggest MySQL team to shift their understanding of their server’s performance closer to reality. It’s said not to piss off anyone, but to make MySQL better, eventually.
Comment: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… on MySQL incoming/outgoing network io handling side. We need a more asynchronous behavior from client server comunication (something like Postgres do… this would make MySQL server use more eficiently its internal buffers, and heating up the caches, thus improving performance and efficiency. Any…
Comment: System size and Performance Optimization
March 1, 2007 By 2 Comments
… bit of performance is reducing size. Try to store the data as compact as possible. What I miss in MySQL for this…(columsn)) Today I have to hold create redundant columns in MySQL to hold soundex of columns to able to create the… create the indexes without creating the column. Oher RDMS like Postgres support this. What is your opinion on this? Would you…
