Mysqld--debug=d:t:i:o:n--user=mysql (source debugging)

--debug=d:t
--debug=d:f,main,subr1:f:l:t,20
--debug=d,input,output,files:n
--debug=d:t:i:o,\\mysqld.trace
--debug=d:t:i:o

--debug=d:t--debug=d:f,main,subr1:f:l:t,20--debug=d,input,output,files:n--debug=d:t:i:o,\\mysqld.trace--debug= D:t:i:o

./mysqld--debug=d:t:i:o:f:l:t:n--user=mysql More information

./mysqld--debug=d:t:i:o:n--user=mysql function call frame

./mysqld--debug=d:t:i:o:n:d,20--user=mysql delay two sec.

General:command on socket (7) = 2 (Init DB) log in start of position command

Flag Description

d Enable output from DBUG_XXX macros to the current state. May is followed by a list of keywords, which enables output is for the DBUG macros with that keyword. An empty list

Of keywords enables output for all macros.

In MySQL, common debug macro keywords to enable is enter, exit, error, warning, info, and loop.

D Delay after each debugger output line. The argument is the delay, in tenths of seconds, subject to machine capabilities. For example, d,20 specifies a delay of both seconds.

f Limit debugging, tracing, and profiling to the list of named functions. An empty list enables all functions. The appropriate D or T flags must still be given; This flag is only

Limits their actions if they is enabled.

F Identify The source file name for each line of debug or trace output.

I Identify the process with the PID or thread ID for each line of debug or trace output.

L Identify The source file line number for each line of debug or trace output.

n Print the current function nesting depth for each line of debug or trace output.

N number each line of debug output.

o Redirect the debugger output stream to the specified file. The default output is stderr.

O like O, and the file is really flushed between each write. When needed, the file was closed and reopened between each write.

P Limit Debugger actions to specified processes. A process must is identified with the Dbug_process macro and match one in the list for debugger actions to occur.

P Print The current process name is the line of debug or trace output.

When R is pushing a new state, does not inherit the previous state's function nesting level. Useful when the output was to start on the left margin.

The S do function _sanity (_file_,_line_) at the each debugged function until _sanity () returns something this differs from 0. (Mostly used with Safemalloc to find memory leaks.)

T Enable function Call/exit trace lines. May is followed by a list (containing only one modifier) giving a numeric maximum trace level, beyond which no output OCCU RS for either

debugging or tracing macros. The default is a compile time option

Mysqld--debug=d:t:i:o:n--user=mysql (source debugging)