Contact
Site: US UK AU |

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.