Re: Slow performance on create table from sql benchmark test

[Karl Weber]

Up to now I found out the following:
- with kernel-default in OpenSuse the performance is slightly better
- with Ubuntu 10.10 performance is slow too
- tested file creation with bonnie++ and it is faster as expected on new computer
- The most important: mutex performance tested with sysbench is 3 - 4 times slower than on the virtual machine; other tests with sysbench, like CPU, memory and threads are faster on new computer like expected.

So my conclusion is that:
1. mutex handling on default OpenSuse / Ubuntu distribution for multi core CPUs is not optimal
2. MySql CREATE TABLE intensively uses mutexes

So my new questions are:
- Can someone confirm 1. and if this is true, how to optimize mutex handling on Linux or what is the default way for multi core cpus?
- Can someone confirm 2.?

Kind regards

Karl