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

Comments

  1. Dmitry says

    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 :) /*

  2. Vadim says

    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 *