… is long over, but still the tool serves well for benchmark purposes. OK, let’s start off with the configuration details… = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query… about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… 1-64 threads. The throughput: We are getting to the peak throughput at 8 threads. And response time: For 8 threads, we may…, and it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If you are interested more in SSD and MySQL questions – I…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… benchmark methodology I described in previous posts, so let me jump directly to results. First case is random write asynchronous 8 threads… interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…cards. It really makes sense to test it under MySQL workload, but before getting to that, let me …0.7, rev 107053 Following the format of previous benchmarks, first is random write async 16KB case. We can… that with 4 and 8 threads the pattern is less stable than with 32 threads. It is curios that I…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
…-test-mode=rndwr –max-time=18000 –max-requests=0 –num-threads=$numthreads –rand-init=on –file-num=64 –file-io-mode… getting to the peak throughput at 16-32 threads. And response time: For 16 threads, we may expect 0.96ms response time… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… benchmarks are lie, and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql, start N threads and… my working ideas: Benchmark starts N working threads, but they all are idle until asked to handle a request Benchmarks generates transactions with…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… get: ext4 4 threads: 120 MiB/sec xfs 4 threads: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the… I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… and Ovais are doing a lot of benchmarking of specific MariaDB 5.3 and MySQL 5.6 optimizer improvements, and both of… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… joins, faster subqueries, and elimination of useless tables in joins Thread pooling and a segmented key cache for improved scalability That…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
As you might have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30. It is… seen some claims by others in the MySQL community that MySQL 5.1 runs faster than MySQL 5.0. Guess what? They’re… see benchmark run with innodb_thread_concurrency=1000 – This is exactly the value which you should never use. The limit of 1000 threads…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… work on “High Performance MySQL, 3rd edition”, Baron asked me to compare different MySQL version in some simple benchmark, but on decent hardware… MySQL 5.0 grammar became much bigger because of storage procedures and triggers. And raw results, in tps (more is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1…
