Query Monitor

The Query Monitor window allows you to view query requests made to the MySQL database server as they execute in real-time.

In the Main Menu, click Help, Query Monitor.

This window can remain open in the background to allow monitoring during normal use of the program. Activity displayed is only from the instance of Open Dental from which it was launched. It does not allow you to monitor all queries being processed by the MySQL server.

Note:
  • The Query Monitor View permission is required to access the Query Monitor.
  • The Query Monitor is not available when using a Middle Tier connection.

Query Feed: Grid shows details on queries sent to the MySQL server.

Start: Click to begin monitoring queries.

Stop: Click to suspend monitoring queries.

Clear: Click to clear the Query Feed.

Log: Click to save a log of queries captured while monitoring. Monitoring must be stopped to use. Log file is saved to the QueryMonitorLogs folder in the OpenDentImages folder.

Query Details: Highlight an entry above to see complete details on the query submitted.

Copy: Copy contents of the Command window from Query Details.