mysql_stat

( PHP 4 CVS only )

mysql_stat -- Get current system status

Description

string mysql_stat ( [resource link_identifier])

הערה: mysql_stat() הערה: mysql_stat() currently only returns status for uptime, threads, queries, open tables, flush tables and queries per second. For a complete list of other status variables you have to use the SHOW STATUS sql command .

דוגמה 1 . mysql_stat( ) example

 
?php

 
$link

 
=

 
mysql_connect(

 
'localhost'

 
,

 
"mysql_user"

 
,

 
"mysql_password")

 
;

 
printf("%s\n"

 
,

 
mysql_stat($link))

 
;

 
?



 
Uptime

 
:




 
5380

 
Threads

 
:




 
1

 
Questions

 
:




 
1321299

 
Slow

 
queries

 
:




 
1

 
Opens

 
:




 
26

 
Flush

 
tables

 
:




 
1

 
Open

 
tables

 
:




 
17

 
Queries

 
per

 
second

 
avg

 
:




 
245.595