Slow performance on create table from sql benchmark test

[Karl Weber]

Hallo!

I installed on a new Linux system (OpenSuse 11.3) the mysql community server 5.1.51 via YAST Software management and the sql benchmark. I did not change the mysql configuration file and the sql benchmark.
I did it once on a new machine described below and one in a VMWare virtual machine (host Windows XP) on an 3 year old machine with a slower hard disk than on the new machine.
The benchmarks are faster on the new machine like expected except for creation of tables, where they are 10 times slower than in the virtual machine. The essential output is following:

new machine:
create: Total time: 1434 wallclock secs ( 4.31 usr 2.31 sys + 0.00 cusr 0.00 csys = 6.62 CPU)

Virtual machine:
create: Total time: 117 wallclock secs ( 0.07 usr 5.00 sys + 0.00 cusr 0.00 csys = 5.07 CPU)

Can somebody tell me the reason for this and how to speed up the creation?

Thank you for your answer in advance!

PgmHelmi


Data of new computer:
---------------------

MySql Community Server 5.1.51
OpenSuse 11.3 32 Bit (Linux Kernel 2.6.34)

Mainboard: ASUS MA489GTD PRO / USB3
CPU: AMD Phenom II X4 965
2 Hard disks: 1 TB Western Digital WDC WD1002FAEX-00Z3A0
RAM: 4 GB

Following partition with parted -l:

Model: ATA WDC WD1002FAEX-0 (scsi)
Disk /dev/sda: 1000GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number Start End Size Type File system Flags
1 1049kB 206MB 204MB primary ext4 boot, type=83
2 206MB 8792MB 8587MB primary linux-swap(v1) type=82
3 8792MB 1000GB 991GB primary ext4 type=83


Model: ATA WDC WD1002FAEX-0 (scsi)
Disk /dev/sdb: 1000GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number Start End Size Type File system Flags
1 1049kB 1000GB 1000GB primary ext4 type=83