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.