Overview

A straightforward way to monitor the database is to use the MySQL command processlist . This command can be executed from the command-line, either from within the client database application itself or using the mysqladmin program.

Environment

Northplains > Xinet

Requirements

• Remote access to the Xinet Server
• Admin access to the Xinet Server

Process

• Check what mysqld is processing by using the mysqladmin command:

  /usr/etc/venture/bin/mysqladmin -u root -p processlist

  

• Get more detailed list from within the MySQL client by following the below steps:

  1. Log in to the MySQL console.

  2. Select webnative database by entering the command:

     • use webnative

  3. Run the processlist query by entering the command:

     • show processlist

       
  4. For additional details, run the command: show full processlist.