DB, SQL

The following provides the options related to the Node.js agent DB and SQL.

• profile_sql_param_enabled Boolean

  Default false

  Collecting SQL parameters is enabled. 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_error_sql_fetch_max Int

  Default 10000

  When the SQL Fetch Count (number of calls) exceeds the set value, it is treated as the TOO_MANY_RECORDS error. If it is set to 0, it is not treated as an error.

• profile_error_sql_time_max Int

  Default 30000

  When the SQL execution time exceeds the set value, it is treated as the SLOW_SQL error. If it is set to 0, it is not treated as an error.

• trace_sql_error_stack Boolean

  Default false

  SQL errors are stored as stacks (MySQL, MariaDB, PostgreSQL, SQL Server).

• trace_sql_error_depth Int

  Default 50

  Set the number of lines of errors to be stored when applying the trace_sql_error_stack option.

• trace_sql_normalize_enabled Boolean

  Default true

  Enables the function to normalize SQL statements by extracting the literal parts from them. The literal parts are marked with "#".