… In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings …slower in the hot (cached) run. I did some investigation during the testing and found that InnoDB does more IO than… MyISAM is substantially faster than InnoDB both cold and hot. SSB Flight #4 There is one …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… #4) There are _no_ parallel queries (within a single connection) anywhere in any ‘free’ variant of MySQL. … shallower than the non-partition equivalent. Even single-row writes are likely to be slower in … at worst, hit the disk only 5 times. (Usually 4 of the 5 are cached from previous queries.) (Re …
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6% slower with 8… error. This tells us there are some workloads when MySQL 5.1 is slower than 5.0, and same applies to the new Innodb code…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10. This…_note key: role_id_note key_len: 4 ref: const rows: 10259274 Extra: Using index…slower? It seems that whenever the covering index technique is available, this is always preferred over the ICP optimization: mysql…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… memory 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response… above, MySQL 5.6 outperformed MySQL 5.5.30 with the big buffer pool. Why is the MySQL 5.6.10 with default settings test significantly slower than MySQL 5.5.30…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled during these benchmark runs and that the disks are 4 5…MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL 5…queries are just a bit slower as compared to MySQL 5.5 MRR clearly changes …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “fits… MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… – Upgrade of MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues than 5.0.30 to 5.0.86. The… you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1 just because so… ? In this case you may need to take it much slower checking your progress along the way. There is no limit…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… least not in the form they are currently implemented in MySQL 5.0 Only SQL as a Language Which is ancient ugly… helper Debug Storage Procedure which will log some information in MySQL table but it is not convenient enough. Bad Parser Error… help to Improve MySQL Performance. For DBT2 benchmarks we’ve tried a while back MySQL 5.0 was about 10% slower than 4.1 without stored…
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… see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is faster were selected and bunch of other benchmarks which show 5.0 is actually slower than 4.1 were…
