aql输出格式和TTL设置
所属分类 aerospike
浏览量 2025
record_ttl 设置默认 TTL time to live
RECORD_PRINT_METADATA 显示元数据(TTL gen) 记录存活时间 记录更新次数
last-update-time (LUT) 上次更新时间,内部元数据,不会返回给客户端。
key_send 是否发送保存key , 设置为true , 查询时会返回 pk
SETTINGS
ECHO (true | false, default false)
VERBOSE (true | false, default false)
OUTPUT (TABLE | JSON | MUTE | RAW, default TABLE)
OUTPUT_TYPES (true | false, default true)
TIMEOUT (time in ms, default: 1000)
SOCKET_TIMEOUT (time in ms, default: -1)
LUA_USERPATH , default : /opt/aerospike/usr/udf/lua
USE_SMD (true | false, default false)
RECORD_TTL (time in sec, default: 0)
RECORD_PRINT_METADATA (true | false, default false, prints record metadata)
REPLICA_ANY (true | false, default false)
KEY_SEND (true | false, default false)
DURABLE_DELETE (true | false, default false)
FAIL_ON_CLUSTER_CHANGE (true | false, default true, policy applies to scans)
SCAN_PRIORITY priority of scan (LOW, MEDIUM, HIGH, AUTO), default : AUTO
NO_BINS (true | false, default false, No bins as part of scan and query result)
LINEARIZE_READ (true | false, default false, Make read linearizable, applicable only for namespace with strong_consistency enabled.)
这些设置只在当前会话生效,退出重新登录后恢复默认设置
aql> get record_ttl
RECORD_TTL = 0
aql> set record_ttl 1000
RECORD_TTL = 1000
# 设置 默认ttl 为 1000 s,会影响后续的操作
aql> select * from ns1.data_clean where pk='a'
+------+
| DATA |
+------+
| "a" |
+------+
1 row in set (0.002 secs)
OK
aql> get RECORD_PRINT_METADATA
RECORD_PRINT_METADATA = false
# 默认不显示记录元数据信息
aql> set RECORD_PRINT_METADATA true
RECORD_PRINT_METADATA = true
# 设置显示记录元数据信息 (generate TTL)
aql> select * from ns1.data_clean where pk='a'
+------+---------+-------+
| DATA | {ttl} | {gen} |
+------+---------+-------+
| "a" | 7775610 | 1 |
+------+---------+-------+
1 row in set (0.002 secs)
OK
aql> INSERT INTO ns1.data_clean (PK,DATA) VALUES ('a','a')
OK, 1 record affected.
# 执行 insert (新增或更新)
aql> select * from ns1.data_clean where pk='a'
+------+-------+-------+
| DATA | {ttl} | {gen} |
+------+-------+-------+
| "a" | 952 | 2 |
+------+-------+-------+
1 row in set (0.002 secs)
# ttl 使用设置的默认 1000 , 更新后 GEN 增加
aql> INSERT INTO ns1.data_clean (PK,DATA) VALUES ('a','new')
OK, 1 record affected.
aql> select * from ns1.data_clean where pk='a'
+-------+-------+-------+
| DATA | {ttl} | {gen} |
+-------+-------+-------+
| "new" | 975 | 3 |
+-------+-------+-------+
1 row in set (0.001 secs)
aql> get key_send
KEY_SEND = false
# 默认不会保存 key
aql> set key_send true
KEY_SEND = true
# 设置为发送保存key
aql> INSERT INTO ns1.data_clean (PK,DATA) VALUES ('a','new2')
OK, 1 record affected.
aql> select * from ns1.data_clean where pk='a'
+-----+--------+-------+-------+
| PK | DATA | {ttl} | {gen} |
+-----+--------+-------+-------+
| "a" | "new2" | 979 | 4 |
+-----+--------+-------+-------+
1 row in set (0.001 secs)
# 返回结果显示 PK
aql> get all
ECHO = false
VERBOSE = false
OUTPUT = TABLE
OUTPUT_TYPES = true
TIMEOUT = 1000
LUA_USERPATH = /opt/aerospike/usr/udf/lua
USE_SMD = false
RECORD_TTL = 0
RECORD_PRINT_METADATA = false
REPLICA_ANY = false
KEY_SEND = false
DURABLE_DELETE = false
FAIL_ON_CLUSTER_CHANGE = true
SCAN_PRIORITY = AUTO
NO_BINS = false
LINEARIZE_READ = false
上一篇
下一篇
maven处理本地jar包依赖
spring bean 生命周期实例
spring4种注入方式
aerospike使用truncate删除历史数据
zookeeper常用运维命令
mysql innodb 索引原理