How does everyone handle antivirus's and file locking issues?
I've been fighting with our sysadmin for weeks, I insist that norton
should not touch our database files, innodb, myd, myi
now it does, and I see corrupt data, and norton will skip files because
it cant get a lock, I dont want to
You are correct. The AV scan should not happen unless the database is
shutdown or some kind of file locking contention could occur.
It should be possible in your OS to deny your AV access to the folders
that contain your database files. This may mean changing the user account
your AV runs