… than tables. Our performance engineering team ran a variety of benchmark scenarios with the feature disabled versus enabled. In brief, we… warmup, ran a benchmark for 900 seconds, collected a snapshot of system state, enabled userstats, repeated the warmup and benchmark, and captured… used tools such as the gperf heap profiler and /proc/pmap to help examine memory usage. The results? After running the benchmark…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… data files generated by tpcc benchmark with 100 warehouses. I tested 1, 2, 4 parallel threads for tools that support it and… ( 1,2,3 for qpress; -1 and -5 for other tools) The raw results are available here http://spreadsheets.google.com…
Post: Introducing tpce-like workload for MySQL
February 8, 2010 By 6 Comments
… single workload. That’s why we are looking into different benchmarks, and one of them is TPCE. Yasufumi made some efforts… public consideration. You can download it from our Lauchpad Percona-tools project, it’s bzr branch lp:~percona-dev/perconatools/tpcemysql… human words is: You can’t name results as “TPC Benchmark Results” You can’t compare results with results published on…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… speak highly of the random query generator as a testing tool and thought I would share a story that shows how… dynamite”. This is a very apt metaphor for how the tool works – it can be quite effective for stressing a server… hitting that particular bug, but we *were* practicing with new tools and playing with dynamite can be quite exhilarating ; ) parallel option…
Post: Performance Optimization and Six Sigma
June 7, 2010 By 6 Comments
… number of workloads. Look at the industry standard TPC-C benchmark for example – it defines the guidance for response time as… just two sigma in sigma notation. A lot of popular tools, including Sysbench and Maatkit also use 95% response time (probably… vendors would focus more on the performance stability in their benchmarks. Way too often you just see the Throughput number reported…
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… system and/or innodb can become very slow (Yasufumi’s benchmarks show this very well). After enabling adaptive flushing we see… should benchmark your particular systems and not blindly follow advice you read on the internet, and have good monitoring and trending tools…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… architectures in the future. So lets look at some scalability benchmarks, my server resources are rather limited but I thought I… is not the appropriate place for storing data. A tool like Tokyo Tyrant may not be for everyone or every… going to try and continue this series by exploring and benchmarking other NOSQL options and comparing them to database based solutions…
Post: Percona Welcomes Patrick Crews
October 3, 2011 By 2 Comments
…. His work has included use of a variety of testing tools such as the randgen (random query generator) project to which… completely rewritten replication system, drizzledump’s evolution to a migration tool, as well as creating a new pluggable testing system for…
Post: Is your MySQL Server Loaded ?
March 19, 2010 By 6 Comments
So you’re running the benchmark/stress test – how do you tell if MySQL server is …. Looking at Threads_running is a very simple and powerful tool to see whenever you’re really putting sustained load on…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… and we’re really glad to have such a nice tool as new InnoDB plugin which now proved its usefulness in…
