Problems with the Windows version of XAMPP, questions, comments, and anything related.
by 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
-
Theoden
-
- Posts: 6
- Joined: 16. October 2009 20:33
by 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.
-
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 194 guests