Quick look at Ubuntu 6.06

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

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

About the Author

Vadim Tkachenko
Vadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. Vadim leads Percona Labs, which focuses on technology research and performance evaluations of Percona’s and third-party products. Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. He also co-authored the book High Performance MySQL: Optimization, Backups, and Replication 3rd Edition.

2 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Dmitry

19 years ago

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 🙂 /*

0

Vadim Tkachenko

Author

19 years ago

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.

0