SQL Interruption

Informix®

With Informix, it is possible to interrupt a long running query if the SQL INTERRUPT ON option.

Oracle® MySQL and MariaDB

MySQL and MariaDB provides the KILL QUERY command to interrupt a running query on the server.

Note: The database client program must open a second connection to execute the KILL QUERY statement.

Solution

SQL interruption is supported with MySQL.

The database driver opens a second connection to the server and sends a KILL QUERY command, with the MySQL process id of the current connection.
Important: Opening a second connection does not work when using Unix sockets, connect to MySQL with a host name and TCP port.