# xSQL Tracing Framework

> As explained in the Tracing Framework page, eXtremeDB provides APIs that allow applications to output trace and debugging information to a log file. Please view the C API Tracing Framework page for details about the various tracing options. For xSQL these options are specified in the config file `trace_params` section.

> ### For an overview see page xSQL Configurations File Options

# Configuration File Example

> The following configuration file example shows how the various tracing options can be set:

>         # Tracing parameters
>         trace_params :
>         {
>             # Specifies filename where tracing will go. It's possible to specify "stderr"
>             # to pass all the messages to standard error stream
>             file : "xsql.log",

>             # Format for the messages. Format specifiers are:  %s and  %e
>             format: "%s:  %e",

>             # Maximum severity for messages appearing in the trace file
>             # Possible values are: verbose, debug, info, notice, warning, error, fatal
>             severity: info,

>             # Options that control if the file will be closed and reopened for each written record.
>             # Possible values are: leave_opened, keep_closed
>             options: keep_closed
>         }