Good afternoon,
I'm looking for information on good benchmarking implementations
with which to test MySQL using multiple clients. The benchmark
utilities included with MySQL are, as far as I understand, an
implementation of the old Wisconsin Benchmark, and as such are
designed to test only a single client sending queries to the database.
Are there any implementations of multiple client benchmarks (ie
TPC-C) that are freely available? There is one of TPC-W, but I'd
rather not use that. Or would I be better off simply modifying the
MySQL provided benchmark to incorporate the multiple client concept.
Changing the scripts so that they don't conflict when multiple clients
run is easy enough, but are there any large changes in general
methodology between the two types of test?
Thanks,
Rob
I'm looking for information on good benchmarking implementations
with which to test MySQL using multiple clients. The benchmark
utilities included with MySQL are, as far as I understand, an
implementation of the old Wisconsin Benchmark, and as such are
designed to test only a single client sending queries to the database.
Are there any implementations of multiple client benchmarks (ie
TPC-C) that are freely available? There is one of TPC-W, but I'd
rather not use that. Or would I be better off simply modifying the
MySQL provided benchmark to incorporate the multiple client concept.
Changing the scripts so that they don't conflict when multiple clients
run is easy enough, but are there any large changes in general
methodology between the two types of test?
Thanks,
Rob