GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Downloads
  • Documentation
  • Get Involved
  • Help
  • Getting Started
  • Introduction
  • A simple tutorial
  • Language Reference
  • Basic syntax
  • Types
  • Variables
  • Constants
  • Expressions
  • Operators

This view

  • Original page
  • New address

GeezerVison is showing www.php.net — PHP: mysqli::get_connection_stats - Manual

PHP 8.6.0 Released!
    mysqli::$host_info »
    « mysqli::$client_version
    • Preface
    • Function Reference
    • Database Extensions
    • Vendor Specific Database Extensions
    • MySQL
    • MySQLi
    • mysqli

    mysqli::get_connection_stats

    mysqli_get_connection_stats

    (PHP 5 >= 5.3.0, PHP 7, PHP 8)

    mysqli::get_connection_stats -- mysqli_get_connection_stats — Returns statistics about the client connection

    Description

    Object-oriented style

    public function mysqli::get_connection_stats(): array

    Procedural style

    function mysqli_get_connection_stats(mysqli $mysql): array

    Returns statistics about the client connection.

    Note:

    Available only with mysqlnd.

    Parameters

    mysql

    Procedural style only: A mysqli object returned by mysqli_connect() or mysqli_init()

    Return Values

    Returns an array with connection stats.

    Examples

    Example #1 A mysqli_get_connection_stats() example

    <?php
    $link = mysqli_connect();
    print_r(mysqli_get_connection_stats($link));
    ?>

    The above example will output something similar to:

    Array
    (
        [bytes_sent] => 43
        [bytes_received] => 80
        [packets_sent] => 1
        [packets_received] => 2
        [protocol_overhead_in] => 8
        [protocol_overhead_out] => 4
        [bytes_received_ok_packet] => 11
        [bytes_received_eof_packet] => 0
        [bytes_received_rset_header_packet] => 0
        [bytes_received_rset_field_meta_packet] => 0
        [bytes_received_rset_row_packet] => 0
        [bytes_received_prepare_response_packet] => 0
        [bytes_received_change_user_packet] => 0
        [packets_sent_command] => 0
        [packets_received_ok] => 1
        [packets_received_eof] => 0
        [packets_received_rset_header] => 0
        [packets_received_rset_field_meta] => 0
        [packets_received_rset_row] => 0
        [packets_received_prepare_response] => 0
        [packets_received_change_user] => 0
        [result_set_queries] => 0
        [non_result_set_queries] => 0
        [no_index_used] => 0
        [bad_index_used] => 0
        [slow_queries] => 0
        [buffered_sets] => 0
        [unbuffered_sets] => 0
        [ps_buffered_sets] => 0
        [ps_unbuffered_sets] => 0
        [flushed_normal_sets] => 0
        [flushed_ps_sets] => 0
        [ps_prepared_never_executed] => 0
        [ps_prepared_once_executed] => 0
        [rows_fetched_from_server_normal] => 0
        [rows_fetched_from_server_ps] => 0
        [rows_buffered_from_client_normal] => 0
        [rows_buffered_from_client_ps] => 0
        [rows_fetched_from_client_normal_buffered] => 0
        [rows_fetched_from_client_normal_unbuffered] => 0
        [rows_fetched_from_client_ps_buffered] => 0
        [rows_fetched_from_client_ps_unbuffered] => 0
        [rows_fetched_from_client_ps_cursor] => 0
        [rows_skipped_normal] => 0
        [rows_skipped_ps] => 0
        [copy_on_write_saved] => 0
        [copy_on_write_performed] => 0
        [command_buffer_too_small] => 0
        [connect_success] => 1
        [connect_failure] => 0
        [connection_reused] => 0
        [reconnect] => 0
        [pconnect_success] => 0
        [active_connections] => 1
        [active_persistent_connections] => 0
        [explicit_close] => 0
        [implicit_close] => 0
        [disconnect_close] => 0
        [in_middle_of_command_close] => 0
        [explicit_free_result] => 0
        [implicit_free_result] => 0
        [explicit_stmt_close] => 0
        [implicit_stmt_close] => 0
        [mem_emalloc_count] => 0
        [mem_emalloc_ammount] => 0
        [mem_ecalloc_count] => 0
        [mem_ecalloc_ammount] => 0
        [mem_erealloc_count] => 0
        [mem_erealloc_ammount] => 0
        [mem_efree_count] => 0
        [mem_malloc_count] => 0
        [mem_malloc_ammount] => 0
        [mem_calloc_count] => 0
        [mem_calloc_ammount] => 0
        [mem_realloc_count] => 0
        [mem_realloc_ammount] => 0
        [mem_free_count] => 0
        [proto_text_fetched_null] => 0
        [proto_text_fetched_bit] => 0
        [proto_text_fetched_tinyint] => 0
        [proto_text_fetched_short] => 0
        [proto_text_fetched_int24] => 0
        [proto_text_fetched_int] => 0
        [proto_text_fetched_bigint] => 0
        [proto_text_fetched_decimal] => 0
        [proto_text_fetched_float] => 0
        [proto_text_fetched_double] => 0
        [proto_text_fetched_date] => 0
        [proto_text_fetched_year] => 0
        [proto_text_fetched_time] => 0
        [proto_text_fetched_datetime] => 0
        [proto_text_fetched_timestamp] => 0
        [proto_text_fetched_string] => 0
        [proto_text_fetched_blob] => 0
        [proto_text_fetched_enum] => 0
        [proto_text_fetched_set] => 0
        [proto_text_fetched_geometry] => 0
        [proto_text_fetched_other] => 0
        [proto_binary_fetched_null] => 0
        [proto_binary_fetched_bit] => 0
        [proto_binary_fetched_tinyint] => 0
        [proto_binary_fetched_short] => 0
        [proto_binary_fetched_int24] => 0
        [proto_binary_fetched_int] => 0
        [proto_binary_fetched_bigint] => 0
        [proto_binary_fetched_decimal] => 0
        [proto_binary_fetched_float] => 0
        [proto_binary_fetched_double] => 0
        [proto_binary_fetched_date] => 0
        [proto_binary_fetched_year] => 0
        [proto_binary_fetched_time] => 0
        [proto_binary_fetched_datetime] => 0
        [proto_binary_fetched_timestamp] => 0
        [proto_binary_fetched_string] => 0
        [proto_binary_fetched_blob] => 0
        [proto_binary_fetched_enum] => 0
        [proto_binary_fetched_set] => 0
        [proto_binary_fetched_geometry] => 0
        [proto_binary_fetched_other] => 0
    )

    See Also

    • Stats description

    Found A Problem?

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

    User Contributed Notes 3 notes

    up
    down
    -1
    HockeyInJune ¶
    17 years ago
    While this function is only available if you're using the PHP MySQL Native Driver, you can get the same statistics without this function by using the MySQL SHOW STATUS Query.
    
    Use 'SHOW SESSION STATUS;' for statistics about the current MySQL session.
    
    Use 'SHOW GLOBAL STATUS;' for totals since the server was started.
    
    After you have established a connection with the MySQL Server:
    
    <?php
    $result = $mysqli->query('SHOW SESSION STATUS;', MYSQLI_USE_RESULT);
    while ($row = $result->fetch_assoc()) {
        $array[$row['Variable_name']] = $row['Value'];
    }
    $result->close();
    print_r($array);
    ?>
    up
    down
    -1
    vojtech dot kurka at gmail dot com ¶
    7 years ago
    Don't forget that "mysqlnd.collect_statistics" must be set to "1" in your ini config to use this method.
    up
    down
    -4
    ulf dot wendel at phpdoc dot de ¶
    13 years ago
    It is not correct that the same information can be obtained from the server. For example, the server will not give you information about client side memory usage.
    +add a note
    • mysqli
      • $affected_​rows
      • autocommit
      • begin_​transaction
      • change_​user
      • character_​set_​name
      • close
      • commit
      • $connect_​errno
      • $connect_​error
      • _​_​construct
      • debug
      • dump_​debug_​info
      • $errno
      • $error
      • $error_​list
      • escape_​string
      • execute_​query
      • $field_​count
      • get_​charset
      • $client_​info
      • $client_​version
      • get_​connection_​stats
      • $host_​info
      • $protocol_​version
      • $server_​info
      • $server_​version
      • get_​warnings
      • $info
      • $insert_​id
      • more_​results
      • multi_​query
      • next_​result
      • options
      • poll
      • prepare
      • query
      • quote_​string
      • real_​connect
      • real_​escape_​string
      • real_​query
      • reap_​async_​query
      • release_​savepoint
      • rollback
      • savepoint
      • select_​db
      • set_​charset
      • set_​opt
      • $sqlstate
      • ssl_​set
      • stat
      • stmt_​init
      • store_​result
      • $thread_​id
      • thread_​safe
      • use_​result
      • $warning_​count
    • Deprecated
      • init
      • kill
      • ping
      • refresh
    You are visitor 01402639 — GeezerVison does not store the pages you look up.
    Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.