Re: Server returns query slower than desktop - Daniel da Veiga - com.mysql.lists.win32

5 messages in com.mysql.lists.win32Re: Server returns query slower than ...

From	Sent On	Attachments
Greg Quinn	14 Jan 2005 06:24
matt_lists	14 Jan 2005 06:31
Daniel da Veiga	14 Jan 2005 06:56
matt_lists	14 Jan 2005 07:19
Daniel da Veiga	14 Jan 2005 07:41

Subject:	Re: Server returns query slower than desktop
From:	Daniel da Veiga (dani...@gmail.com)
Date:	01/14/2005 06:56:54 AM
List:	com.mysql.lists.win32

You can keep the machine serving updates and definitions, but its adviced to mantain a server kinda hidden and alone (not allowing web browsing, downloads or remote connections FROM it), a firewall is good, if you can put a software firewall or a router, even better, this way, you can disable the virus protections from the software, because this service deals with every aspect, as Matt said (memory, disks, access, network), slowing down your server response times (specially with a resource demanding app like a database server).

About your server problem, I had the same problem here (slow response times), its was due to Windows firewalling keeping the server from respond to some special packets used by ODBC, that slowed down it by 200%, another stuff that use to take 25% of the speed was A LOT of unused network protocols mantained by Windows for unknown reason (this one I've found at the server and at some clients). Packet fragmentation used to bother me too, but with some router and software configuration (packet sizes and TTL) it was fixed.

Hope that helps,

On Fri, 14 Jan 2005 09:31:23 -0500, matt_lists <matt...@xotech-llc.com> wrote:

Greg Quinn wrote:

Hi,

For all who have been following my slow query dilemma, it looks like the problem is something on our server.

I copied the database from our server to my desktop development PC. Now with my PC as our software server, I logged into the user who has 7000 mail messages and his mailbox loaded in under 3 seconds.

I then did the same test, from our proper server, and the same query took 30 seconds, I did both tests local on each machine.

So it looks like something on our server is seriously slowing it down. Our server hard disk is fairly new, a 180Gb Seagate. With losts of space left. Our server is also a Norton AntiVirus Server, maybe the virus software is scanning the MYSQL data files as its being read?

Does anybody have any other ideas what could be slowing down the query on our server so much?

Our server is not really used for anything else that is intensive. It also serves about 20 mailboxes and a few quiet websites...

Thanks Greg

You probably should shut norton off on a database server

I found 2 problems with it, one it scanned the data files, easily excluded problem solved

2 it scanned memory, the only choice was turn off the memory scanning functionality, this cut our cycle time by 25 %

the box is firewalled off, so I'm not worried about it