8 messages in com.mysql.lists.win32Re: Terrible performance on Win 2003 ...
FromSent OnAttachments
rich15 Aug 2005 09:03 
Jeremy15 Aug 2005 09:09 
Jonathan G. Lampe15 Aug 2005 09:11 
Tim....@biomni.com15 Aug 2005 09:11 
rich15 Aug 2005 09:37 
Daniel da Veiga15 Aug 2005 10:00 
rich15 Aug 2005 10:13 
Tim....@biomni.com16 Aug 2005 01:46 
Subject:Re: Terrible performance on Win 2003 server with InnoDB
From:rich (ri@richgray.com)
Date:08/15/2005 09:37:35 AM
List:com.mysql.lists.win32

Hi Jeremy Thanks for your reply. The server is a dedicated DB server and there is no A/V running as far as I can tell however I will check with the sysadmin guy. The server is not running IIS. Running Task Manager shows the page file running at a steady 1.43Gb - showing the running processes has mysql-nt .exe at the top of the list with 84,400K of memory usage. The CPUs 2 x Intel Xeon 3.4Ghz are basically idle around 2% usage I guess. The sysadmin has verfied that the network link between the web server and this server is OK they are on a LAN connection... When you say permissions limit connections per second on the database? I have checked the Windows permissions and they seem OK but where do I find the connection limit on the database? Thanks again Rich

Jeremy wrote:

I doubt it's MySQL but it might be. I would start looking at the OS first. The biggest thing I can think of now is your Antivirus which could be scanning everything MySQL is doing.

What else do you have on this server? How much memory is free (2g is easy to use up with Microsoft Bloat like ISS and the like.) What is your CPU usage (when and when not accessing the database)? Have you checked for firewall settings, etc?

Finally, have you checked your permissions, etc on the database? I'd be particularly interested in the limit settings like the number of connections per second, etc.