June 19, 2013

Post: Beware: ext3 and sync-binlog do not play well together

MySQL having extremely poor performance when sync-binlog=1 is enabled, even though thethe load is binlog fsync bound) but we surely do not expect it to drop ether. To ensure this is not RAID controller related we repeated the run on the in memory… reason is – it only happens with high transaction …

Comment: Interesting MySQL and PostgreSQL Benchmarks

is small for large databases (and small fit in memoryhigh concurrency level – I agree with you it is extremely bad, I’m just explaining why people still build scalable applications with MySQLMySQL which allow you to do just that. In the benchmarks these were not set to best values for this load