MySQL Forums
Forum List  »  Oracle

after migration from mssql server (ms2000) to mysql query become very slow
Posted by: prakash gr
Date: March 23, 2009 04:32PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
after migration from mssql server (ms2000) to mysql query become very slow
3757
March 23, 2009 04:32PM


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.