…that InnoDB performance steadily declines from 24000 tps to 18000 tps, but InnoDB can’t make 5h run…also. And, if you want to repeat this benchmark, the sysbench code is on Launchpad lp:~vadim…myisam_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
… 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… KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions (TPS mode, see the original post on why…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… substantially better, coming in at an average of around 600 tps, but vCache is about 3x better. The interesting item here… think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
Andy, 1) The 1st benchmark is single SELECT queries (i.e. the –skip-trx option … to provide lower TPS values than the “QPS” mode. 2) There was no fix from Percona at the time MySQL bug #49169…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… there Benchmarking MariaDB-5.3.4 The initial benchmark is described in Benchmarks of Intel 320 SSD 600GB, and the result for MySQL 5… be different: MySQL: 3746 tps Percona Server: 3704 tps And for comparison, average throughput for 4 tables: MySQL: 3882 tps Percona Server: 6735 tps The Percona…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… on these same benchmarks in Tokyo tyrant. All to often people force themselves into using a database like MySQL with no thought… do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant… app increased almost 10Xby using memcached. The TPS I get here vary from 1100 TPS to just under 2000TPS with the average…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… Percona’s R900 machine. The scripts and results are on Benchmark Wiki and the relevant my.cnf settings were innodb_buffer… as to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important… along these lines (the patch can be found at the Benchmark Wiki with the rest of the scripts and results) and…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have… take these as variable parameters and run simple benchmark. I took sysbench update_key scenario ( update indexed…trx_commit = 0 maximal tps is 36332.02 tps, which drops to 23115.04 tps as we switch to…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… comment on it. I already wrote about interesting benchmarks Tweakers.net have done for MySQL and PostgreSQL with different CPUs. I was… number of CPUs (2x quad line) is significant – 350 tps vs 100 tps for 5.0.20. Great job ! 3) The peak…: By looking at this benchmark (it can be and will be different in other benchmarks) we can see MySQL scalability problem with high…
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… than memory in all of the servers I benchmarked). Here are the results: #Threads #TPS 8 319.47 16 496.63 32…, I ran another series of 60-second benchmarks, with the following thread counts: #Threads #TPS 1 44.26 2 78.66 4… not prepare publishable reports on all of the benchmarks I ran. While running the benchmarks, I gathered many gigabytes of performance and…
