Description of Logging Categories
When configuring logging, any combination of the following logging categories can be specified to indicate the type of messages that should appear in nuoadmin.log
.
These can be specified using the verbose
database option, though it is not recommended configure static logging with any categories that emit a large volume of messages.
Logging can be streamed dynamically using the NuoDB Command subcommand nuocmd show log-messages
.
As with verbose
database option, any combination of the following categories can be specified with the --log-options
argument, e.g. --log-options msgs,client-msgs,checkpoint
.
See About Dynamic Logging for an example.
Logging Category | Description |
---|---|
advanced-tx |
Distributed transaction processing. Mostly for internal use and advanced network diagnostics. |
archive |
Storage manager messages. |
atoms |
Low level atom processing messages. Atoms are the internal object structure representing all data and metadata in a NuoDB database. Atoms are self-coordinating objects that represent specific types of information (such as data, indexes, or schemas). Atoms are stored in memory on both Transaction Engines (TEs) and Storage Managers (SMs) and are serialized over the network and stored to disk by SMs. |
atom-gc |
Messages about garbage collection of deleted table, schema, index, or sequence atoms. |
bootstrap |
Messages sent during SQL bootstrap operations. This usually involves creating, updating and loading system tables. |
checkpoint |
Journal logging related to checkpoint counter operations. |
client-msgs |
Messages sent to and received from SQL clients. |
ddl-audit |
Generates a log entry for each DDL statement executed.
For an example of the log entries generated by |
dump |
Atom information messages. |
failure |
Failure detection messages from Transaction Engines and Storage Managers.
This information is available only when the |
filter |
Messages that match both the logging priority level and the logging category. For example:
This database option restricts log output to error and warning messages for the |
flush |
This category is deprecated. It was for internal use. |
gc |
Garbage collection messages. |
histograms |
Messages related to SQL histograms data used for index optimization. |
hotcopy |
Messages related to hot copy execution. For details of one message logged, see Example of Hot Copy Log Message. |
i18n |
NuoDB SQL client debug messages about encoding. |
index |
Index atom messages. This information might be helpful to NuoDB technical support. |
journal |
Journal messages from Storage Managers. |
login-audit |
Captures successful login attempts by the user identifying the user and the time. |
msgs |
Messages sent among NuoDB processes. |
net |
Network information regarding messages being sent among NuoDB processes. |
opt-index-selection |
SQL index selection optimization messages. |
opt-joins |
SQL join optimization messages. |
ping |
Messages checking connectivity between NuoDB processes. |
records |
Messages regarding the internal records that represent data in NuoDB. |
record-reuse |
Messages tracking assignment and reuse of record IDs. |
registry |
Information messages about databases, schemas and sequences. This information might be helpful to NuoDB technical support. |
scheduler |
Not currently used. |
security |
Messages detailing security events in the system. This includes messages for all login attempts (success or failure), all DDL statements that return a SECURITY_ERROR error code and failed attempts to access objects due to insufficient privileges. |
services |
Messages related to problems with a client connection to a |
sql |
Miscellaneous messages related to SQL statement and query processing. |
sql-index-condition-filtering |
Messages to facilitate understanding of the |
sql-params |
Messages related to parameters given in SQL parameterized statements.
|
sql-results |
Messages which capture query results to facilitate debugging and diagnostics. These messages include connection and transaction IDs. |
sql-statements |
This category prints the SQL text. |
This category prints the query execution plan that was selected for the statement being executed, complete with execution counters, where available. |
|
This category prints the following information:
|
|
sql-workload |
This category prints the application workload.
When used in combination with |
stats |
Messages regarding performance statistics. |
table-events |
Between transaction engines, these messages are about SQL DDL changes. This information might be helpful to NuoDB technical support. |
threads |
Messages about threads in Transaction Engines and Storage Managers. |
transactions |
This category is deprecated. It is supported for backwards compatibility only. Use tx instead. |
transaction-manager |
Messages about the Transaction Manager atom. Less verbose than tx. |
tx |
Messages about transaction processing. |
validate |
Messages about database object validation. |
xa |
Messages about XA transactions. |