KB-1530 How to kill queries initiated from phpMyAdmin

Purpose

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

Instructions

1. Open a new tab in the phpMyAdmin interface.
2. Execute the following command from the SQL tab of phpMyAdmin: CALL AppianProcess.getMyProcessList();.
3. A list of processes belonging to the current user will be displayed. The 'Time' column will display how long a particular query has been running in the system in seconds. Copy the ID of the offending process that should be killed.
4. Kill the offending process using the process ID and kill process command, like so: kill "processID";.
5. If phpMyAdmin is unresponsive, create a case with Appian Technical Support.

Note: These instructions will only show the MySQL process that are started from within phpMyAdmin by the same user for that session. It will not show any hung up processes started from within Appian, such as those initiated via a!query() or the Query Database smart service, as well as processes that were started during a previous session.

Affected Versions

This article applies to Appian Cloud 18.1 and later.

Last Reviewed: May 2021