Slow Query Log Tool

See Database Management Systems.

The slow query log tool is used to read the slow query log when troubleshooting slowness in Open Dental.

In the Open Dental application folder, double-click theSlowQueryLogTool folder, SlowQueryLogTool.exe.

If the SlowQueryLogTool folder isn't present, run the Setup.exe on the computer to insert it.

The slow query log tool is used by Open Dental support when Troubleshooting Slowness issues. Users should contact Open Dental support to determine if the log is needed for their office.

Slow Query Log Tool

Use the Slow Query Log Tool to review data from the slow query log. The log must be first be created. See below for details.

Log Info and Filters:

Grids:

Summary:

Query Information

Double-click a query from the Queries grid to view details.

Details in this window are informational only.

Create the Slow Query Log

To utilize the tool, first enable to Slow Query Log to gather data.

  1. Open the my.ini file.
  2. In the my.ini file, [mysqld] section, add the following 2 lines:

    slow_query_log=1

    long_query_time=2

  3. Save and close the my.ini file.
  4. Restart the MySQL service.
  5. The file is created in the mysql/data folder (named servername-slow.log).
  6. Continue using Open Dental as normal. The log tracks queries run during this usage time.
  7. When enough data is collected, move the file to the mysql/backups folder. If a backups folder does not already exist, create one.
  8. Enter the path of the mysql/backups folder to the File Path field (see above).
  9. Use the Slow Query Log Tool to examine the log for a recurring pattern of slow queries.

When the slow query log is no longer needed:

  1. In the my.ini file, remove the two lines added above.
  2. Restart the MySQL service.