Re: Server returns query slower than desktop

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


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org