Re: MySQL and AV
Daniel da Veiga <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> 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 > > Leigh Sharpe > Network Systems Engineer > Pacific Wireless > Ph 9584 8966 > Mob 0408 009 502 > email [email protected] > 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/[email protected]