Ask the Community
Groups
Troubleshooting: Display the commands MySQL is running - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>QUESTION:</strong></p> <p>How do I display the commands MySQL is currently running?</p> <p><strong>SOLUTION:</strong></p> <p>This article will help with determining the commands run by MySQL at the time the command is run.</p> <p>Please download and unzip the attached file (showProcessList.sql) on the <span data-mce-mark="1">appropriate </span>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.</p> <p>Log into the Traverse server and run the following:</p> <p><strong>For Windows:</strong></p> <ul><li>Open an elevated command prompt (using 'Run as administrator')</li> <li>Navigate to C:\Temp (or the directory of your choosing where the script is unziped) and run</li> <li>Note: TRAVERSE_HOME is the Traverse installation directory</li> <li> <div> <pre class="code codeBlock" spellcheck="false" tabindex="0"> cd C:\Temp TRAVERSE_HOME\bin\dgedb.init.cmd admin dge < showProcessList.sql >> showProcessList.out </pre> </div> </li> <li>Upload the file showProcessList.out to the support ticket</li> </ul><p><strong>For Linux:</strong></p> <ul><li>Navigate to /tmp (or the directory of your choosing where the script is unziped) and run</li> <li>Note: TRAVERSE_HOME is the Traverse installation directory</li> <li> <div> <pre class="code codeBlock" spellcheck="false" tabindex="0"> cd /tmp TRAVERSE_HOME/etc/dgedb.init admin dge < showProcessList.sql >> showProcessList.out </pre> </div> </li> <li>Upload the file showProcessList.out to the support ticket</li> </ul> </article> </main>