php foot文件连接,PHP: 运行时配置 - Manual

雨点打透心脏的1/2处 2023-01-15 08:19 188阅读 0赞

mysqlnd.collect\_statistics

bool

Enables the collection of various client statistics which can be

accessed through mysqlnd section of the output of the

This configuration setting enables all

MySQL Native Driver

statistics except those relating to memory management.

mysqlnd.collect\_memory\_statistics

bool

Enable the collection of various memory statistics which can be

accessed through mysqlnd section of the output of the

This configuration setting enables the memory management

statistics within the overall set of

MySQL Native Driver

statistics.

mysqlnd.debug string

Records communication from all extensions using

mysqlnd to the specified log file.

The format of the directive is mysqlnd.debug =

"option1\[,parameter\_option1\]\[:option2\[,parameter\_option2\]\]".

The options for the format string are as follows:

A\[,file\] - Appends trace output to specified file. Also ensures

that data is written after each write. This is done by closing

and reopening the trace file (this is slow). It helps ensure a

complete log file should the application crash.

a\[,file\] - Appends trace output to the specified file.

d - Enables output from DBUG\_ macros for the current

state. May be followed by a list of keywords which selects

output only for the DBUG macros with that keyword. An empty list

of keywords implies output for all macros.

f\[,functions\] - Limits debugger actions to the specified list of

functions. An empty list of functions implies that all functions

are selected.

F - Marks each debugger output line with the name of the source

file containing the macro causing the output.

i - Marks each debugger output line with the PID of the current

process.

L - Marks each debugger output line with the name of the source

file line number of the macro causing the output.

n - Marks each debugger output line with the current function

nesting depth

o\[,file\] - Similar to a\[,file\] but overwrites old file, and does

not append.

O\[,file\] - Similar to A\[,file\] but overwrites old file, and does

not append.

t\[,N\] - Enables function control flow tracing. The maximum

nesting depth is specified by N, and defaults to 200.

x - This option activates profiling.

m - Trace memory allocation and deallocation related calls.

Example:

d:t:x:O,/tmp/mysqlnd.trace

注意:

This feature is only available with a debug build of PHP. Works

on Microsoft Windows if using a debug build of PHP and PHP was

built using Microsoft Visual C version 9 and above.

mysqlnd.log\_mask

int

Defines which queries will be logged. The default 0, which disables logging.

Define using an integer, and not with PHP constants. For example, a value of

48 (16 + 32) will log slow queries which either use 'no good index'

(SERVER\_QUERY\_NO\_GOOD\_INDEX\_USED = 16) or no index at all (SERVER\_QUERY\_NO\_INDEX\_USED = 32).

A value of 2043 (1 + 2 + 8 + ... + 1024) will log all slow query types.

The types are as follows: SERVER\_STATUS\_IN\_TRANS=1, SERVER\_STATUS\_AUTOCOMMIT=2,

SERVER\_MORE\_RESULTS\_EXISTS=8, SERVER\_QUERY\_NO\_GOOD\_INDEX\_USED=16, SERVER\_QUERY\_NO\_INDEX\_USED=32,

SERVER\_STATUS\_CURSOR\_EXISTS=64, SERVER\_STATUS\_LAST\_ROW\_SENT=128, SERVER\_STATUS\_DB\_DROPPED=256,

SERVER\_STATUS\_NO\_BACKSLASH\_ESCAPES=512, and SERVER\_QUERY\_WAS\_SLOW=1024.

mysqlnd.mempool\_default\_size

int

Default size of the mysqlnd memory pool, which is used by result sets.

mysqlnd.net\_read\_timeout

int

mysqlnd and the MySQL Client Library,

libmysqlclient use different networking APIs.

mysqlnd uses PHP streams, whereas

libmysqlclient uses its own wrapper around the

operating level network calls. PHP, by default, sets a read

timeout of 60s for streams. This is set via

php.ini,

default\_socket\_timeout. This default applies to

all streams that set no other timeout value.

mysqlnd does not set any other value and

therefore connections of long running queries can be disconnected

