Emergency

Quick look at Ubuntu 6.06



PREVIOUS POST
NEXT POST

There are a lot of talks around new coming Ubuntu 6.06, so I decided to make quick benchmarks.
I used sysbench 0.4.6 oltp-read-only workload with 1000000 rows against InnoDB and MyISAM tables.
Such workload is CPU-bound and allows to compare CPU / OS if we are using the same version of MySQL.
So I used MySQL 5.0.22 and my box Dual Core Athlon 3800+, 1Gb of RAM.
For comparison I tested the same workload on my primary Suse 10.0.

Here are results (in transactions per sec, more is better):

InnoDB
threadsUbuntu 6.06Suse 10.0Suse/ Ubuntu ratio
1478.66536.911.12
4870.50816.270.94
16582.57639.051.10
64522.04547.071.05
256344.30357.091.04
MyISAM
threadsUbuntu 6.06Suse 10.0Suse / Ubuntu ration
1466.13429.890.92
4765.19863.231.13
16509.32537.671.06
64495.97516.001.04
256339.01346.651.02

In general Suse 10.0 looks better, though the difference is not significant.

PREVIOUS POST
NEXT POST
Tags:

, , ,

Categories:
Benchmarks


Comments

  • I appologize for offtopic :) I tried sysbench with it’s oltp test – 1st time ran with 10 concurent threads on 10K record table (by default), 2nd time – 100 threads on 100M records, the result was only 30% slower 2nd time, how’s that colud be?
    /* original idea was to check the performance of myisam vs innodb :) /*

  • Vadim Post author

    I recommend to run sysbench in such mode, for CPU-bound (10K records):
    1. warmup ~3-5 min (–max-time=180 –max-requests=0)
    2. several runs by 1-2 min – and than take average or maximum result

    for 100M records you need much more warmup (about 15min) and longer runs – 5-10 min each.

    Comparison results on cold database makes no sense.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">