MySQL Performance: MySQL => Poor performance on Intel Core 2 CPU

Poor performance on Intel Core 2 CPU [message #1045]

Sun, 08 April 2007 09:56

lapa
Messages: 3
Registered: April 2007
Location: Ukraine

Junior Member

Hi everybody!

I have following MySQL environments:

1. Developer - AMD Sempron based PCs
2. Developer - Intel Core 2 Duo based PCs
3. Server - 4 x Xeon

The performance on Intel machines in comparison with AMD's is poorer in times.

Restoration of 50 GB Database on AMD machine takes up to 30 seconds while on any Intel base PC it takes up to 15 minutes.

Xeon and Intel Core 2 Duo machines are highly loaded with IO (disk) operations while CPU remains almost untouched (3-4%, literally idle).

I've tried default configuration as well as custom tuning of my.ini - no luck.

Any ideas?

My current configuration (AS IS):

[client]
port=3306

[mysql]
default-character-set=utf8

[mysqld]
port=3306

basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
datadir="C:/Program Files/MySQL/MySQL Server 5.1/Data/"

default-character-set=utf8

default-storage-engine=INNODB

sql-mode=" STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTI ON "

max_connections=100

query_cache_size=50M

table_cache=512

tmp_table_size=50M

thread_cache_size=8

#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=16M
key_buffer_size=9M
read_buffer_size=64K
read_rnd_buffer_size=256K

sort_buffer_size=256K

#*** INNODB Specific options ***
innodb_additional_mem_pool_size=200M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=10M
innodb_buffer_pool_size=512M
innodb_log_file_size=16M
innodb_thread_concurrency=8

[Updated on: Sun, 08 April 2007 10:01]

Report message to a moderator