<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="dbug-package">
      </a>
      7.9.4 The DBUG Package
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045253107568">
  </a>
  <p>
   The MySQL server and most MySQL clients are compiled with the
   <code class="literal">
    DBUG
   </code>
   package originally created by Fred Fish.
      When you have configured MySQL for debugging, this package makes
      it possible to get a trace file of what the program is doing. See
   <a class="xref" href="making-trace-files.html" title="7.9.1.2 Creating Trace Files">
    Section 7.9.1.2, “Creating Trace Files”
   </a>
   .
  </p>
  <p>
   This section summarizes the argument values that you can specify
      in debug options on the command line for MySQL programs that have
      been built with debugging support.
  </p>
  <p>
   The
   <code class="literal">
    DBUG
   </code>
   package can be used by invoking a
      program with the
   <code class="option">
    --debug[=
    <em class="replaceable">
     <code>
      debug_options
     </code>
    </em>
    ]
   </code>
   or
   <code class="option">
    -# [
    <em class="replaceable">
     <code>
      debug_options
     </code>
    </em>
    ]
   </code>
   option. If you specify the
   <code class="option">
    --debug
   </code>
   or
   <code class="option">
    -#
   </code>
   option without a
   <em class="replaceable">
    <code>
     debug_options
    </code>
   </em>
   value, most MySQL
      programs use a default value. The server default is
   <code class="literal">
    d:t:i:o,/tmp/mysqld.trace
   </code>
   on Unix and
   <code class="literal">
    d:t:i:O,\mysqld.trace
   </code>
   on Windows. The effect of
      this default is:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       d
      </code>
      : Enable output for all debug macros
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       t
      </code>
      : Trace function calls and exits
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       i
      </code>
      : Add PID to output lines
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       o,/tmp/mysqld.trace
      </code>
      ,
      <code class="literal">
       O,\mysqld.trace
      </code>
      : Set the debug output file.
     </p>
    </li>
   </ul>
  </div>
  <p>
   Most client programs use a default
   <em class="replaceable">
    <code>
     debug_options
    </code>
   </em>
   value of
   <code class="literal">
    d:t:o,/tmp/
    <em class="replaceable">
     <code>
      program_name
     </code>
    </em>
    .trace
   </code>
   ,
      regardless of platform.
  </p>
  <p>
   Here are some example debug control strings as they might be
      specified on a shell command line:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa61763144"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-ini"><span class="token constant">--debug</span><span class="token attr-value"><span class="token punctuation">=</span>d:t</span>
