… series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with… presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known… InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… this benchmark, can be found here. We decided to run this benchmark for MySQL Server 5.5.30, 5.6.11 and Percona Server 5.5.30… Server shows much better results Configurations and how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G…_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…that also. And, if you want to repeat this benchmark, the sysbench code is on Launchpad lp:~vadim-…_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/…max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock …
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… the next transaction. There are two aspects of this problem: 1) memory allocation is an costly operation and if memory allocator… test for glibc and jemalloc allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30 with glibc is limited first of all… by bad scalability of glibc malloc itself – jemalloc helps MySQL 5.5.30 to fix issues with malloc scalability but still scanning…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… 5.5.30-30.2 and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark… well, so we tried to answer that question by retrying benchmarks on various combinations of hardware and dataset sizes, including the…-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple-ranges=0 –oltp-sum-ranges=0 –oltp-order…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick benchmark, I ran some batches of…’ =>array( array( ‘host’ => ’192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend_Cache::factory(‘Core’, ‘Libmemcached…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1… vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel replication but these apply… starting from concurrency of 1 if possible so we can see the full picture. In terms of benchmarks, Mark Callaghan published an… compare apples to apples is 8. Running a comparable benchmark with concurrency of 1 and the same tool is not possible. Want…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
The link http://www.codership.com/en/content/benchmarking-write-scalability does not work anymore? I am running mysqlslap … on it that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave. I…-of-queries=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server-5.5.30-1.x86_64
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on … Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced… Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our …
