Re: MySQL and AV

------=_Part_12886_4837721.1136931938637
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Sounds logical. anti-virus software will also slow down newsreader
downloads if you're pulling a lot. It might be worth it to set the
anti-virus software to ignore MySQL, but some might consider that a no-no.

On 1/10/06, Leigh Sharpe wrote:
>
> Hi all,
> I have a perl app using MySQL which seems to be running a bit slow. On
> another site, discussing another problem, unrelated to MySQL, I saw a
> discussion about how anti-virus programs can slow down apps which do a lo=
t
> of file opening/closing because they examine each file as it is opened or
> closed. This prompted me to wonder if this could be the reason for my spe=
ed
> issues. I have about 750+ tables, most of which are being read or written=
to
> about every 30 seconds.
> Would anybody care to share their thoughts on the impact that antivirus
> programs might have on MySQL? Does it sound reasonable that resident
> protection will slow down the database server? Does MySQL actually keep
> files open or does it open and close them regularly? What anti-virus
> programs are known to cause/not cause problems?
>
>
> Regards,
> Leigh
>
> Leigh Sharpe
> Network Systems Engineer
> Pacific Wireless
> Ph 9584 8966
> Mob 0408 009 502
> email lsharpe@pacificwireless.com.au
> web www.pacificwireless.com.au
>
>


--
Les Stockton
3844 Cincinnati Avenue
Winchester, Ok 74421

-----
You do dat, you go to da box, you know, uh, two minutes by yourself, and yo=
u
feel shame, you know, and then you get free. ~Denis Lemieux

------=_Part_12886_4837721.1136931938637--

MySQL and AV

------=_NextPart_000_01A0_01C61690.FC4BB700
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all,
I have a perl app using MySQL which seems to be running a bit slow. On =
another site, discussing another problem, unrelated to MySQL, I saw a =
discussion about how anti-virus programs can slow down apps which do a =
lot of file opening/closing because they examine each file as it is =
opened or closed. This prompted me to wonder if this could be the reason =
for my speed issues. I have about 750+ tables, most of which are being =
read or written to about every 30 seconds.
Would anybody care to share their thoughts on the impact that antivirus =
programs might have on MySQL? Does it sound reasonable that resident =
protection will slow down the database server? Does MySQL actually keep =
files open or does it open and close them regularly? What anti-virus =
programs are known to cause/not cause problems?


Regards,
Leigh

Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph 9584 8966
Mob 0408 009 502
email lsharpe@pacificwireless.com.au
web www.pacificwireless.com.au

------=_NextPart_000_01A0_01C61690.FC4BB700--

Re: MySQL and AV

There was a discussion about that a few months ago here at the list,
check the archives. My personal experience is that AV software as well
as any other resident program that monitor disk/network access will
slow down apps that make use of this services, and making it ignore
(or trust as some AV programs say) that app makes it run faster.

But that should not be a problem if you have a fast system, and there
are many other stuff to check, disk fragmentation, unoptimized
settings. There is a lot of info about the way MySQL works at the
manual, along with lots of tips and hints on optimized settings for a
faster server.

On 1/10/06, Leigh Sharpe wrote:
> Hi all,
> I have a perl app using MySQL which seems to be running a bit slow. On a=
nother site, discussing another problem, unrelated to MySQL, I saw a discus=
sion about how anti-virus programs can slow down apps which do a lot of fil=
e opening/closing because they examine each file as it is opened or closed.=
This prompted me to wonder if this could be the reason for my speed issues=
.. I have about 750+ tables, most of which are being read or written to abou=
t every 30 seconds.
> Would anybody care to share their thoughts on the impact that antivirus p=
rograms might have on MySQL? Does it sound reasonable that resident protect=
ion will slow down the database server? Does MySQL actually keep files open=
or does it open and close them regularly? What anti-virus programs are kno=
wn to cause/not cause problems?
>
>
> Regards,
> Leigh
>
> Leigh Sharpe
> Network Systems Engineer
> Pacific Wireless
> Ph 9584 8966
> Mob 0408 009 502
> email lsharpe@pacificwireless.com.au
> web www.pacificwireless.com.au
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

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

Re: MySQL and AV

Hi,

Leigh Sharpe wrote:

> MySQL, I saw a discussion about how anti-virus programs can slow down
> apps which do a lot of file opening/closing because they examine each

we use X via SSH or TELNET and found to be caught in the same situation
as anti virus software has to check also the TCP/IP traffic.

I forgot the numbers, but the through-put loss was so substancial that
we do not use anti virus software on Windows clients anymore while they
are running as X workstations.

MySQL uses also TCP/IP for communication.

Erich

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