Ühel kenal päeval, P, 2007-11-04 kell 13:02, kirjutas Greg Smith:
> On Sat, 3 Nov 2007, Stefan Kaltenbrunner wrote:
>
> > there is the various dbt workloads,sysbench, jans tpc-w implementation,
> > hell even pgbench
>
> The DBT workloads are good for simulating disk-bound operations, but I
> don't think they're sufficient by themselves for detecting performance
> regressions because of that. TPC-W might serve to better simulate when
> things are CPU-bound, that particular implementation felt a bit out of
> date when I tried using it and I think it could use a round of polishing.
To be really useful, we should always run general system monitoring
alongside DB test runs, so we can see, and also later look up, where the
bottleneck are.
At least CPU (system, user, io wait, ....), RAM and disk usage should be
monitored continuously alongside benchmark runs.
I guess we (Skype DB team) could help to set something up on test lab
machines as we have been doing it on production machines for a few
years.
---------------
Hannu