after default\_socket\_timeout seconds resulting

in an error message 2006 - MySQL Server has gone

away. The MySQL Client Library sets a default timeout of

24 \* 3600 seconds (1 day) and waits for other timeouts to

occur, such as TCP/IP timeouts. mysqlnd now

uses the same very long timeout. The value is configurable through

a new php.ini setting:

mysqlnd.net\_read\_timeout.

mysqlnd.net\_read\_timeout gets used by any

extension (ext/mysql,

ext/mysqli, PDO\_MySQL) that

uses mysqlnd. mysqlnd tells

PHP Streams to use mysqlnd.net\_read\_timeout.

Please note that there may be subtle differences between

MYSQL\_OPT\_READ\_TIMEOUT from the MySQL Client

Library and PHP Streams, for example

MYSQL\_OPT\_READ\_TIMEOUT is documented to work

only for TCP/IP connections and, prior to MySQL 5.1.2, only for

Windows. PHP streams may not have this limitation. Please check

the streams documentation, if in doubt.

mysqlnd.net\_cmd\_buffer\_size

int

mysqlnd allocates an internal command/network

buffer of mysqlnd.net\_cmd\_buffer\_size (in

php.ini) bytes for every connection. If a

MySQL Client Server protocol command, for example,

COM\_QUERY (normal query), does

not fit into the buffer, mysqlnd will grow the

buffer to the size required for sending the command. Whenever the

buffer gets extended for one connection,

command\_buffer\_too\_small will be incremented by

one.

If mysqlnd has to grow the buffer beyond its

initial size of mysqlnd.net\_cmd\_buffer\_size

bytes for almost every connection, you should consider increasing

the default size to avoid re-allocations.

The default buffer size is 4096 bytes, which is the smallest value possible.

The value can also be set using mysqli\_options(link,

MYSQLI\_OPT\_NET\_CMD\_BUFFER\_SIZE, size).

mysqlnd.net\_read\_buffer\_size

int

Maximum read chunk size in bytes when reading the body of a MySQL

command packet. The MySQL client server protocol encapsulates all

its commands in packets. The packets consist of a small header and

a body with the actual payload. The size of the body is encoded in

the header. mysqlnd reads the body in chunks of

MIN(header.size, mysqlnd.net\_read\_buffer\_size)

bytes. If a packet body is larger than

mysqlnd.net\_read\_buffer\_size bytes,

mysqlnd has to call read()

multiple times.

The value can also be set using mysqli\_options(link,

MYSQLI\_OPT\_NET\_READ\_BUFFER\_SIZE, size).

mysqlnd.sha256\_server\_public\_key

string

SHA-256 Authentication Plugin related. File with the MySQL server

public RSA key.

Clients can either omit setting a public RSA key, specify the key through

this PHP configuration setting or set the key at runtime using

mysqlnd.trace\_alloc

string

mysqlnd.fetch\_data\_copy

int

Enforce copying result sets from the internal

result set buffers into PHP variables instead of using the default

reference and copy-on-write logic. Please, see the

memory management implementation notes

for further details.

Copying result sets instead of having PHP variables reference

them allows releasing the memory occupied for the PHP variables earlier.

Depending on the user API code, the actual database quries and the

size of their result sets this may reduce the memory footprint

of mysqlnd.

Do not set if using PDO\_MySQL. PDO\_MySQL has not yet been updated to support

the new fetch mode.

php foot文件连接,PHP: 运行时配置 - Manual

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 PHP连接数据库时出错

相关 PHP INI 设置php脚本运行配置

相关 php foot文件连接,PHP: 运行时配置 - Manual

相关 php domdocument(),PHP: DOMDocument - Manual

相关 php 厘米转为英寸,换算foot至英寸

相关 dns检测工具 php,PHP: checkdnsrr - Manual

相关 php解析配置文件,PHP 配置文件解析

相关 php的等于_PHP: 表达式 - Manual

相关 php html_entity_encode,PHP: htmlentities - Manual

相关 php opcache运行时配置参数详解+laravel opcache配置