Contact
Site: US UK AU |

How to show running MySQL queries

How to show running MySQL queries

Overview
This article explains how to show running MySQL queries with either the phpMyAdmin control panel in SiteWorx or the CLI.

Method 1: Using phpMyAdmin

If you are a Nexcess client, you can use phpMyAdmin from your SiteWorx account to show running MySQL queries with the following procedure:

  1. Log in to your SiteWorx account.

    • If you do not know your password, click Forgot your password on the login page.
    • If you do not know the web address for your SiteWorx login page, either refer to your Welcome Email or contact our 24-hour Support Team for assistance.
  2. On the left, select Hosting Features > MySQL > PhpMyAdmin.

  1. Select the correct database from the list on the left.

  1. Click the SQL tab.

  1. In the Run SQL query/queries on database DATABASE_NAME field, enter the following:

    show full processlist;

  2. Click Go on the far right.

Method 2: Using the CLI 

This section outlines how to show running MySQL queries with the CLI:

Attention: If you are a Nexcess client and have not already enabled SSH access, first follow the instructions in How to enable SSH access.

  1. At the command line, type the following command, replacing <username> and the angled brackets with your username:

    mysql -u USERNAME -p

  2. At the Enter Password prompt, type your password and press Enter.
  3. Choose one of the below options below:
    • To view a horizontal list, enter: 

      show full processlist;

    • To view a vertical list with column names for each record, enter:

      show full processlist\G

  4. Enter quit when done.

External resources

For the complete MySQL documentation, refer to the MySQL development website.

For 24-hour assistance any day of the year, contact our Support Team by email or through the Client Portal.

Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
 
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to manage firewall whitelists in SiteWorx
Added on Wed, Nov 12, 2014
How to purchase a Wildcard SSL certificate
Added on Wed, Jan 14, 2015
How to add FTP accounts with SiteWorx
Added on Mon, Jun 11, 2018
How to resolve the SSL warning when logging in to SiteWorx
Added on Wed, Mar 11, 2015
What is SiteWorx?
Added on Thu, Aug 28, 2014
How to restore partial backups with SiteWorx
Added on Tue, Aug 6, 2013
How to use schedule automatic backups with SiteWorx
Added on Tue, Jul 30, 2013
How to view your bandwidth usage
Added on Wed, May 23, 2018
How to enable SSH access
Added on Tue, Jun 6, 2017
How to change email account passwords in SiteWorx
Added on Mon, Aug 5, 2013