We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.

Your Digital Commerce Experts
Nexcess Logo

How to show running MySQL queries from the CLI

September 11, 2019

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.

Jason Dobry