The SSDB command line tool ssdb-cli is very usefull for SSDB administration, you can execute all SSDB commands with it, monitoring the status of a SSDB instance, flush a database, etc.
$ /usr/local/ssdb/ssdb-cli -h 127.0.0.1 -p 8888
ssdb (cli) - ssdb command line tool.
Copyright (c) 2012-2013 ideawu.com
'h' or 'help' for help, 'q' to quit.
ssdb 127.0.0.1:8888>
Type in 'h', and press Enter key to see the help messages. Here is screenshot of demo operates:
ssdb 127.0.0.1:8888> set k 1
ok
(0.000 sec)
ssdb 127.0.0.1:8888> get k
1
(0.000 sec)
ssdb 127.0.0.1:8888> del k
ok
(0.000 sec)
ssdb 127.0.0.1:8888> get k
error: not_found
(0.000 sec)
ssdb 127.0.0.1:8888>
Run
tools\ssdb-cli.bat
From within the ssdb-master source code folder, Python 2.x executable is required, also, the path must be set in the System Environment Variables.
If you see strange outputs in the screen after queries, copy this whole line into ssdb-cli and press Enter key:
: escape
The info command shows the basic info about data stored in SSDB, and the health degree of LevelDB.
ssdb 127.0.0.1:8899> info
version
1.8.0
links
1
total_calls
4
dbsize
1829
binlogs
capacity : 10000000
min_seq : 1
max_seq : 74
replication
client 127.0.0.1:55479
type : sync
status : SYNC
last_seq : 73
replication
slaveof 127.0.0.1:8888
id : svc_2
type : sync
status : SYNC
last_seq : 73
copy_count : 0
sync_count : 44
leveldb.stats
Compactions
Level Files Size(MB) Time(sec) Read(MB) Write(MB)
--------------------------------------------------
0 0 0 0 0 0
1 1 0 0 0 0
25 result(s) (0.001 sec)
links
The number of currently connected connections(links).
total_calls
The number total request handled since server startup.
dbsize
The approximate size of the database, in bytes(it could be very different from disk usage). If the server enable compression, the size will be of the compressed data.
binlogs
replication
key_range.*
Keys of different types are sorted in SSDB, so this shows the minimum key and maximum key of each data type.
leveldb.stats
This shows how many files and the amount of size of each level. The smaller the size of lower(with smaller number) level is, the healthier the database is(read operations are faster).
ssdb 127.0.0.1:8899> info cmd
version
1.6.7
cmd.get
calls: 20000 time_wait: 27 time_proc: 472
cmd.set
calls: 267045 time_wait: 7431 time_proc: 7573
cmd.setx
calls: 111100 time_wait: 3663 time_proc: 6456
cmd.del
calls: 0 time_wait: 0 time_proc: 0
cmd.*
This command force the SSDB server to do compactaction on data, after the compaction, queries are usually much faster.
You should notice that compact may slow down the service, especially when the database is big. So, you should execute this command when the server is idle.
You can try SSDB GUI tools: