reference/mysqlnd/stats.xml
40667918dcff1d5c9f7ecdc88b5caca24ba0686c
40667918dcff1d5c9f7ecdc88b5caca24ba0686c
...
...
@@ -119,7 +119,7 @@
119
119
<function>mysqli_get_client_stats</function> and
120
120
<function>mysqli_get_connection_stats</function> functions.
121
121
</para>
122
-
<table>
122
+
<table xml:id="mysqlnd.stats.returns">
123
123
<title>Returned mysqlnd statistics: Network</title>
124
124
<tgroup cols="4">
125
125
<colspec colwidth="10*"/>
...
...
@@ -369,9 +369,7 @@ $res = $mysqli->query("SELECT 'abc'");
369
369
$res->close();
370
370
]]>
371
371
</programlisting>
372
-
<para>
373
-
This statistic is available as of PHP version 5.3.4.
374
-
</para></entry>
372
+
</entry>
375
373
</row>
376
374
<row>
377
375
<entry><literal>bytes_received_real_data_ps</literal></entry>
...
...
@@ -385,8 +383,7 @@ $res->close();
385
383
full result set may have been pulled from MySQL by
386
384
<literal>mysqlnd</literal>, this statistic only counts actual data
387
385
pulled from <literal>mysqlnd</literal> by the PHP client. See also
388
-
<literal>bytes_received_real_data_normal</literal>. This statistic
389
-
is available as of PHP version 5.3.4.</entry>
386
+
<literal>bytes_received_real_data_normal</literal>.</entry>
390
387
</row>
391
388
</tbody>
392
389
</tgroup>
...
...
@@ -394,7 +391,7 @@ $res->close();
394
391
<para>
395
392
<emphasis role="bold">Result Set</emphasis>
396
393
</para>
397
-
<table>
394
+
<table xml:id="mysqlnd.stats.results">
398
395
<title>Returned mysqlnd statistics: Result Set</title>
399
396
<tgroup cols="4">
400
397
<colspec colwidth="10*"/>
...
...
@@ -428,7 +425,7 @@ $res->close();
428
425
<entry>Number of queries that did not generate a result set. Examples of
429
426
queries that do not generate a result set:
430
427
<literal>INSERT</literal>, <literal>UPDATE</literal>,
431
-
<literal>LOAD DATA</literal>, <literal>SHOW</literal>. The
428
+
<literal>LOAD DATA</literal>. The
432
429
statistic will not be incremented if there is an error reading the
433
430
result set header packet from the line.</entry>
434
431
<entry>You may use it as an indirect measure for the number of queries PHP has
...
...
@@ -502,7 +499,7 @@ $res->close();
502
499
<entry>Connection</entry>
503
500
<entry>Number of buffered result sets returned by prepared statements. By
504
501
default prepared statements are unbuffered.</entry>
505
-
<entry>Examples of API calls that will not buffer result sets on the client:
502
+
<entry>Examples of API calls that will buffer result sets on the client:
506
503
<literal>mysqli_stmt_store_result</literal></entry>
507
504
</row>
508
505
<row>
...
...
@@ -867,7 +864,7 @@ $res->close();
867
864
</tbody>
868
865
</tgroup>
869
866
</table>
870
-
<table>
867
+
<table xml:id="mysqlnd.stats.connection">
871
868
<title>Returned mysqlnd statistics: Connection</title>
872
869
<tgroup cols="4">
873
870
<colspec colwidth="10*"/>
...
...
@@ -1013,7 +1010,7 @@ $link = new mysqli(...); $link->connect(...)
1013
1010
</tbody>
1014
1011
</tgroup>
1015
1012
</table>
1016
-
<table>
1013
+
<table xml:id="mysqlnd.stats.com">
1017
1014
<title>Returned mysqlnd statistics: COM_* Command</title>
1018
1015
<tgroup cols="4">
1019
1016
<colspec colwidth="10*"/>
...
...
@@ -1102,7 +1099,7 @@ $link = new mysqli(...); $link->connect(...)
1102
1099
<para>
1103
1100
<emphasis role="bold">Miscellaneous</emphasis>
1104
1101
</para>
1105
-
<table>
1102
+
<table xml:id="mysqlnd.stats.misc">
1106
1103
<title>Returned mysqlnd statistics: Miscellaneous</title>
1107
1104
<tgroup cols="4">
1108
1105
<colspec colwidth="10*"/>
...
...
@@ -1170,34 +1167,11 @@ $link = new mysqli(...); $link->connect(...)
1170
1167
</para>
1171
1168
1172
1169
<para>
1173
-
The default buffer size is 2048 bytes in PHP 5.3.0. In future
1174
-
versions the default will be 4kB or larger. The default can
1170
+
The default buffer size is 4096 bytes, which is the smallest value possible. The default can
1175
1171
changed either through the <filename>php.ini</filename> setting
1176
1172
<literal>mysqlnd.net_cmd_buffer_size</literal> or using
1177
1173
<literal>mysqli_options(MYSQLI_OPT_NET_CMD_BUFFER_SIZE, int
1178
1174
size)</literal>.
1179
-
</para>
1180
-
1181
-
<para>
1182
-
It is recommended to set the buffer size to no less than 4096
1183
-
bytes because mysqlnd also uses it when reading certain
1184
-
communication packet from MySQL. In PHP 5.3.0, mysqlnd will not
1185
-
grow the buffer if MySQL sends a packet that is larger than the
1186
-
current size of the buffer. As a consequence mysqlnd is unable to
1187
-
decode the packet and the client application will get an error.
1188
-
There are only two situations when the packet can be larger than
1189
-
the 2048 bytes default of
1190
-
<literal>mysqlnd.net_cmd_buffer_size</literal> in PHP 5.3.0: the
1191
-
packet transports a very long error message or the packet holds
1192
-
column meta data from <literal>COM_LIST_FIELD</literal>
1193
-
(<function>mysql_list_fields</function>) and the meta data comes
1194
-
from a string column with a very long default value (>1900
1195
-
bytes). No bug report on this exists - it should happen rarely.
1196
-
</para>
1197
-
1198
-
<para>
1199
-
As of PHP 5.3.2 mysqlnd does not allow setting buffers smaller
1200
-
than 4096 bytes.
1201
1175
</para></entry>
1202
1176
</row>
1203
1177
<row>
1204
1178