SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL
The SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL
system procedure changes the
logging level of the specified logger.
You can read more about Splice Machine loggers and logging levels in the Logging topic.
Syntax
SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL(loggerName, logLevel)
loggerName
A string specifying the name of the logger whose log level you want to find.
loggerLevel
A string specifying the new level to assign to the named logger. This must be one of the following level values, which are described in the Logging topic:
TRACE
DEBUG
INFO
WARN
ERROR
FATAL
Results
This procedure does not return a result.
Usage Notes
You can use the TRACE
option of the Splice Machine StatementManager
log to record the execution time of each statement:
splice> CALL SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL ( 'com.splicemachine.utils.SpliceUtilities', 'TRACE');
Statement executed
You can find all of the available loggers by using the
SYSCS_UTIL.SYSCS_GET_LOGGERS
system
procedure.
Example
splice> CALL SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL( 'com.splicemachine.mrio.api', 'DEBUG' );
Statement executed.