QUESTION:
How do I display the commands MySQL is currently running?
SOLUTION:
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