Slow ODBC connection on 2003 server

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Slow ODBC connection on 2003 server

Postby Theoden » 30. November 2009 06:44

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.
buffer_pool_size=16
addl_mem_pool_size=2
log_file_size=5
log_buffer_size=8

Does anyone here know how to troubleshoot this problem?

Thanks in advance.

Bruce
User avatar
Theoden
 
Posts: 6
Joined: 16. October 2009 20:33

Re: Slow ODBC connection on 2003 server

Postby Theoden » 12. December 2009 05:28

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.
User avatar
Theoden
 
Posts: 6
Joined: 16. October 2009 20:33


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 41 guests