PHP: mysqli::stat - Manual (original) (raw)

mysqli_stat

(PHP 5, PHP 7, PHP 8)

mysqli::stat -- mysqli_stat — Gets the current system status

Description

Object-oriented style

Return Values

A string describing the server status. [false](reserved.constants.php#constant.false) if an error occurred.

Examples

Example #1 mysqli::stat() example

Object-oriented style

`<?php

mysqli_report

(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); mysqli=newmysqli("localhost","myuser","mypassword","world");printf("Systemstatus:mysqli = new mysqli("localhost", "my_user", "my_password", "world");printf("System status: %s\n", mysqli=newmysqli("localhost","myu​ser","myp​assword","world");printf("Systemstatus:mysqli->stat());`

Procedural style

`<?php

mysqli_report

(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); link=mysqliconnect("localhost","myuser","mypassword","world");printf("Systemstatus:link = mysqli_connect("localhost", "my_user", "my_password", "world");printf("System status: %s\n", mysqli_stat(link=mysqlic​onnect("localhost","myu​ser","myp​assword","world");printf("Systemstatus:link));`

The above examples will output:

System status: Uptime: 272 Threads: 1 Questions: 5340 Slow queries: 0 Opens: 13 Flush tables: 1 Open tables: 0 Queries per second avg: 19.632 Memory in use: 8496K Max memory used: 8560K

Found A Problem?

amosjohlong at hotmail dot com ¶

9 years ago

Here is an explanation of the values that appear in connection->stat() returned string. It was taken from Ai Hua's April 29, 2006 answer on http://forums.mysql.com/read.php?12,86570,86570.

Uptime--The number of seconds the MySQL server has been running. 

Threads--The number of active threads (clients). 

Questions--The number of questions (queries) from clients since the server was started. 

Slow queries--The number of queries that have taken more than long_query_time seconds. 

Opens--The number of tables the server has opened. 

Flush tables--The number of flush-*, refresh, and reload commands the server has executed. 

Open tables--The number of tables that currently are open. 

Queries per second avg--Questions divided by Uptime