The ssdb-cli Command Line Tool

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.

Connect to a SSDB server

$ /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>

For Windows users:

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.

Escape binary data

If you see strange outputs in the screen after queries, copy this whole line into ssdb-cli and press Enter key:

: escape

Monitoring the status of SSDB instance

info

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).

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).

info cmd

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.*

compact

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.

SSDB GUI tools

You can try SSDB GUI tools: