MySQL Forums
Forum List  »  Performance

Slow performance on create table from sql benchmark test
Posted by: Karl Weber
Date: November 01, 2010 09:16AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Slow performance on create table from sql benchmark test
3454
November 01, 2010 09:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.