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: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… the kernel in use for all of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the… vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… comparison between vCache and FlashCache and also to conduct some benchmarks for the use case where the MySQL working set is… this series, wherein we’ll take a look at some benchmarks. There’s no razor-thin margin of victory for either…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… have received a large number of questions on why the benchmark results in both posts look rather different. We were curious… well, so we tried to answer that question by retrying benchmarks on various combinations of hardware and dataset sizes, including the…: First of all, we used a smaller dataset for this benchmarks round, since reportedly Dimitri was using 8 tables with 1M…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
…, and the numbers are indeed quite impressive. For reference, the benchmarks for this device were performed primarily on a Dell R720… is the same machine which was used in my previous benchmark run. A small handful of additional tests were also performed…
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…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… mysql started PHP script Zend framework libmemcached PECL module Zend_Cache_Backend_Libmemcached Here is the rough code for this benchmark: // Identical…(“key_$i”); } } $totalTimeFetch = $timer->stop(); $avgTimeFetch = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… in real life with low concurrency. When it comes to benchmarks I would love to see results published starting from concurrency… so we can see the full picture. In terms of benchmarks, Mark Callaghan published an example where 8 sysbench tables are… to compare apples to apples is 8. Running a comparable benchmark with concurrency of 1 and the same tool is not…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…: http://phptechnicalgroups.blogspot.co.il/2013/05/simple-mysql-and-php-prodcuts-and-cart.html create dynamic main menu and sub menu using php and mysql php CREATE TABLE `menu` ( `id` int(11) NOT NULL auto…