<span class="token constant">--debug</span><span class="token attr-value"><span class="token punctuation">=</span>d:f,main,subr1:F:L:t,20</span>
<span class="token constant">--debug</span><span class="token attr-value"><span class="token punctuation">=</span>d,input,output,files:n</span>
<span class="token constant">--debug</span><span class="token attr-value"><span class="token punctuation">=</span>d:t:i:O,\\mysqld.trace</span></code></pre>
  </div>
  <p>
   For
   <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
    <span class="command">
     <strong>
      mysqld
     </strong>
    </span>
   </a>
   , it is also possible to change DBUG
      settings at runtime by setting the
   <a class="link" href="server-system-variables.html#sysvar_debug">
    <code class="literal">
     debug
    </code>
   </a>
   system variable. This
      variable has global and session values:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa14045981"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> <span class="token keyword">GLOBAL</span> debug <span class="token operator">=</span> <span class="token string">'<em class="replaceable">debug_options</em>'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> <span class="token keyword">SESSION</span> debug <span class="token operator">=</span> <span class="token string">'<em class="replaceable">debug_options</em>'</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   Changing the global
   <a class="link" href="server-system-variables.html#sysvar_debug">
    <code class="literal">
     debug
    </code>
   </a>
   value
      requires privileges sufficient to set global system variables.
      Changing the session
   <a class="link" href="server-system-variables.html#sysvar_debug">
    <code class="literal">
     debug
    </code>
   </a>
   value
      requires privileges sufficient to set restricted session system
      variables. See
   <a class="xref" href="system-variable-privileges.html" title="7.1.9.1 System Variable Privileges">
    Section 7.1.9.1, “System Variable Privileges”
   </a>
   .
  </p>
  <p>
   The
   <em class="replaceable">
    <code>
     debug_options
    </code>
   </em>
   value is a sequence
      of colon-separated fields:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-simple"><div class="docs-select-all right" id="sa91455488"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-simple">field_1<span class="token operator">:</span>field_2<span class="token operator">:</span><span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token operator">:</span>field_<em class="replaceable">N</em></code></pre>
  </div>
  <p>
   Each field within the value consists of a mandatory flag
      character, optionally preceded by a
   <code class="literal">
    +
   </code>
   or
   <code class="literal">
    -
   </code>
   character, and optionally followed by a
      comma-separated list of modifiers:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-simple"><div class="docs-select-all right" id="sa29603392"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-simple"><span class="token punctuation">[</span><span class="token operator">+</span><span class="token operator">|</span><span class="token operator">-</span><span class="token punctuation">]</span>flag<span class="token punctuation">[</span><span class="token punctuation">,</span>modifier<span class="token punctuation">,</span>modifier<span class="token punctuation">,</span><span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">,</span>modifier<span class="token punctuation">]</span></code></pre>
  </div>
  <p>
   The following table describes the permitted flag characters.
      Unrecognized flag characters are silently ignored.
  </p>
  <div class="informaltable">
   <table frame="all" summary="Descriptions of permitted debug_options flag characters.">
    <colgroup>
     <col style="width: 8%"/>
     <col style="width: 92%"/>
    </colgroup>
    <thead>
     <tr>
      <th>
       <p>
        Flag
       </p>
      </th>
      <th>
       <p>
        Description
       </p>
      </th>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td>
       <p>
        <code class="literal">
         d
        </code>
       </p>
      </td>
      <td>
       <p>
        Enable output from
        <code class="literal">
         DBUG_
         <em class="replaceable">
          <code>
           XXX
          </code>
         </em>
        </code>
        macros for the current state. May be followed by a list of
              keywords, which enables output only for the DBUG macros
              with that keyword. An empty list of keywords enables
              output for all macros.
       </p>
       <p>
        In MySQL, common debug macro keywords to enable are
        <code class="literal">
         enter
        </code>
        ,
        <code class="literal">
         exit
        </code>
        ,
        <code class="literal">
         error
        </code>
        ,
        <code class="literal">
         warning
        </code>
        ,
        <code class="literal">
         info
        </code>
        , and
        <code class="literal">
         loop
        </code>
        .
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         D
        </code>
       </p>
      </td>
      <td>
       <p>
        Delay after each debugger output line. The argument is the
              delay, in tenths of seconds, subject to machine
              capabilities. For example,
        <code class="literal">
         D,20
        </code>
        specifies a delay of two seconds.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         f
        </code>
       </p>
      </td>
      <td>
       <p>
        Limit debugging, tracing, and profiling to the list of
              named functions. An empty list enables all functions. The
              appropriate
        <code class="literal">
         d
        </code>
        or
        <code class="literal">
         t
        </code>
        flags must still be given; this flag only limits their
              actions if they are enabled.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         F
        </code>
       </p>
      </td>
      <td>
       <p>
        Identify the source file name for each line of debug or
              trace output.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         i
        </code>
       </p>
      </td>
      <td>
       <p>
        Identify the process with the PID or thread ID for each
              line of debug or trace output.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         L
        </code>
       </p>
      </td>
      <td>
       <p>
        Identify the source file line number for each line of
              debug or trace output.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         n
        </code>
       </p>
      </td>
      <td>
       <p>
        Print the current function nesting depth for each line of
              debug or trace output.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         N
        </code>
       </p>
      </td>
      <td>
       <p>
        Number each line of debug output.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         o
        </code>
       </p>
      </td>
      <td>
       <p>
        Redirect the debugger output stream to the specified file.
              The default output is
        <code class="literal">
         stderr
        </code>
        .
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         O
        </code>
       </p>
      </td>
      <td>
       <p>
        Like
        <code class="literal">
         o
        </code>
        , but the file is really flushed
              between each write. When needed, the file is closed and
              reopened between each write.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         a
        </code>
       </p>
      </td>
      <td>
       <p>
        Like
        <code class="literal">
         o
        </code>
        , but opens for append.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         A
        </code>
       </p>
      </td>
      <td>
       <p>
        Like
        <code class="literal">
         O
        </code>
        , but opens for append.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         p
        </code>
       </p>
      </td>
      <td>
       <p>
        Limit debugger actions to specified processes. A process
              must be identified with the
        <code class="literal">
         DBUG_PROCESS
        </code>
        macro and match one in the
              list for debugger actions to occur.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         P
        </code>
       </p>
      </td>
      <td>
       <p>
        Print the current process name for each line of debug or
              trace output.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         r
        </code>
       </p>
      </td>
      <td>
       <p>
        When pushing a new state, do not inherit the previous
              state's function nesting level. Useful when the output is
              to start at the left margin.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         t
        </code>
       </p>
      </td>
      <td>
       <p>
        Enable function call/exit trace lines. May be followed by
              a list (containing only one modifier) giving a numeric
              maximum trace level, beyond which no output occurs for
              either debugging or tracing macros. The default is a
              compile time option.
       </p>
      </td>
     </tr>
     <tr>
      <td>
       <p>
        <code class="literal">
         T
        </code>
       </p>
      </td>
      <td>
       <p>
        Print the current timestamp for every line of output.
       </p>
      </td>
     </tr>
    </tbody>
   </table>
  </div>
  <div class="informaltable">
   <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 739px;">
    <thead>
     <tr>
      <th style="width: 59.0312px;">
       <p>
        Flag
       </p>
      </th>
      <th style="width: 678.969px;">
       <p>
        Description
       </p>
      </th>
     </tr>
    </thead>
   </table>
  </div>
  <p>
   The leading
   <code class="literal">
    +
   </code>
   or
   <code class="literal">
    -
   </code>
   character
      and trailing list of modifiers are used for flag characters such
      as
   <code class="literal">
    d
   </code>
   or
   <code class="literal">
    f
   </code>
   that can enable a
      debug operation for all applicable modifiers or just some of them:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      With no leading
      <code class="literal">
       +
      </code>
      or
      <code class="literal">
       -
      </code>
      ,
          the flag value is set to exactly the modifier list as given.
     </p>
    </li>
    <li class="listitem">
     <p>
      With a leading
      <code class="literal">
       +
      </code>
      or
      <code class="literal">
       -
      </code>
      ,
          the modifiers in the list are added to or subtracted from the
          current modifier list.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The following examples show how this works for the
   <code class="literal">
    d
   </code>
   flag. An empty
   <code class="literal">
    d
   </code>
   list
      enabled output for all debug macros. A nonempty list enables
      output only for the macro keywords in the list.
  </p>
  <p>
   These statements set the
   <code class="literal">
    d
   </code>
   value to the
      modifier list as given:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa85057396"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> debug <span class="token operator">=</span> <span class="token string">'d'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token variable">@@debug</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> @@debug <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> d       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> debug <span class="token operator">=</span> <span class="token string">'d,error,warning'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token variable">@@debug</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> @@debug         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> d,error,warning <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   A leading
   <code class="literal">
    +
   </code>
   or
   <code class="literal">
    -
   </code>
   adds to or
      subtracts from the current
   <code class="literal">
    d
   </code>
   value:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa98524719"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> debug <span class="token operator">=</span> <span class="token string">'+d,loop'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token variable">@@debug</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> @@debug              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> d,error,warning,loop <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> debug <span class="token operator">=</span> <span class="token string">'-d,error,loop'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token variable">@@debug</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> @@debug   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> d,warning <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   Adding to
   <span class="quote">
    “
    <span class="quote">
     all macros enabled
    </span>
    ”
   </span>
   results in no change:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa4335263"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> debug <span class="token operator">=</span> <span class="token string">'d'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token variable">@@debug</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> @@debug <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> d       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> debug <span class="token operator">=</span> <span class="token string">'+d,loop'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token variable">@@debug</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> @@debug <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> d       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   Disabling all enabled macros disables the
   <code class="literal">
    d
   </code>
   flag entirely:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa76595357"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> debug <span class="token operator">=</span> <span class="token string">'d,error,loop'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token variable">@@debug</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> @@debug      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> d,error,loop <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> debug <span class="token operator">=</span> <span class="token string">'-d,error,loop'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token variable">@@debug</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> @@debug <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span>         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
 </div>
 <br/>
</div>
