MySQL and AV

"Leigh Sharpe" <[email protected]>
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.