Usage Guide

Assume that the confpath configuration file directory has been initialized.

• Run the following command to start only the slow SQL diagnosis function and output the top 3 root causes (for details, see the description of the service subcommand):

  gs_dbmind service start -c confpath --only-run slow_query_diagnosis
  

• Run the following command to diagnose slow SQL statements in interactive mode:

  gs_dbmind component slow_query_diagnosis show -c confpath --query SQL --start-time timestamps0 --end-time timestamps1
  

• Run the following command to manually clear historical prediction results:

  gs_dbmind component slow_query_diagnosis clean -c confpath --retention-days DAYS
  

• Run the following command to stop the services that have been started:

  gs_dbmind service stop -c confpath