I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting … challenge” for which this tool was originally built is long over, but still the tool serves well for benchmark purposes. OK, let’s… the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… results, they’re available here: https://github.com/tsuna/sysbench-tools I understand you need the fixes in your kernel, and… newer versions or upgrade. At the time I ran the benchmark above, we were using Linux 2.6.32, as my…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…, but what I’ve always wanted is to have a benchmark tool that finds the system’s maximum usable capacity. It would… using the approach in my previous paragraph, and running many benchmarks at different numbers of threads until you find the workload…
Comment: Black-Box MySQL Performance Analysis with TCP Traffic
February 27, 2012 By 2 Comments
Baron Thanks for the white paper. I think this is definitely a useful tool to replicate prod load for benchmarking systems.
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
… up between successive requests (should be exponential, but not all tools actually get it right), and a navigation pattern chosen to… of persistent connection) – and there are even more in web benchmarking: how long does a user wait between switching web page…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
To answer your final question in the blog post, though, “yes, I find this useful.” This is a great step in the right direction. Typical benchmarks are just a square peg in a round hole, and the tools need to support something much more advanced and meaningful.
Post: SysBench - benchmark tool
August 18, 2006 By 18 Comments
…/ and I want to write a short intro about this tool as sysbench is one of software for my everyday use… and details so my goal is describe common usage of benchmark. Sysbench allows to test: file I/O performance scheduler performance… servers – I will write about in further notes. Regarding database benchmarks – in 0.4.7 and earlier versions Sysbench supported only…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…. The tool I used was sysbench 0.4.10 that came with this Ubuntu system. I have run every fileio benchmark and an IO bound read-write oltp benchmark in autocommit mode. File IO benchmark For the FileIO benchmark, I used… i.e. the improvement is still 23%. OLTP benchmark results From this benchmark, I only have two graphs to show you. First…
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
… a case for looking at NOSQL tools, and not meant to be a decision making tool. Each solution has pros and… this and I see almost 0 impact on my gaming benchmark from when this is running to when it is not…. Now while I did not see a drop in my benchmark, heavy write operations will see a drop in performance… for…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… challenges is that as we add richer features to the tool, we need equivalent testing capabilities. However, it seems a constant… something to be desired. The randgen is a literal wonder-tool for database testing, but it is also occasionally frustrating / doesn… randgen and this is required…hey, it is a WONDER-tool!) : ) * Innobackupex, a MySQL / Percona server and the appropriate xtrabackup binary…
