How to show running MySQL queries from the CLI

How to show running MySQL queries from the CLI

ATTENTION: This method requires SSH access. Nexcess Classic (non-Cloud) clients must first enable SSH access and adjust their firewall settings in SiteWorx; Cloud accounts have SSH enabled by default.

  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 export and import MySQL tables via CLI/SSH
Added on Mon, Dec 17, 2018
How to truncate MySQL tables from the CLI
Added on Mon, Dec 17, 2018
How to import and export MySQL databases in Nexcess Cloud
Added on Mon, Dec 17, 2018
How to show running MySQL queries in SiteWorx
Added on Mon, Dec 17, 2018
How to import and export MySQL databases in SiteWorx
Added on Mon, Dec 31, 2018
What is phpMyAdmin?
Added on Mon, Dec 17, 2018
How to delete a MySQL database with SiteWorx
Added on Thu, Dec 20, 2018
How to change permissions for MySQL users
Added on Thu, Dec 20, 2018
How to show running MySQL queries in Nexcess Cloud
Added on Mon, Dec 17, 2018
How to truncate MySQL tables in SiteWorx
Added on Mon, Dec 17, 2018