PHP MySQLi mysqli_kill() - Terminating a Process

mysqli_kill()

The mysqli_kill() function sends a request to the server to immediately terminate the MySQL thread specified by the processid parameter.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

if (mysqli_connect_errno()) {
    echo "Connection failed: " . mysqli_connect_error();
    exit();
}

// Get the ID of the current thread on the server
$thread_id = mysqli_thread_id($connection);

// Request the termination of this thread
// NOTE: The mysqli_kill() function instructs the server to immediately terminate a specific thread 
// (connection). In practice, this is used in system tools to stop dangerous or long-running queries 
// that could slow down or crash the entire database server.
$kill = mysqli_kill($connection, $thread_id);

if ($kill) {
    echo "Thread with ID " . $thread_id . " was successfully terminated.";
}

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This function is used in extreme cases when we want to stop long-running queries that are overloading the server. Each connection has its own unique thread ID, which is obtained using mysqli_thread_id().

Requires a valid process ID (thread) that we want to stop.

Useful for administrative tools and monitoring database load.

After the thread is terminated, the current connection will no longer work.