DRAFT KB-XXXX How to kill processes initiated from phpMyAdmin

Purpose

Long running queries initiated from phpMyAdmin may cause database performance issues. To kill the offending query, follow the steps below.

Instructions

1. Execute the following command from phpMyAdmin: CALL AppianProcess.list();.
2. A list of processes belonging to the current user will be displayed. Kill the process using the process ID and kill process command like so: kill "processID";.
3. If phpMyAdmin is unresponsive, create a case with Appian Technical Support.

Note: This will only show the MySQL process that are started from within phpMyAdmin by the same user. 

Affected Versions

This article applies to Appian Cloud 18.1 and later.

Last Reviewed: February 2018