…performance by 5-10%. Sequential write results were a bit more interesting. With WT (write-through) cache enabled, performance… the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an …{925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0 While …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Page: Presentations
May 3, 2006 By
… MySQL Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL 4.1 and 5.0, showing… 4.1, 5.0, 5.1 Open Source Forum 2005, Moscow, Russia Presentation speaks about new features in new MySQL Versions. Download Improving MySQL Performance with…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…Intel(R) Xeon(TM) CPU 3.40GHz. InfoBright (ICE) version: 5.1.14-log build number (revision)=IB_3.2_GA_5316…and InfoBright: 0.31s To group all results there is graph: Conclusions: This experiment was not really about InfoBright vs MonetDB …if you want to compare or get info about air performance.
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are…. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5.0 grammar became… is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596.01…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group …performance significantly. And the similar with writeback cache enabled thread trx=1, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1…2188.38 There is still performance difference binlogs vs no-binlogs, but it is…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… you’re planning to use replication to perform system optimization, it is also needed on other… the replication thread was busy replicating events vs staying idle. Note you can speak about …5.75k 124.25 # Bytes sen 1.94M 0 9.42k 1.67 0 110.38 0 # Killed 0 0 0 0 0 0 0 # Last errn 34.11M 0 1.55k 29.26 0…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… at MySQL 5.0 Benchmarks Whitepaper and guess which type is this ? You can also compare it to my MySQL Performance 5.0 vs 4.1 presentation to have some fun. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which… all cases. There are performance bugs, some of them as Innodb Scalability were known long before MySQL 5.0 was stable but were…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY…-5.1-falcon for Falcon (Please note this is a first release of Falcon and it is still in alpha stage and performance…. Run each query for 1, 4, 16, 64, 128, 256 concurrent threads. 3. For each thread perform a warm-up run (duration…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… any difference. Recently Tweakers.net published comparison of MySQL 5.0.20a vs 5.0.32bk as well as matching PostgreSQL 8.2 results Same… concurrency. The results for MySQL 5.0.20a vs 5.0.32bk are also extremely interesting: 1) For single CPU 5.0.32 is actually slower on high… vs 100 tps for 5.0.20. Great job ! 3) The peak performance for 5.0.32 is also much larger than for 5.0.20 – some 630 vs…
