123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256 |
- /*
- +----------------------------------------------------------------------+
- | Copyright (c) The PHP Group |
- +----------------------------------------------------------------------+
- | This source file is subject to version 3.01 of the PHP license, |
- | that is bundled with this package in the file LICENSE, and is |
- | available through the world-wide-web at the following url: |
- | https://www.php.net/license/3_01.txt |
- | If you did not receive a copy of the PHP license and are unable to |
- | obtain it through the world-wide-web, please send a note to |
- | license@php.net so we can mail you a copy immediately. |
- +----------------------------------------------------------------------+
- | Authors: Andrey Hristov <andrey@php.net> |
- | Ulf Wendel <uw@php.net> |
- | Georg Richter <georg@php.net> |
- +----------------------------------------------------------------------+
- */
- #include "php.h"
- #include "mysqlnd.h"
- #include "mysqlnd_priv.h"
- #include "mysqlnd_statistics.h"
- #include "mysqlnd_debug.h"
- /* {{{ mysqlnd_stats_values_names */
- const MYSQLND_STRING mysqlnd_stats_values_names[STAT_LAST] =
- {
- { MYSQLND_STR_W_LEN("bytes_sent") },
- { MYSQLND_STR_W_LEN("bytes_received") },
- { MYSQLND_STR_W_LEN("packets_sent") },
- { MYSQLND_STR_W_LEN("packets_received") },
- { MYSQLND_STR_W_LEN("protocol_overhead_in") },
- { MYSQLND_STR_W_LEN("protocol_overhead_out") },
- { MYSQLND_STR_W_LEN("bytes_received_ok_packet") },
- { MYSQLND_STR_W_LEN("bytes_received_eof_packet") },
- { MYSQLND_STR_W_LEN("bytes_received_rset_header_packet") },
- { MYSQLND_STR_W_LEN("bytes_received_rset_field_meta_packet") },
- { MYSQLND_STR_W_LEN("bytes_received_rset_row_packet") },
- { MYSQLND_STR_W_LEN("bytes_received_prepare_response_packet") },
- { MYSQLND_STR_W_LEN("bytes_received_change_user_packet") },
- { MYSQLND_STR_W_LEN("packets_sent_command") },
- { MYSQLND_STR_W_LEN("packets_received_ok") },
- { MYSQLND_STR_W_LEN("packets_received_eof") },
- { MYSQLND_STR_W_LEN("packets_received_rset_header") },
- { MYSQLND_STR_W_LEN("packets_received_rset_field_meta") },
- { MYSQLND_STR_W_LEN("packets_received_rset_row") },
- { MYSQLND_STR_W_LEN("packets_received_prepare_response") },
- { MYSQLND_STR_W_LEN("packets_received_change_user") },
- { MYSQLND_STR_W_LEN("result_set_queries") },
- { MYSQLND_STR_W_LEN("non_result_set_queries") },
- { MYSQLND_STR_W_LEN("no_index_used") },
- { MYSQLND_STR_W_LEN("bad_index_used") },
- { MYSQLND_STR_W_LEN("slow_queries") },
- { MYSQLND_STR_W_LEN("buffered_sets") },
- { MYSQLND_STR_W_LEN("unbuffered_sets") },
- { MYSQLND_STR_W_LEN("ps_buffered_sets") },
- { MYSQLND_STR_W_LEN("ps_unbuffered_sets") },
- { MYSQLND_STR_W_LEN("flushed_normal_sets") },
- { MYSQLND_STR_W_LEN("flushed_ps_sets") },
- { MYSQLND_STR_W_LEN("ps_prepared_never_executed") },
- { MYSQLND_STR_W_LEN("ps_prepared_once_executed") },
- { MYSQLND_STR_W_LEN("rows_fetched_from_server_normal") },
- { MYSQLND_STR_W_LEN("rows_fetched_from_server_ps") },
- { MYSQLND_STR_W_LEN("rows_buffered_from_client_normal") },
- { MYSQLND_STR_W_LEN("rows_buffered_from_client_ps") },
- { MYSQLND_STR_W_LEN("rows_fetched_from_client_normal_buffered") },
- { MYSQLND_STR_W_LEN("rows_fetched_from_client_normal_unbuffered") },
- { MYSQLND_STR_W_LEN("rows_fetched_from_client_ps_buffered") },
- { MYSQLND_STR_W_LEN("rows_fetched_from_client_ps_unbuffered") },
- { MYSQLND_STR_W_LEN("rows_fetched_from_client_ps_cursor") },
- { MYSQLND_STR_W_LEN("rows_affected_normal") },
- { MYSQLND_STR_W_LEN("rows_affected_ps") },
- { MYSQLND_STR_W_LEN("rows_skipped_normal") },
- { MYSQLND_STR_W_LEN("rows_skipped_ps") },
- { MYSQLND_STR_W_LEN("copy_on_write_saved") },
- { MYSQLND_STR_W_LEN("copy_on_write_performed") },
- { MYSQLND_STR_W_LEN("command_buffer_too_small") },
- { MYSQLND_STR_W_LEN("connect_success") },
- { MYSQLND_STR_W_LEN("connect_failure") },
- { MYSQLND_STR_W_LEN("connection_reused") },
- { MYSQLND_STR_W_LEN("reconnect") },
- { MYSQLND_STR_W_LEN("pconnect_success") },
- { MYSQLND_STR_W_LEN("active_connections") },
- { MYSQLND_STR_W_LEN("active_persistent_connections") },
- { MYSQLND_STR_W_LEN("explicit_close") },
- { MYSQLND_STR_W_LEN("implicit_close") },
- { MYSQLND_STR_W_LEN("disconnect_close") },
- { MYSQLND_STR_W_LEN("in_middle_of_command_close") },
- { MYSQLND_STR_W_LEN("explicit_free_result") },
- { MYSQLND_STR_W_LEN("implicit_free_result") },
- { MYSQLND_STR_W_LEN("explicit_stmt_close") },
- { MYSQLND_STR_W_LEN("implicit_stmt_close") },
- { MYSQLND_STR_W_LEN("mem_emalloc_count") },
- { MYSQLND_STR_W_LEN("mem_emalloc_amount") },
- { MYSQLND_STR_W_LEN("mem_ecalloc_count") },
- { MYSQLND_STR_W_LEN("mem_ecalloc_amount") },
- { MYSQLND_STR_W_LEN("mem_erealloc_count") },
- { MYSQLND_STR_W_LEN("mem_erealloc_amount") },
- { MYSQLND_STR_W_LEN("mem_efree_count") },
- { MYSQLND_STR_W_LEN("mem_efree_amount") },
- { MYSQLND_STR_W_LEN("mem_malloc_count") },
- { MYSQLND_STR_W_LEN("mem_malloc_amount") },
- { MYSQLND_STR_W_LEN("mem_calloc_count") },
- { MYSQLND_STR_W_LEN("mem_calloc_amount") },
- { MYSQLND_STR_W_LEN("mem_realloc_count") },
- { MYSQLND_STR_W_LEN("mem_realloc_amount") },
- { MYSQLND_STR_W_LEN("mem_free_count") },
- { MYSQLND_STR_W_LEN("mem_free_amount") },
- { MYSQLND_STR_W_LEN("mem_estrndup_count") },
- { MYSQLND_STR_W_LEN("mem_strndup_count") },
- { MYSQLND_STR_W_LEN("mem_estrdup_count") },
- { MYSQLND_STR_W_LEN("mem_strdup_count") },
- { MYSQLND_STR_W_LEN("mem_edupl_count") },
- { MYSQLND_STR_W_LEN("mem_dupl_count") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_null") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_bit") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_tinyint") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_short") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_int24") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_int") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_bigint") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_decimal") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_float") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_double") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_date") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_year") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_time") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_datetime") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_timestamp") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_string") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_blob") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_enum") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_set") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_geometry") },
- { MYSQLND_STR_W_LEN("proto_text_fetched_other") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_null") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_bit") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_tinyint") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_short") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_int24") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_int") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_bigint") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_decimal") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_float") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_double") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_date") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_year") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_time") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_datetime") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_timestamp") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_string") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_json") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_blob") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_enum") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_set") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_geometry") },
- { MYSQLND_STR_W_LEN("proto_binary_fetched_other") },
- { MYSQLND_STR_W_LEN("init_command_executed_count") },
- { MYSQLND_STR_W_LEN("init_command_failed_count") },
- { MYSQLND_STR_W_LEN("com_quit") },
- { MYSQLND_STR_W_LEN("com_init_db") },
- { MYSQLND_STR_W_LEN("com_query") },
- { MYSQLND_STR_W_LEN("com_field_list") },
- { MYSQLND_STR_W_LEN("com_create_db") },
- { MYSQLND_STR_W_LEN("com_drop_db") },
- { MYSQLND_STR_W_LEN("com_refresh") },
- { MYSQLND_STR_W_LEN("com_shutdown") },
- { MYSQLND_STR_W_LEN("com_statistics") },
- { MYSQLND_STR_W_LEN("com_process_info") },
- { MYSQLND_STR_W_LEN("com_connect") },
- { MYSQLND_STR_W_LEN("com_process_kill") },
- { MYSQLND_STR_W_LEN("com_debug") },
- { MYSQLND_STR_W_LEN("com_ping") },
- { MYSQLND_STR_W_LEN("com_time") },
- { MYSQLND_STR_W_LEN("com_delayed_insert") },
- { MYSQLND_STR_W_LEN("com_change_user") },
- { MYSQLND_STR_W_LEN("com_binlog_dump") },
- { MYSQLND_STR_W_LEN("com_table_dump") },
- { MYSQLND_STR_W_LEN("com_connect_out") },
- { MYSQLND_STR_W_LEN("com_register_slave") },
- { MYSQLND_STR_W_LEN("com_stmt_prepare") },
- { MYSQLND_STR_W_LEN("com_stmt_execute") },
- { MYSQLND_STR_W_LEN("com_stmt_send_long_data") },
- { MYSQLND_STR_W_LEN("com_stmt_close") },
- { MYSQLND_STR_W_LEN("com_stmt_reset") },
- { MYSQLND_STR_W_LEN("com_stmt_set_option") },
- { MYSQLND_STR_W_LEN("com_stmt_fetch") },
- { MYSQLND_STR_W_LEN("com_deamon") },
- { MYSQLND_STR_W_LEN("bytes_received_real_data_normal") },
- { MYSQLND_STR_W_LEN("bytes_received_real_data_ps") }
- };
- /* }}} */
- /* {{{ mysqlnd_fill_stats_hash */
- PHPAPI void
- mysqlnd_fill_stats_hash(const MYSQLND_STATS * const stats, const MYSQLND_STRING * names, zval *return_value ZEND_FILE_LINE_DC)
- {
- unsigned int i;
- array_init_size(return_value, stats->count);
- for (i = 0; i < stats->count; i++) {
- char tmp[25];
- sprintf((char *)&tmp, "%" PRIu64, stats->values[i]);
- add_assoc_string_ex(return_value, names[i].s, names[i].l, tmp);
- }
- }
- /* }}} */
- /* {{{ mysqlnd_stats_init */
- PHPAPI void
- mysqlnd_stats_init(MYSQLND_STATS ** stats, const size_t statistic_count, const bool persistent)
- {
- *stats = pecalloc(1, sizeof(MYSQLND_STATS), persistent);
- (*stats)->values = pecalloc(statistic_count, sizeof(uint64_t), persistent);
- (*stats)->count = statistic_count;
- #ifdef ZTS
- (*stats)->LOCK_access = tsrm_mutex_alloc();
- #endif
- }
- /* }}} */
- /* {{{ mysqlnd_stats_end */
- PHPAPI void
- mysqlnd_stats_end(MYSQLND_STATS * stats, const bool persistent)
- {
- #ifdef ZTS
- tsrm_mutex_free(stats->LOCK_access);
- #endif
- pefree(stats->values, persistent);
- /* mnd_free will reference LOCK_access and crash...*/
- pefree(stats, persistent);
- }
- /* }}} */
- /************ MYSQLND specific code **********/
- /* {{{ _mysqlnd_get_client_stats */
- PHPAPI void
- _mysqlnd_get_client_stats(MYSQLND_STATS * stats_ptr, zval *return_value ZEND_FILE_LINE_DC)
- {
- MYSQLND_STATS stats;
- DBG_ENTER("_mysqlnd_get_client_stats");
- if (!stats_ptr) {
- memset(&stats, 0, sizeof(stats));
- stats_ptr = &stats;
- }
- mysqlnd_fill_stats_hash(stats_ptr, mysqlnd_stats_values_names, return_value ZEND_FILE_LINE_CC);
- DBG_VOID_RETURN;
- }
- /* }}} */
|