PHP mysql_stat() º¯Êý
¶¨ÒåºÍÓ÷¨
mysql_stat() º¯Êý·µ»Ø MySQL ·þÎñÆ÷µÄµ±Ç°ÏµÍ³×´Ì¬¡£
Èç¹û³É¹¦£¬Ôò¸Ãº¯Êý·µ»Ø×´Ì¬¡£Èç¹ûʧ°Ü£¬Ôò·µ»Ø false¡£
Óï·¨
mysql_stat(connection)
²ÎÊý | ÃèÊö |
---|---|
connection | ¿ÉÑ¡¡£¹æ¶¨ MySQL Á¬½Ó¡£Èç¹ûδָ¶¨£¬ÔòʹÓÃÉÏÒ»¸öÁ¬½Ó¡£ |
ÌáʾºÍ×¢ÊÍ
×¢ÊÍ£ºmysql_stat() Ŀǰֻ·µ»Ø uptime¡¢threads¡¢queries¡¢open tables¡¢flush tables ºÍ queries per second¡£ÒªµÃµ½ÆäËü״̬±äÁ¿µÄÍêÕûÁÐ±í£¬Ö»ÄÜʹÓà SQL ÃüÁî SHOW STATUS¡£
Àý×Ó
<?php
$con = mysql_connect("localhost", "hello", "321");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("test_db", $con);
echo mysql_stat();
?>
Êä³öÀàËÆ£º
Uptime: 99410 Threads: 1 Questions: 162 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 0 Queries per second avg: 0.002