Database activity monitoring (DAM) : Configuring target database monitoring : Configuring MySQL monitoring
Configuring MySQL monitoring
FortiDB uses the MySQL general log to collect audit information from DB2 databases.
To configure auditing for a MySQL database
To change the polling frequency for monitoring, first stop monitoring. You cannot change this setting while FortiDB is monitoring the target database.
1. Ensure the required database pre-configuration is complete.See “MySQL target database pre-configuration”.
2. In the navigation menu, click DB Activity Monitoring > Monitoring Management, and then click the name of the target that connects to the database you want to monitor.
3. On the General tab, complete the following settings:
Collection Method
Select General Log.
To change the collection method, first stop monitoring, change the collection method, then restart monitoring.
Polling Frequency (ms)
Enter the polling frequency for audit collection, in seconds.
To change the polling frequency later, stop monitoring, change the value, and then re-start monitoring.
4. Click Test to confirm the connection with the method you selected.
5. Under Monitoring, click Start Monitoring.
For more information about monitoring, see “Monitoring settings and messages”.
See also
Target monitoring configuration tabs and options
MySQL target database pre-configuration