…Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10,…performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance…to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… and run this benchmark, can be found here. We decided to run this benchmark for MySQL Server 5.5.30, 5.6.11 and…-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations and how to run benchmark: [mysqld…=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…MySQL Sunny Bains, Senior Principal Software Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks… for MariaDB for Monty Program Topic: “MariaDB 10.0 & What’s New With the Project” Sergei Petrunia,…
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 … two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected….[mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…. Accepted values are in the range [0, 255] (inclusive). Quorum is computed using …from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in…dependencies that were causing conflicts in CentOS 6.3 during installation. Bug fixed #1031427 (Ignacio…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… is the filesystem, and CentOS 6.4 the operating system, …performance results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks…= 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = …
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
…. For reference, the benchmarks for this device were performed primarily on a…performed using the Cisco UCS C250. The operating system in use was CentOS 6…, we reach peak performance with latency of roughly 0.5 milliseconds; and… 3ms. How well does it perform with MySQL? Exact results vary, depending …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… those presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There is a… Release and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I expected drastically better…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… I played 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… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice * l… but in batches reads. So let us see how perform 5.1 and 6.0 in cold mode (I dropped OS caches by…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…benchmarks comparing different MySQL versions in terms of their CPU…MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6…some workloads when MySQL 5.1 is slower than 5.0, and same … uses more CPU while delivering better performance so it is probably better …
