显示数据库引擎属性

可能有时您希望为每个进程验证Nuodb数据库进程属性。本节包括使用各种过滤方法显示数据库进程属性的命令。

The following commands are issued using NuoDB Command (nuocmd). For more information on NuoDB Command and other command line tools, see 命令行工具.
nuocmd --show-json get processes [--db-name database_name]
nuocmd --show-json-fields hostname,type,labels get processes [--db-name database_name]
nuocmd --show-json-fields hostname,type,labels get sql-connection --db-name <database name> --connection-properties property "property value"

The following image shows an example of displaying only desired attributes (using the --show-json-fields argument) by running nuocmd --show-json-fields hostname,type,labels get processes [--db-name database_name].

OpenShift nuocmd getJson2.

The following image shows an example of confirming a matching Transaction Engine (TE) for a given LBQuery or LBPolicy expression (using the nuocmd get sql-connection sub-command) by running nuocmd --show-json-fields hostname,type,labels get sql-connection --db-name <database name> --connection-properties property "property value".

OpenShift nuocmd getJson3.

上面的图像说明了名为“TEST-TE-1-1”的TE的确认,该TE命名为“测试-TE-1-1”与给定的LBQuery表达式匹配。