Skip to main content

DB, SQL

It provides the options related to the Python agent's DB and SQL.

  • profile_dbc_close(*) Boolean

    Default false

    If profile_connection_open_enabled is active, the closed DB connection data is output to the transaction trace.

  • trace_sql_normalize_enabled Boolean

    Default true

    It enables the function to normalize any SQL statements by extracting the literal part from each SQL statement.

  • profile_sql_param_enabled Boolean​

    Default false

    It enables the collection of SQL parameters. However, the parameters can be retrieved only by entering a separate security key. Set the security key to 6 digits in paramkey.txt of the agent installation path. If paramkey.txt does not exist, it is automatically generated and a random key is set.

  • profile_sql_resource_enabled Boolean

    Default false

    It traces the CPU and memory usages during collection of SQLs in the transaction trace. When checking the usage of resources in a transaction, it is easy to trace in divided sections.

  • stat_sql_max_count Int

    Default 5000

    It limits the number of SQL statistical data. It limits the maximum number of records for statistics collected for 5 minutes that are delivered to the server.