… 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… substantially faster than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3, which… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-…was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1…vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’…mid,id) ). Also please note the transaction produces 4 INSERTs and workload is very write intensive. …Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…). 12GB 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… stopped the MySQL 5.6 server, rebooted and verified again. Same issue. This was very different from MySQL 5.5.30, which performs significantly better on…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… state_id (state_id) ) ENGINE=MyISAM; 4) Dictionary table for cities_join:…) WHERE s.name=’Minnesota’ limit 10000,5 \G *************************** 1. row *************************** id: 1 select…VARCHAR show close performance, while join performance degraded dramatically. Here is why: mysql> explain…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there…-row but in batches reads. So let us see how perform 5.1 and 6.0 in cold mode (I dropped OS… KEY (li_shp_dt_idx) (full table scan will be performed in this case) then we got: 1 min 39.14…
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…) The peak performance for 5.0.32 is also much larger than for 5.0.20 – some 630 vs 540 tps. 4) The bad news…
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 vanilla MySQL, not Percona… overhead. 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…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we can…# Rows sent 7.15M 0 56.36k 4.19 0.99 360.95 0.99 …# Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k …to reach appropriate performance, what kind of hardware provides better balance of CPU vs IO …
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
MySQL 5.6.7 RC is there, so I decided to test how it performs in tpcc-mysql workload from both performance… stable results. So there it is with 2x4GB vs 2x8GB innodb logfiles. Obviously the result is quite … 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M server-id …
