php 监控mysql数据库

<?php
// 数据库连接配置
$host = 'localhost';
$user = 'root';
$password = 'password';
$dbname = 'testdb';

// 连接数据库
$conn = new mysqli($host, $user, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 监控连接数
$sql = "SHOW STATUS LIKE 'Threads_connected'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$threads_connected = $row['Value'];
echo "当前连接数: " . $threads_connected . "\n";

// 监控响应时间
$sql = "SHOW GLOBAL STATUS LIKE 'Uptime'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$uptime = $row['Value'];
echo "数据库运行时间: " . $uptime . " 秒\n";

// 计算平均响应时间（假设每秒处理一个请求）
$avg_response_time = 1000 / $threads_connected;
echo "平均响应时间: " . $avg_response_time . " 毫秒\n";

$conn->close();
?>