SQL Interruption

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

MySQL provides the KILL QUERY command to interrupt a running query on the server, but the client program must open a second connection to execyte this 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.