How to show running MySQL queries from the CLI

This method requires SSH access. Nexcess clients on physical (non-cloud) servers 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 your Client Portal.