mysqli_dump_debug_info()

The mysqli_dump_debug_info() function sends a command to the MySQL server to write detailed information about the current connection and its status into its system log (error log).

EXAMPLE

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

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

if ($connection) {
    // Send the command to output system information
    // NOTE: This function does not output anything directly to the screen.
    // It instructs the MySQL server to write a full report about the current 
    // memory state and active connections to its hidden system log (e.g., mysql_error.log).
    if (mysqli_dump_debug_info($connection)) {
        echo "Command sent successfully. Check the server system logs.";
    } else {
        echo "Error sending debug command.";
    }
    mysqli_close($connection);
}
?>

RESULT

The result will be displayed here...

Practical use: We do not use this function for regular work, but rather when system administrators need to check why issues are occurring on the server. You will not see the results in the browser. Test it at home like this:

The function returns true if the command was successfully sent to the server.
It is useful when troubleshooting memory issues or long-running queries on the server side.
To view the result, you must have access to your server's system log files (e.g., in the mysql/data/ folder).