Follow

Troubleshooting: Display the commands MySQL is running

This article will help with determining the commands run by MySQL at the time the command is run.

Please download and unzip the attached file (showProcessList.sql) on the appropriate Traverse server. For this article, it is assumed that the file is available on c:\temp on windows and /tmp on Linux. If the file is available at a different path, please substitute the path below as appropriate.

Log into the Traverse server and run the following:

For Windows:

  • Open an elevated command prompt (using 'Run as administrator')
  • Navigate to C:\Temp (or the directory of your choosing where the script is unziped) and run
  • Note: TRAVERSE_HOME is the Traverse installation directory
  •  cd C:\Temp
    TRAVERSE_HOME\bin\dgedb.init.cmd admin dge < showProcessList.sql >> showProcessList.out
    
  • Upload the file showProcessList.out to the support ticket

For Linux:

  • Navigate to /tmp  (or the directory of your choosing where the script is unziped) and run
  • Note: TRAVERSE_HOME is the Traverse installation directory
  •  cd /tmp
    TRAVERSE_HOME/etc/dgedb.init admin dge < showProcessList.sql >> showProcessList.out
    
  • Upload the file showProcessList.out to the support ticket
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.