PHP - Manual: mysqli::debug

2024-11-22

mysqli::dump_debug_info »

« mysqli::__construct

mysqli::debug

mysqli_debug

(PHP 5, PHP 7, PHP 8)

mysqli::debug -- mysqli_debug — Performs debugging operations

说明

面向对象风格

public mysqli::debug(string $options): bool

过程化风格

mysqli_debug(string $options): bool

Performs debugging operations using the Fred Fish debugging library.

参数

options

A string representing the debugging operation to perform

The debug control string is a sequence of colon separated fields as follows:

<field_1>:<field_2>:<field_N>

Each field consists of a mandatory flag character followed by an optional , and comma separated list of modifiers: flag[,modifier,modifier,...,modifier]

**Recognized Flag Characters**
`option` character	Description
O	`MYSQLND_DEBUG_FLUSH`
A/a	`MYSQLND_DEBUG_APPEND`
F	`MYSQLND_DEBUG_DUMP_FILE`
i	`MYSQLND_DEBUG_DUMP_PID`
L	`MYSQLND_DEBUG_DUMP_LINE`
m	`MYSQLND_DEBUG_TRACE_MEMORY_CALLS`
n	`MYSQLND_DEBUG_DUMP_LEVEL`
o	output to file
T	`MYSQLND_DEBUG_DUMP_TIME`
t	`MYSQLND_DEBUG_DUMP_TRACE`
x	`MYSQLND_DEBUG_PROFILE_CALLS`

返回值

Returns true.

范例

示例 #1 Generating a Trace File


<?php

/* Create a trace file in '/tmp/client.trace' on the local (client) machine: */
mysqli_debug("d:t:o,/tmp/client.trace");

?>

注释

注意:
To use the mysqli_debug() function you must compile the MySQL client library to support debugging.

参见

mysqli_dump_debug_info() - 将调试信息输出到日志
mysqli_report() - 别名 mysqli_driver->report_mode

add a note

User Contributed Notes 3 notes

down

Peter ¶

8 years ago


can there be more documenation with a small (but working) example script on how to use this ?

Some issues  (Ive seen the "same" code example in dozens of tutorials):-

( I'll use capitals for emphasis only)

QUESTION: what does D:T:O mean ? UNEXPLAINED.

QUESTION: Do we *ONLY* use these 3 lines in a self-contained script ? Does this log ALL future MYSQL commands ?

QUESTION :- Do we put that one line just

- immediately after we connect to MYSQL ?
- before we connect to MYSQL ?
- before our suspected error ?

down

riversnowchang at gmail dot com ¶

4 years ago


Here are the information about debug options on mysqli_debug()

O,o:MYSQLND_DEBUG_FLUSH
A,a:MYSQLND_DEBUG_APPEND
F:MYSQLND_DEBUG_DUMP_FILE
L:MYSQLND_DEBUG_DUMP_LINE
m:MYSQLND_DEBUG_TRACE_MEMORY_CALLS
n:MYSQLND_DEBUG_DUMP_LEVEL
o:output to file
T:MYSQLND_DEBUG_DUMP_TIME
t:MYSQLND_DEBUG_DUMP_TRACE
x:MYSQLND_DEBUG_PROFILE_CALLS
f:? still investigating

For example, mysqli_debug("T:n:t:m:x:F:L:o,/tmp/client.trace");
mysqlnd will write Time, Level, trace, memory calls, profile calls, File, Line to client.trace file.

22:35:42.704501 ../mysqlnd_connection.c:  269   0:>mysqlnd_connection_init
22:35:42.704538 ../mysqlnd_driver.c:   10   1:| >mysqlnd_driver::get_connection
22:35:42.704549 ../mysqlnd_driver.c:   10   2:| | info : persistent=1
22:35:42.704558 ../mysqlnd_alloc.c:   21   2:| | >_mysqlnd_pecalloc
22:35:42.704570 ../mysqlnd_alloc.c:   23   2:| | <_mysqlnd_pecalloc (total=3 own=3 in_calls=0)
22:35:42.704602 ../mysqlnd_alloc.c:   21   2:| | >_mysqlnd_pecalloc
22:35:42.704626 ../mysqlnd_alloc.c:   23   2:| | <_mysqlnd_pecalloc (total=2 own=2 in_calls=0)
22:35:42.704650 ../mysqlnd_connection.c:   15   2:| | >mysqlnd_error_info_init
22:35:42.704675 ../mysqlnd_connection.c:   10   3:| | | >mysqlnd_error_info::reset
22:35:42.704697 ../mysqlnd_connection.c:   10   3:| | | <mysqlnd_error_info::reset (total=1 own=1 in_calls=0)
22:35:42.704725 ../mysqlnd_connection.c:   16   2:| | <mysqlnd_error_info_init (total=51 own=50 in_calls=1)
22:35:42.704744 ../mysqlnd_connection.c:   21   2:| | >mysqlnd_connection_state_init

If there is anything wrong, please let me know.

down

Domenic ¶

4 years ago


Looks like this manual could be referred to:

http://tiebing.blogspot.com.au/2011/10/cc-dbug-library.html

(I haven't tested it)

add a note

官方地址：https://www.php.net/manual/en/mysqli.debug.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL 数据库面试 C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet ADORecordSet对象 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 PHP 8.1 adodb手册 opcache预加载 Composer的Packagist资源 mysql面试题支持php7的性能采集扩展 php扩展开发 PHP7 mcrypt替代方案 Packagist / Composer 中国全量镜像 PHP json解析（json_decode）页面工具如何在Composer中为GitLab实例设置访问令牌 PHP mkdir()写出来的权限与mode值不符合

略微加速

PHP官方手册 - 互联网笔记

mysqli::debug

mysqli_debug

说明

参数

返回值

范例

注释

参见

User Contributed Notes 3 notes