This source file includes following definitions.
- mysqlnd_fill_stats_hash
- _mysqlnd_get_client_stats
- mysqlnd_stats_init
- mysqlnd_stats_end
- mysqlnd_stats_set_trigger
- mysqlnd_stats_reset_triggers
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22 #include "php.h"
23 #include "mysqlnd.h"
24 #include "mysqlnd_priv.h"
25 #include "mysqlnd_statistics.h"
26 #include "mysqlnd_debug.h"
27
28
29
30
31
32 const MYSQLND_STRING mysqlnd_stats_values_names[STAT_LAST] =
33 {
34 { MYSQLND_STR_W_LEN("bytes_sent") },
35 { MYSQLND_STR_W_LEN("bytes_received") },
36 { MYSQLND_STR_W_LEN("packets_sent") },
37 { MYSQLND_STR_W_LEN("packets_received") },
38 { MYSQLND_STR_W_LEN("protocol_overhead_in") },
39 { MYSQLND_STR_W_LEN("protocol_overhead_out") },
40 { MYSQLND_STR_W_LEN("bytes_received_ok_packet") },
41 { MYSQLND_STR_W_LEN("bytes_received_eof_packet") },
42 { MYSQLND_STR_W_LEN("bytes_received_rset_header_packet") },
43 { MYSQLND_STR_W_LEN("bytes_received_rset_field_meta_packet") },
44 { MYSQLND_STR_W_LEN("bytes_received_rset_row_packet") },
45 { MYSQLND_STR_W_LEN("bytes_received_prepare_response_packet") },
46 { MYSQLND_STR_W_LEN("bytes_received_change_user_packet") },
47 { MYSQLND_STR_W_LEN("packets_sent_command") },
48 { MYSQLND_STR_W_LEN("packets_received_ok") },
49 { MYSQLND_STR_W_LEN("packets_received_eof") },
50 { MYSQLND_STR_W_LEN("packets_received_rset_header") },
51 { MYSQLND_STR_W_LEN("packets_received_rset_field_meta") },
52 { MYSQLND_STR_W_LEN("packets_received_rset_row") },
53 { MYSQLND_STR_W_LEN("packets_received_prepare_response") },
54 { MYSQLND_STR_W_LEN("packets_received_change_user") },
55 { MYSQLND_STR_W_LEN("result_set_queries") },
56 { MYSQLND_STR_W_LEN("non_result_set_queries") },
57 { MYSQLND_STR_W_LEN("no_index_used") },
58 { MYSQLND_STR_W_LEN("bad_index_used") },
59 { MYSQLND_STR_W_LEN("slow_queries") },
60 { MYSQLND_STR_W_LEN("buffered_sets") },
61 { MYSQLND_STR_W_LEN("unbuffered_sets") },
62 { MYSQLND_STR_W_LEN("ps_buffered_sets") },
63 { MYSQLND_STR_W_LEN("ps_unbuffered_sets") },
64 { MYSQLND_STR_W_LEN("flushed_normal_sets") },
65 { MYSQLND_STR_W_LEN("flushed_ps_sets") },
66 { MYSQLND_STR_W_LEN("ps_prepared_never_executed") },
67 { MYSQLND_STR_W_LEN("ps_prepared_once_executed") },
68 { MYSQLND_STR_W_LEN("rows_fetched_from_server_normal") },
69 { MYSQLND_STR_W_LEN("rows_fetched_from_server_ps") },
70 { MYSQLND_STR_W_LEN("rows_buffered_from_client_normal") },
71 { MYSQLND_STR_W_LEN("rows_buffered_from_client_ps") },
72 { MYSQLND_STR_W_LEN("rows_fetched_from_client_normal_buffered") },
73 { MYSQLND_STR_W_LEN("rows_fetched_from_client_normal_unbuffered") },
74 { MYSQLND_STR_W_LEN("rows_fetched_from_client_ps_buffered") },
75 { MYSQLND_STR_W_LEN("rows_fetched_from_client_ps_unbuffered") },
76 { MYSQLND_STR_W_LEN("rows_fetched_from_client_ps_cursor") },
77 { MYSQLND_STR_W_LEN("rows_affected_normal") },
78 { MYSQLND_STR_W_LEN("rows_affected_ps") },
79 { MYSQLND_STR_W_LEN("rows_skipped_normal") },
80 { MYSQLND_STR_W_LEN("rows_skipped_ps") },
81 { MYSQLND_STR_W_LEN("copy_on_write_saved") },
82 { MYSQLND_STR_W_LEN("copy_on_write_performed") },
83 { MYSQLND_STR_W_LEN("command_buffer_too_small") },
84 { MYSQLND_STR_W_LEN("connect_success") },
85 { MYSQLND_STR_W_LEN("connect_failure") },
86 { MYSQLND_STR_W_LEN("connection_reused") },
87 { MYSQLND_STR_W_LEN("reconnect") },
88 { MYSQLND_STR_W_LEN("pconnect_success") },
89 { MYSQLND_STR_W_LEN("active_connections") },
90 { MYSQLND_STR_W_LEN("active_persistent_connections") },
91 { MYSQLND_STR_W_LEN("explicit_close") },
92 { MYSQLND_STR_W_LEN("implicit_close") },
93 { MYSQLND_STR_W_LEN("disconnect_close") },
94 { MYSQLND_STR_W_LEN("in_middle_of_command_close") },
95 { MYSQLND_STR_W_LEN("explicit_free_result") },
96 { MYSQLND_STR_W_LEN("implicit_free_result") },
97 { MYSQLND_STR_W_LEN("explicit_stmt_close") },
98 { MYSQLND_STR_W_LEN("implicit_stmt_close") },
99 { MYSQLND_STR_W_LEN("mem_emalloc_count") },
100 { MYSQLND_STR_W_LEN("mem_emalloc_amount") },
101 { MYSQLND_STR_W_LEN("mem_ecalloc_count") },
102 { MYSQLND_STR_W_LEN("mem_ecalloc_amount") },
103 { MYSQLND_STR_W_LEN("mem_erealloc_count") },
104 { MYSQLND_STR_W_LEN("mem_erealloc_amount") },
105 { MYSQLND_STR_W_LEN("mem_efree_count") },
106 { MYSQLND_STR_W_LEN("mem_efree_amount") },
107 { MYSQLND_STR_W_LEN("mem_malloc_count") },
108 { MYSQLND_STR_W_LEN("mem_malloc_amount") },
109 { MYSQLND_STR_W_LEN("mem_calloc_count") },
110 { MYSQLND_STR_W_LEN("mem_calloc_amount") },
111 { MYSQLND_STR_W_LEN("mem_realloc_count") },
112 { MYSQLND_STR_W_LEN("mem_realloc_amount") },
113 { MYSQLND_STR_W_LEN("mem_free_count") },
114 { MYSQLND_STR_W_LEN("mem_free_amount") },
115 { MYSQLND_STR_W_LEN("mem_estrndup_count") },
116 { MYSQLND_STR_W_LEN("mem_strndup_count") },
117 { MYSQLND_STR_W_LEN("mem_estndup_count") },
118 { MYSQLND_STR_W_LEN("mem_strdup_count") },
119 { MYSQLND_STR_W_LEN("proto_text_fetched_null") },
120 { MYSQLND_STR_W_LEN("proto_text_fetched_bit") },
121 { MYSQLND_STR_W_LEN("proto_text_fetched_tinyint") },
122 { MYSQLND_STR_W_LEN("proto_text_fetched_short") },
123 { MYSQLND_STR_W_LEN("proto_text_fetched_int24") },
124 { MYSQLND_STR_W_LEN("proto_text_fetched_int") },
125 { MYSQLND_STR_W_LEN("proto_text_fetched_bigint") },
126 { MYSQLND_STR_W_LEN("proto_text_fetched_decimal") },
127 { MYSQLND_STR_W_LEN("proto_text_fetched_float") },
128 { MYSQLND_STR_W_LEN("proto_text_fetched_double") },
129 { MYSQLND_STR_W_LEN("proto_text_fetched_date") },
130 { MYSQLND_STR_W_LEN("proto_text_fetched_year") },
131 { MYSQLND_STR_W_LEN("proto_text_fetched_time") },
132 { MYSQLND_STR_W_LEN("proto_text_fetched_datetime") },
133 { MYSQLND_STR_W_LEN("proto_text_fetched_timestamp") },
134 { MYSQLND_STR_W_LEN("proto_text_fetched_string") },
135 { MYSQLND_STR_W_LEN("proto_text_fetched_blob") },
136 { MYSQLND_STR_W_LEN("proto_text_fetched_enum") },
137 { MYSQLND_STR_W_LEN("proto_text_fetched_set") },
138 { MYSQLND_STR_W_LEN("proto_text_fetched_geometry") },
139 { MYSQLND_STR_W_LEN("proto_text_fetched_other") },
140 { MYSQLND_STR_W_LEN("proto_binary_fetched_null") },
141 { MYSQLND_STR_W_LEN("proto_binary_fetched_bit") },
142 { MYSQLND_STR_W_LEN("proto_binary_fetched_tinyint") },
143 { MYSQLND_STR_W_LEN("proto_binary_fetched_short") },
144 { MYSQLND_STR_W_LEN("proto_binary_fetched_int24") },
145 { MYSQLND_STR_W_LEN("proto_binary_fetched_int") },
146 { MYSQLND_STR_W_LEN("proto_binary_fetched_bigint") },
147 { MYSQLND_STR_W_LEN("proto_binary_fetched_decimal") },
148 { MYSQLND_STR_W_LEN("proto_binary_fetched_float") },
149 { MYSQLND_STR_W_LEN("proto_binary_fetched_double") },
150 { MYSQLND_STR_W_LEN("proto_binary_fetched_date") },
151 { MYSQLND_STR_W_LEN("proto_binary_fetched_year") },
152 { MYSQLND_STR_W_LEN("proto_binary_fetched_time") },
153 { MYSQLND_STR_W_LEN("proto_binary_fetched_datetime") },
154 { MYSQLND_STR_W_LEN("proto_binary_fetched_timestamp") },
155 { MYSQLND_STR_W_LEN("proto_binary_fetched_string") },
156 { MYSQLND_STR_W_LEN("proto_binary_fetched_json") },
157 { MYSQLND_STR_W_LEN("proto_binary_fetched_blob") },
158 { MYSQLND_STR_W_LEN("proto_binary_fetched_enum") },
159 { MYSQLND_STR_W_LEN("proto_binary_fetched_set") },
160 { MYSQLND_STR_W_LEN("proto_binary_fetched_geometry") },
161 { MYSQLND_STR_W_LEN("proto_binary_fetched_other") },
162 { MYSQLND_STR_W_LEN("init_command_executed_count") },
163 { MYSQLND_STR_W_LEN("init_command_failed_count") },
164 { MYSQLND_STR_W_LEN("com_quit") },
165 { MYSQLND_STR_W_LEN("com_init_db") },
166 { MYSQLND_STR_W_LEN("com_query") },
167 { MYSQLND_STR_W_LEN("com_field_list") },
168 { MYSQLND_STR_W_LEN("com_create_db") },
169 { MYSQLND_STR_W_LEN("com_drop_db") },
170 { MYSQLND_STR_W_LEN("com_refresh") },
171 { MYSQLND_STR_W_LEN("com_shutdown") },
172 { MYSQLND_STR_W_LEN("com_statistics") },
173 { MYSQLND_STR_W_LEN("com_process_info") },
174 { MYSQLND_STR_W_LEN("com_connect") },
175 { MYSQLND_STR_W_LEN("com_process_kill") },
176 { MYSQLND_STR_W_LEN("com_debug") },
177 { MYSQLND_STR_W_LEN("com_ping") },
178 { MYSQLND_STR_W_LEN("com_time") },
179 { MYSQLND_STR_W_LEN("com_delayed_insert") },
180 { MYSQLND_STR_W_LEN("com_change_user") },
181 { MYSQLND_STR_W_LEN("com_binlog_dump") },
182 { MYSQLND_STR_W_LEN("com_table_dump") },
183 { MYSQLND_STR_W_LEN("com_connect_out") },
184 { MYSQLND_STR_W_LEN("com_register_slave") },
185 { MYSQLND_STR_W_LEN("com_stmt_prepare") },
186 { MYSQLND_STR_W_LEN("com_stmt_execute") },
187 { MYSQLND_STR_W_LEN("com_stmt_send_long_data") },
188 { MYSQLND_STR_W_LEN("com_stmt_close") },
189 { MYSQLND_STR_W_LEN("com_stmt_reset") },
190 { MYSQLND_STR_W_LEN("com_stmt_set_option") },
191 { MYSQLND_STR_W_LEN("com_stmt_fetch") },
192 { MYSQLND_STR_W_LEN("com_deamon") },
193 { MYSQLND_STR_W_LEN("bytes_received_real_data_normal") },
194 { MYSQLND_STR_W_LEN("bytes_received_real_data_ps") }
195 };
196
197
198
199
200 PHPAPI void
201 mysqlnd_fill_stats_hash(const MYSQLND_STATS * const stats, const MYSQLND_STRING * names, zval *return_value ZEND_FILE_LINE_DC)
202 {
203 unsigned int i;
204
205 array_init_size(return_value, stats->count);
206 for (i = 0; i < stats->count; i++) {
207 char tmp[25];
208
209 sprintf((char *)&tmp, MYSQLND_LLU_SPEC, stats->values[i]);
210 add_assoc_string_ex(return_value, names[i].s, names[i].l, tmp);
211 }
212 }
213
214
215
216
217 PHPAPI void
218 _mysqlnd_get_client_stats(zval *return_value ZEND_FILE_LINE_DC)
219 {
220 MYSQLND_STATS stats, *stats_ptr = mysqlnd_global_stats;
221 DBG_ENTER("_mysqlnd_get_client_stats");
222 if (!stats_ptr) {
223 memset(&stats, 0, sizeof(stats));
224 stats_ptr = &stats;
225 }
226 mysqlnd_fill_stats_hash(stats_ptr, mysqlnd_stats_values_names, return_value ZEND_FILE_LINE_CC);
227 DBG_VOID_RETURN;
228 }
229
230
231
232
233 PHPAPI void
234 mysqlnd_stats_init(MYSQLND_STATS ** stats, size_t statistic_count, int persistent)
235 {
236 *stats = pecalloc(1, sizeof(MYSQLND_STATS), persistent);
237 if (*stats == NULL) {
238 return;
239 }
240 (*stats)->values = pecalloc(statistic_count, sizeof(uint64_t), persistent);
241 (*stats)->triggers = pecalloc(statistic_count, sizeof(mysqlnd_stat_trigger), persistent);
242 (*stats)->in_trigger = FALSE;
243 (*stats)->count = statistic_count;
244 #ifdef ZTS
245 (*stats)->LOCK_access = tsrm_mutex_alloc();
246 #endif
247 }
248
249
250
251
252 PHPAPI void
253 mysqlnd_stats_end(MYSQLND_STATS * stats, int persistent)
254 {
255 #ifdef ZTS
256 tsrm_mutex_free(stats->LOCK_access);
257 #endif
258 pefree(stats->triggers, persistent);
259 pefree(stats->values, persistent);
260
261 pefree(stats, persistent);
262 }
263
264
265
266
267 PHPAPI mysqlnd_stat_trigger
268 mysqlnd_stats_set_trigger(MYSQLND_STATS * const stats, enum_mysqlnd_collected_stats statistic, mysqlnd_stat_trigger trigger)
269 {
270 mysqlnd_stat_trigger ret = NULL;
271 DBG_ENTER("mysqlnd_stats_set_trigger");
272 if (stats) {
273 MYSQLND_STATS_LOCK(stats);
274 ret = stats->triggers[statistic];
275 stats->triggers[statistic] = trigger;
276 MYSQLND_STATS_UNLOCK(stats);
277 }
278 DBG_RETURN(ret);
279 }
280
281
282
283
284 PHPAPI mysqlnd_stat_trigger
285 mysqlnd_stats_reset_triggers(MYSQLND_STATS * const stats)
286 {
287 mysqlnd_stat_trigger ret = NULL;
288 DBG_ENTER("mysqlnd_stats_reset_trigger");
289 if (stats) {
290 MYSQLND_STATS_LOCK(stats);
291 memset(stats->triggers, 0, stats->count * sizeof(mysqlnd_stat_trigger));
292 MYSQLND_STATS_UNLOCK(stats);
293 }
294 DBG_RETURN(ret);
295 }
296
297
298
299
300
301
302
303
304
305
306