…old_blocks_time had an effect on performance of the benchmark. There was some discussion in the …=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…bound cases MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations and how to run benchmark: [mysqld…max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… performance, so we will need to measure that also. And, if you want to repeat this benchmark… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_…_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… tried to answer that question by retrying benchmarks on various combinations of hardware and dataset …the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but …2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… performance results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks…_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4…
Comment: Why MySQL Performance at Low Concurrency is Important
March 31, 2013 By 8 Comments
…/03/mysql-56-single-threaded-read-only.html. All of the conclusions assume a benchmark with fast (100 to 200 usecs) queries: * performance_schema overhead is too high for benchmarks * innodb_checksum_algorithm=CRC32 is a big win * 5.6 was ~9% slower for a cached database whether…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… to make sure caches were clean. OLTP benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… (here), I decide to verify and benchmark performance while varying the size of the sort…MySQL. For the benchmark, I used an old PII 350 MHz computer, I think for such CPU bound benchmarks…cache before the benchmark by doing “alter table sorttest engine=myisam;”. The script used for the benchmark…
Post: How fast can you sort data with MySQL ?
August 18, 2007 By 26 Comments
… table as I used for MySQL Group by Performance Tests to see how much MySQL can sort 1.000… in question was Pentium 4 having 1024K of cache. A while ago I already wrote what large…conditions. What do we learn from these results: Benchmark your application Unfortunately general tuning guidelines can be…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…. The Star Schema Benchmark (SSB) seems ideal for this. I wasn’t going to focus on the performance of individual queries in… tuning was done. The goal was to see how MySQL 5.6 performs out-of-the-box as compared to 5.5… 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times…
