About Dynamic Logging

Dynamic logging is available when using NuoDB Manager on the command line. That is, you specify the --command option and specify the log command. Logging is not supported in NuoDB Manager's interactive mode.

The following example shows execution of nuodbmgr with the --command "log..." option and dynamic logging going directly to stdout. The logging requested is for all SQL statements being executed.

$ nuodbmgr --broker ec2-54-165-58-157.compute-1.amazonaws.com --password bruin 
     --command 'log domain categories sql-statements'

 ...

2014-10-07T18:08:07.664+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:SELECT * FROM "PLAYERS" executed in 
   5 micros
2014-10-07T18:08:07.733+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:ResultSet[2] append 100021 bytes for 
   1647 rows in 53545 micros
2014-10-07T18:08:07.750+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [4,6302724]:select tableName,tableId,currentVersion,
   schema,viewDefinition,cardinality,subtype,extends from system.Tables where 
   tableName=? and schema=? executed in 53 micros
2014-10-07T18:08:07.750+0000: [TE] ip-172-31-46-122/54.165.58.157:48006
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [4]: Txn 6302724 committed in 7, open for 63 micros
2014-10-07T18:08:07.750+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:select getconnectionid(), getnodeid() 
   from dual executed in 2 micros
2014-10-07T18:08:07.750+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:ResultSet[4] append 9 bytes for 1 
   rows in 7 micros
2014-10-07T18:08:07.752+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:ResultSet[4] returned total 9 bytes 
   for 1 rows. Open for 1816 micros
2014-10-07T18:08:08.070+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:SELECT EXECID FROM SYSTEM.CONNECTIONS 
   WHERE connid = ? and nodeid = ? and sqlstring in ('SELECT * FROM "PLAYERS"') 
   executed in 302662 micros
2014-10-07T18:08:08.070+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:ResultSet[6] append 11 bytes for 0 
   rows in 12 micros
2014-10-07T18:08:08.074+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:ResultSet[6] returned total 11 bytes 
   for 0 rows. Open for 4568 micros
2014-10-07T18:08:08.568+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8,6302596]:ResultSet[2] returned total 100021 
   bytes for 1647 rows. Open for 913350 micros
2014-10-07T18:08:08.569+0000: [TE] ip-172-31-46-122/54.165.58.157:48006 
   (us-east-1) [ pid = 15197 ] [ db = test ] [ nodeId = 4 ] RUNNING=>
   [debug,sql-statements] [8]: Txn 6302596 committed in 14, open for 914325
   micros