Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.
Kill the connection on the specified thread. Rolls back any query running on the thread.
KILL [CONNECTION | QUERY] thread_id
thread_id- ID of the thread to kill. Find by running
KILL CONNECTIONWill disconnect the client associated with
thread_id. This is the default.
KILL QUERYWill not disconnect the client associated with
thread_id. Instead, the client will receive an error.
memsql> KILL CONNECTION 3123; Query OK, 0 rows affected (0.00 sec)