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. |
- Ensure the required database pre-configuration is complete.See MySQL target database pre-configuration.
- 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.
- On the General tab, complete the following settings:
- Click Test to confirm the connection with the method you selected.
- Under Monitoring, click Start Monitoring.
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. |
For more information about monitoring, see Monitoring settings and messages.