* Re: [OSDL][BENCHMARK] OSDL-DBT-2 - 2.4 vs 2.5 4-way/8-way with vmstat
[not found] <20030131141350.370c287a.akpm@digeo.com>
@ 2003-01-31 22:47 ` Cliff White
2003-01-31 22:57 ` Andrew Morton
0 siblings, 1 reply; 4+ messages in thread
From: Cliff White @ 2003-01-31 22:47 UTC (permalink / raw)
To: Andrew Morton; +Cc: linux-kernel
> Cliff White <cliffw@osdl.org> wrote:
> >
> > http://www.osdl.org/projects/dbt2dev/results/8way/LKML2/data/296/vmstat.out
>
> That's progress, thanks.
>
> It is useful to show the collection interval of vmstat in the reports. Is
> that `vmstat 1' or `vmstat 1000'?
vmstat interval is 60 seconds, you are right, we'll fix the report.
>
> This workload appears to be performing concurrent disk reads and writes. If
> these are _really_ happening at the same time (ie: if vmstat hasn't confused
> me) then it could well be the case that the throughput improvement comes from
> the I/O scheduler's tendency to service reads more promptly when there is a
> lot of writeback happening.
Re concurrent IO:
The offical answer from the dba's: "Well, it tries"
There are multiple user proccessess doing queries and commits.
There should be a difference between the cached and non-cached runs, as
the cached runs should not be doing much writing, except to the log device.
Every 10 minutes in all workloads, the database flushes cache to the
datafiles,
which should produce a noticeable peak in activity.
These loads suck up all the memory they can, so anything that gives us more
free memory should
be goodness. We think we are also seeing improvements in 2.5 in free memory,
but
we don't know for sure where is best to look and how best to prove it.
Any advice?
>
> If so then you can expect to see wild swings in results as you wend your way
> through recent 2.5 kernels :(. I'm working on settling that all down.
> 2.5.59-mm7 should do well.
>
Hopefully we can get some results for you on that kernel.
cliffw
^ permalink raw reply [flat|nested] 4+ messages in thread
* [OSDL][BENCHMARK] OSDL-DBT-2 - 2.4 vs 2.5 4-way/8-way with vmstat
@ 2003-01-31 20:26 Cliff White
2003-01-31 21:29 ` Andrew Morton
0 siblings, 1 reply; 4+ messages in thread
From: Cliff White @ 2003-01-31 20:26 UTC (permalink / raw)
To: linux-kernel
As Andrew requested, we now have posted DBT-2 results with vmstat
data included for the 8-way workloads we reported previously.
Runs have been included from both the cached and non-cached variants
of the workload. The 8-way results used the same database cache
size setting (2656M).
In addition, we have results for DBT-2 running on STP for the cached workload
comparing 2.4.18 versus 2.5.54dcl (the Data Center Linux kernel). In these
runs we varied the database cache size setting (LM=2031MB, MM=2344MB,
HH=2656M).
Summary of results (Higher Metric is better)
CPUs OS Load Memory Metric (Avg)
---- --- ---- ------ ------------
8way 2.4 Cached HM--- 4475.45
8way 2.5 Cached HM--- 5063.5
% speedup 2.5vs2.4----- 13.1 <---
8way 2.4 NonCached HM 1414.18
8way 2.5 NonCached HM 1659.8
% speedup 2.5vs2.4----- 17.4 <---
4way 2.4 Cached LM----2784.4
4way 2.5 Cached LM----2941
% speedup 2.5vs2.4---- 5.62 <---
4way 2.4 Cached MM----2786.2
4way 2.5 Cached MM----2939.8
% speedup 2.5vs2.4----- 5.51 <---
4way 2.4 Cached HM----2786
4way 2.5 Cached HM----2947.2
% speedup 2.5vs2.4----- 5.79 <---
Here are some highlights/comments:
Both the 4 way runs and the 8-way runs show improvement going from
2.4 to 2.5. The improvement is larger for the 8-way run. We believe
the 2.5 4-way would have improved more if it had not hit a CPU wall.
Observe the plot of vmstat percent user data at :
http://www.osdl.org/projects/dbt2dev/results/STP_4way/us.html
From the data and the plots, you will notice a big change about
every 10 minutes. That is the time the database does a "savepoint".
It writes dirty pages to the database files. This happened in the
cached runs and the non-cached runs.
We welcome your comments on why we are seeing this improvement.
As, always we also welcome suggestions for improvement, and random complaints.
Regards,
Mary Edie Meredith
Mark Wong
Cliff White
OSDL Database Test 2 Project
Open Source Development Lab
www.osdl.org
Link information:
The overall results page for the DBT-2 project is at:
http://www.osdl.org/projects/dbt2dev/results
direct link to 4 way results page:
http://www.osdl.org/projects/dbt2dev/results/STP_4way/STP_4way_2.4v2.5.html
direct link to 8 way results page:
http://www.osdl.org/projects/dbt2dev/results/8way/LKML2/STP_8way_2.4v2.5.html
direct link to 8way results page
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2003-01-31 22:48 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
[not found] <20030131141350.370c287a.akpm@digeo.com>
2003-01-31 22:47 ` [OSDL][BENCHMARK] OSDL-DBT-2 - 2.4 vs 2.5 4-way/8-way with vmstat Cliff White
2003-01-31 22:57 ` Andrew Morton
2003-01-31 20:26 Cliff White
2003-01-31 21:29 ` Andrew Morton
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox