On Mon, 2004-06-14 at 23:36, datasmid@stripped wrote:
> > Two questions. Which Kernel did Fedora Core 2 run ? Also did you use
> > hardware or software mirror ?
> Linux fedora 2.6.5-1.358smp with hardware mirror
So you're mostly testing 2.6 kernel vs 2.4 not a big surprise.
> >> Conclusion: Fedora Core 2 shines brightly!!!
> > Well, It was twice as slow to run ATIS, big-tables, connect, wisconsin.
> > It was also slower at "select"
> > So results look more like "depends on the load".
> Well, we need the fastest inserts to record the financial markets, so if
> we improve total benchmark time with faster inserts we are happy.
Do not be mistaken by the name. "Insert" is not very well defining name.
There are a lot of things in this benchmarks other than just inserts.
If you take a look at insert operation itself:
insert (350768) | 36.00| 38.00| 66.00|
insert_duplicates (100000) | 8.00| 8.00| 15.00|
As you can see it can be significantly worse. It however also still
depends on number of keys you have and table size. Disk bound load is
whole different world.
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com