Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

We just moved our database from an old server to a new one with more processing power and 4G RAM. However, for some unknown reason, the execution of our store procedures became even slower. An additional symptom I have encountered is error 2013 from the server. The tables are innodb server version: 5.0.45-community-nt. I found a post stating that these are important parameters for the database so i compared them to the old server and they are the same.

key_buffer_size:8388608

innodb_buffer_pool_size:1071644672

innodb_additional_mem_pool_size:23068672

innodb_log_file_size:535822336

innodb_log_buffer_size:11534336

innodb_flush_log_at_trx_commit:1

table_open_cache:256

thread_cache:8

query_cache_size:0

Any help pointing me to where to look for the problem will be appreciated. Any additional information will be given on request.

share|improve this question
Is the new server on a physical or a Virtual Machine? – ypercube Jun 25 '12 at 12:32
it is a totally new server and not a virtual machine. – raven Jun 25 '12 at 12:48
How did you moved the database. Did you exported the mysqldump and restored in new server or a binary rebuild ?? – Gopinath Jun 25 '12 at 13:27
i used mysqldump. – raven Jun 25 '12 at 13:33
anyone has any ideas?? – raven Jun 27 '12 at 10:47
show 1 more comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.