…_old_blocks_time had an effect on performance of the benchmark. There was some discussion in the comments and I promised… presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known…. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I will make a follow-up post…
Comment: MySQL 5.6.7-RC in tpcc-mysql benchmark
June 3, 2013 By 22 Comments
Hy, I’m new to TPC-C benchmarking and i would like to know how and what are the steps for testing MySQL with TPC-C benchmark. My goal is to compare VoltDB and MySQL under TPC-C benchmark. Thanks
Comment: Percona Server 5.6.11-60.3 first Release Candidate now available
June 5, 2013 By 3 Comments
Hi, do you have any plans on doing benchmark between Percona 5.5 and 5.6 ? Best Regards
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… use gzip compression. LZ4 is the best right now with benchmarks showing up to 50% more performance than even lzjb. With…
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… gzip-6. I may have found the main performance bottleneck (benchmark in progress), if I am right, I’ll write another…
Comment: ZFS on Linux and MySQL
May 27, 2013 By 17 Comments
… nice if btrfs (from 3.9) and zfsonlinux (latest) are benchmarked. c) Regarding integrity, XFS from 3.10 is going to…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
… around 100Million rows using Tokutek’s iibench.py for the benchmark on a 2-way Supermicro server with 2 Xeon X5650…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
Around month ago Facebook has announced the Linkbench benchmark that models the social graph OLTP workload. Sources, along with … how to setup and run this benchmark, can be found here. We decided to run this benchmark for MySQL Server 5.5… Server shows much better results Configurations and how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… measure that also. And, if you want to repeat this benchmark, the sysbench code is on Launchpad lp:~vadim-tk/sysbench…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… take a look at the following benchmark: This is the so-called QPS-mode POINT_SELECT benchmark, i.e. all queries are… does not kick in. The default sysbench POINT_SELECT mode benchmark does PK lookup SELECT queries wrapped into regular (i.e… Server’s scalability is the same as in the previous benchmark. The overhead of maintaining the descriptors array is negligible as…
