首页   快速返回

aerospike工具aql
文章分类 aerospike
-h 
        The hostname to the server connect to. Default: 127.0.0.1

-p 
        The port number of the server to connect to. Default: 3000
 
-U 
        User name used to authenticate with cluster. Default: none
 
 
-P[]
        Password used to authenticate with cluster. Default: none
 
        User will be prompted on command line if -P specified and no password is given.

-h 服务器ip,默认为:127.0.0.1
-p 端口号。默认为:3000
-c 执行指定的命令
-f 执行的命令在指定的文件中
-v启用详细输出
-e打开命令的反馈模式  

aql -c 'show namespaces'
aql -c 'show sets;show namespaces'

show namespaces

show sets

显示test下的所有索引
show indexes test

创建索引 索引存储的类型 NUMERIC or STRING
create testindex on test.testset(binx) numeric

删除索引 
drop index test testindex

正在运行的查询
show queries

正在运行的扫描
show scans


namespace.dataset
     
INSERT INTO ns1.test (PK,id,name) VALUES ('1',1,'cat')

INSERT INTO ns1.test (PK,id,name) VALUES ('2',2,'dog')

select * from   ns1.test
+----+-------+
| id | name  |
+----+-------+
| 1  | "cat" |
| 2  | "dog" |
+----+-------+
2 rows in set (1.755 secs)


        
MANAGE UDFS


REGISTER MODULE '~/test.lua'
SHOW MODULES
DESC MODULE test.lua
REMOVE MODULE test.lua




SELECT * FROM ns1.data_clean WHERE PK = 'a'
 


STAT NAMESPACE ns1
STAT SYSTEM

Secondary Index Statistics
STAT INDEX  




aerospike工具集aql
https://blog.csdn.net/songhuiqiao/article/details/50262647

https://www.cnblogs.com/xiaoit/p/4552648.html

上一篇     下一篇
影响生活的14个心理效应

一盘红烧肉告诉你本科硕士博士论文的区别

druid连接池推荐配置

监控系统相关资料整理

gossip简单介绍

redis持久化与恢复