… Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the… opposite is true when the database is hot. SSB Flight #3 Here in some cases MyISAM is substantially faster than InnoDB… always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more …comparison on a single-node (on the left) vs. two-node (on the right) configuration. No surprises… difference. We then compared results across all 3 boxes to see if different hardware has …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5.6 use the… Factor 1 – Mysql 5.5 vs 5.6 response times are in seconds (lower is better) Version Buffer Cold Run1 Run2 Run3 5.5.30 128M 361… | 0.000117 | 0.000000 | 0.001000 | 0 | 0 | 0 | 0 | 3 | 3 | | 8 | optimizing | 0.000048 | 0.000048 | 0.000000 | 0.000000…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as…lineitem | range | li_shp_dt_idx | li_shp_dt_idx | 3 | NULL | 8272067 | Using index condition; Using where; Using MRR | …
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… are any difference. Recently Tweakers.net published comparison of MySQL 5.0.20a vs 5.0.32bk as well as matching PostgreSQL 8.2… 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…) is significant – 350 tps vs 100 tps for 5.0.20. Great job ! 3) The peak performance for 5.0.32 is also much…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… of them use 5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4.1 was… would say no more than 5% of users use prepared statements. Bug Reporting and Tracking The MySQL 3.23 received quality was at some extent because there were no bugs.mysql.com – bugs were reported to bugs@lists.mysql…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…of MySQL process in 1/100 of the second. (This is pretty idle test system). So 347 and 5303 correspond to 3…31 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes 0 …performance, what kind of hardware provides better balance of CPU vs IO utilization as well as as simple as how …
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients …memory, 26 ECUs (8 virtual cores with 3.25 ECUs each), 64-bit platform, … happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t … and finer-grained samples, say, every 5 seconds instead of every minute, and …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…: MySQL 5.6 (2) is for MySQL 5.6 w/ buffer size 6M MariaDB 5.5 (2) is for MariaDB 5.5 w/ buffer size 6M MariaDB 5.5 (3) is for MariaDB 5.5 w… disk 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5.6 and…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… like to present a small benchmark which shows MySQL performance when you use 3 different approaches: ENUM, VARCHAR and tinyint (+joined table….id = c.state_id) WHERE s.name=’Minnesota’ limit 10000,5 \G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: s…
