- ibench.py - this implements the insert benchmark from Tokutek. It optionally runs concurrent query threads to simulate the load on a busy replica. This workload can generate a lot of IO for stress testing or to understand the limits of a storage engine.
- mstat.py - this collects performance data from iostat, vmstat and SHOW STATUS. A sample config file, mstat.ds, is also provided. It can be used to understand the load on a server during benchmarks or any other time you need to explain performance.
Friday, February 27, 2009
Code for benchmarking
I published some of the code I use for performance testing at code.google.com:
Subscribe to:
Post Comments (Atom)
Posts
i think that must exist a table or list of hardware/configuration - results for compare with our own results to know if we are on the right way based on applications like sysbench.
ReplyDeleteGreat code, I love python! Cheers.
ReplyDeleteResult comparison is especially hard in this case because not many people have run ibench and I have modified it. Hopefully people will publish numbers.
ReplyDeleteIs there some specific reason why you don't use the parameter substitution that is built into cursor.execute()? (in ibench.py)
ReplyDeleteNo. I will look at that soon. Thanks.
ReplyDelete