27.7.6.39 mysql_kill()
int mysql_kill(MYSQL *mysql, unsigned long pid)
As of MySQL 5.7.11, mysql_kill()
is deprecated and will be removed in a future version of MySQL. Instead, use mysql_query()
to execute a KILL
statement.
Asks the server to kill the thread specified by pid
.
This function is deprecated. Use mysql_query()
to issue an SQL KILL
statement instead.
mysql_kill()
cannot handle values larger than 32 bits, but to guard against killing the wrong thread returns an error in these cases:
If given an ID larger than 32 bits,
mysql_kill()
returns aCR_INVALID_CONN_HANDLE
error.After the server's internal thread ID counter reaches a value larger than 32 bits, it returns an
ER_DATA_OUT_OF_RANGE
error for anymysql_kill()
invocation andmysql_kill()
fails.
Commands were executed in an improper order.
The
pid
was larger than 32 bits.The MySQL server has gone away.
The connection to the server was lost during the query.
An unknown error occurred.
The server's internal thread ID counter has reached a value larger than 32 bits, at which point it rejects all
mysql_kill()
invocations.