PHPのお勉強！

PHP TOP
PHP 8.4.2 Released!

    mysqli::stat

    mysqli_stat

    (PHP 5, PHP 7, PHP 8)

    mysqli::stat -- mysqli_stat — 現在のシステム状態を取得する

    説明

    オブジェクト指向型

    public mysqli::stat(): string|false

    手続き型

    mysqli_stat(mysqli $mysql): string|false

    mysqli_stat() は、'mysqladmin status' コマンドが 返すのと同じ情報を返します。この中には、起動からの秒数・起動中の スレッドの数・リロード数および開かれているテーブルなどが含まれます。

    パラメータ

    link

    手続き型のみ: mysqli_connect() あるいは mysqli_init() が返す mysqliオブジェクト。

    戻り値

    サーバーの状態を示す文字列を返します。エラー時には false を返します。

    例

    例1 mysqli::stat() の例

    オブジェクト指向型

    <?php

    mysqli_report    (MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
    $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

    printf("System status: %s\n", $mysqli->stat());

    手続き型

    <?php

    mysqli_report    (MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
    $link = mysqli_connect("localhost", "my_user", "my_password", "world");

    printf("System status: %s\n", mysqli_stat($link));

    上の例の出力は以下となります。

    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?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes 1 note

    up
    9
    amosjohlong at hotmail dot com
    8 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
    ＋add a note
    To Top