User guide

Table Of Contents
90
McAfee
®
Quarantine Manager
6.0 User Guide Frequently Asked Questions
15
Which versions of McAfee Quarantine Manager can be upgraded or migrated to
this version?
You can migrate from version 4.1 Patch 1, 4.1.1, and 5.0 Patch 1 to this version. See
Migrating the database to version 6.0 on page 10.
How long does it take to convert data from MySQL database to Microsoft SQL
server database?
It takes approximately one hour to convert 45GB data. See Converting the database on
page 84.
When should I reassign users?
Reassign users if a user is leaving the organization or the user account is being deleted
from the LDAP server. See Reassigning users on page 81.
How do I optimize or shrink the MySQL database?
Currently the
Optimization feature is not provided in this version of McAfee Quarantine
Manager. However if you want to optimize the database, follow the steps given below:
a From the command prompt, go to the
bin directory of MySQL installation folder.
b Execute the following command to log on to the MySQL database:
mysql --user=<database user name> --password=<database password>
<database name>
For example:
mysql --user=scott --password=tiger mqm
where the database user name is scott, password is tiger and the database is mqm.
c Execute the following command to optimize the database:
call pOptimize();
d Once the optimization is complete the MySQL prompt appears.
e Execute the following command to exit the MySQL database:
quit
How do I fine tune my MySQL database to improve the performance of McAfee
Quarantine Manager?
a Go to the <
MySQL> installation folder and edit the my.ini file.
b Modify the following parameters with the values specified below:
Innodb_buffer_pool_size = 1G
Innodb_Log_File_Size = 512M
Innodb_Thread_Concurrency = 512
c From the services console, restart the MySQL for McAfee Quarantine Manager service.
How do I fine tune my Microsoft SQL Server 2005 database to improve the
performance of McAfee Quarantine Manager?
a Open
SQL Server Management Studio.
b Right-click the database
mqm and click Properties.