mysql_kill - Kills a connection
-
#include <mysql.h>
int mysql_kill(MYSQL * mysql,
unsigned long);
This function is used to ask the server to kill a MariaDB thread
specified by the processid parameter. This value must be retrieved by
[show-processlist()](SHOW PROCESSLIST]]. If trying to kill the own
connection mysql_thread_id(3) should be used.
- •
- mysql - a connection identifier, which was
previously allocated by mysql_init(3) and connected by
mysql_real_connect(3). Returns 0 on success, otherwise
nonzero.
- •
- long - process id
- •
- To stop a running command without killing the connection use
KILL QUERY.
- •
- The mysql_kill() function only kills a connection,
it doesn’t free any memory - this must be done explicitly by
calling mysql_close(3).
Returns zero on success, non zero on error.
- •
- mysql_thread_id(3)
- •
- mysql_close(3)
- •
- mariadb_cancel(3)