… In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings … Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is… to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each…’s look at some numbers. vCache vs. vCache – MySQL parameter testing The first test was …bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…wanted to compare InnoDB performance vs TokuDB. I have a…-decreasing ID $K=rand(0,10000) // distributed by pareto …is why I also show 5-minute moving averages to …myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql…
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 is a…’ + interval ‘1‘ year AND l_discount BETWEEN 0.09 – 0.01 AND 0.09 + 0.01 AND l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id…_receiptdate`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 with 59986052 rows So this query takes 32.27 sec to execute in 5.1, and 39…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes…MyISAM because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as MySQL 5…=on,use_index_extensions=on 1 row in set (0.00 sec) Summary: MySQL 5.6 comes with quite a …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…and it can’t be because we used MyISAM tables which are not ACID complaint. Plus …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… his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We can see MySQL capabilities…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0…results. So there it is with 2x4GB vs 2x8GB innodb logfiles. Obviously the result …= 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover …
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…MySQL Optimizer Bug 
But now lets see in the difference of behavior of ANALYZE TABLE for MyISAM vs… | antest_innodb | 1 | i | 1 | i | …MySQL version note: This is from MySQL 5.0…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket…= 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover skip… difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is …
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
…MySQL) so do not just compare it directly. It also does not mention if Innodb or MyISAM…MySQL 4.1 actually scaled pretty well with Niagra, suffering slow regression with increased concurrency rather than quick drop. In MySQL 5.0… Linux vs Solaris comparison is also pretty interesting. With MySQL …
