Server returns query slower than desktop

--=======AVGMAIL-41E7D6310B9C=======
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C4FA55.91C49440"

------=_NextPart_000_0007_01C4FA55.91C49440
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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
------=_NextPart_000_0007_01C4FA55.91C49440
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">

Re: Server returns query slower than desktop

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
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
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
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

Re: Server returns query slower than desktop

Daniel da Veiga wrote:

> Packet
>fragmentation used to bother me too, but with some router and software
>configuration (packet sizes and TTL) it was fixed.
>
>
>
There's soemthing that has not come up often

any sugestions on size & ttl settings?



--
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

Re: Server returns query slower than desktop

Configuring Windows for fast TCP/IP performance is not simple, each
network has its own personal optimal config, there is an easy formula
to calculate the optimal window packet size for Windows operating
system... The problem for me was that the Windows default setting was
not the best for my network architeture (it happens a lot, the system
can't have defaults for every net config)... I changed it from 16 to
24.

Here you can find an easy way, described by Neil Carpenter...
http://blogs.msdn.com/neilcar/archive/2004/10/26/247886.aspx

You can use the information on this site:
http://www.psc.edu/networking/projects/tcptune/
to tune your settings.

There are lots of free software that allows you to change this
settings, do some research and you may get a 10 to 20% faster tcp/ip
performance.

PS: ALWAYS BACKUP YOUR CONFIG before doying any changes!

Best regards,

On Fri, 14 Jan 2005 10:19:49 -0500, matt_lists
wrote:
> Daniel da Veiga wrote:
>
> > Packet
> >fragmentation used to bother me too, but with some router and software
> >configuration (packet sizes and TTL) it was fixed.
> >
> >
> >
> There's soemthing that has not come up often
>
> any sugestions on size & ttl settings?
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
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