Page 1 of 1

Slow ODBC connection on 2003 server

PostPosted: 30. November 2009 06:44
by Theoden
I have installed XAMPP on a Windows 2003 server. MySQL is working but it is very slow when using ODBC. A query on a 70,000 record table will require 3 seconds normally. When I query using ODBC, the same query takes 21 seconds. this is a very simple query:
select * from customer where last='spelvin';

This is a 2.66 GHz server with 4 GB of memory. I have turned off Apache and the mail server.

Does anyone here know how to troubleshoot this problem?

Thanks in advance.


Re: Slow ODBC connection on 2003 server

PostPosted: 12. December 2009 05:28
by Theoden
This problem has been solved. What did help were the following settings:
innodb_buffer_pool_size = 750M
innodb_additional_mem_pool_size = 250M
That got the speed back up to where it should be. My client is happy.

Adding skip-name-resolve did not help this server.

Note: I did add skip-name-resolve to my own (remotely hosted) server and it made a difference. The login time was reduced from 32 seconds to 12-15 seconds.

Submitted in the hope it will help someone else.