MySQL and Virus Checking Software

MySQL and Virus Checking Software
Using virus scanning software such as Norton/Symantec Anti-Virus on directories containing MySQL
data and temporary tables can cause issues, both in terms of the performance of MySQL and the
virus-scanning software mis-identifying the contents of the files as containing spam. This is because
of the fingerprinting mechanism used by the virus scanning software, and the way in which MySQL
rapidly updates different files, which may be identified as a potential security risk.
After installing MySQL Server, it is recommended that you disable virus scanning on the main
directory (datadir [487]) being used to store your MySQL table data. There is usually a system
built into the virus scanning software to permit certain directories to be specifically ignored during
virus scanning.
In addition, by default, MySQL creates temporary files in the standard Windows temporary directory.
To prevent the temporary files also being scanned, you should configure a separate temporary
directory for MySQL temporary files and add this to the virus scanning exclusion list. To do this, add
a configuration option for the tmpdir [460] parameter to your my.ini configuration file. For more
information, see Section 2.3.5.2, “Creating an Option File”.
... zobacz całą notatkę