Re: MySQL and AV - Les Stockton - com.mysql.lists.win32

4 messages in com.mysql.lists.win32Re: MySQL and AV

From	Sent On	Attachments
Les Stockton	10 Jan 2006 14:25
Leigh Sharpe	10 Jan 2006 14:25
Daniel da Veiga	10 Jan 2006 17:02
Erich Dollansky	10 Jan 2006 18:56

Subject:	Re: MySQL and AV
From:	Les Stockton (les....@gmail.com)
Date:	01/10/2006 02:25:15 PM
List:	com.mysql.lists.win32

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 <lsha...@pacificwireless.com.au> 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 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

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