after migration from mssql server (ms2000) to mysql query become very slow

[prakash gr]

Hi,

we recently migrated mssql server 2000 to mysql 5.1,

all queries performance were degrading, i used to get query o/p in 1 sec in mssql server but in mysql it is taking 300 seconds.

os version:ms server 2003 standard edition;3.5gb ram

some of the MySQL Server Instance Configuration File:


INNODB Specific options :


innodb_buffer_pool_size=1000M

innodb_log_buffer_size=4M

innodb_flush_log_at_trx_commit=2

nnodb_additional_mem_pool_size=7M

innodb_log_file_size=170M


innodb_thread_concurrency=10



really appreciated for anybody inputs.

thanks

Prakash