Postgres Plus Advanced Server Performance Features Guide :

2.2.1 Command Line Options

To view the command line options for the edb-icache daemon, use the following command from the edb_Infinite Cache subdirectory, located in the Advanced Server installation directory:

    # edb-icache -h

The command line options are:

Parameter	Description
-p <port_number>	The TCP port number the Infinite Cache daemon is listening on. The default is 11211.
-U <UDP_number>	The UDP port number the Infinite Cache daemon is listening on. The default is 0 (off).
-s <pathname>	The Unix socket pathname the Infinite Cache daemon is listening on. If included, the server limits access to the host on which the Infinite Cache daemon is running, and disables network support for Infinite Cache.
-a <mask>	The access mask for the Unix socket, in octal form. The default value is 0700.
-l <ip_addr>	Specifies the IP address that the daemon is listening on. If an individual address is not specified, the default value is INDRR_ANY; all IP addresses assigned to the resource are available to the daemon.
-d	run as a daemon
-r	maximize core file limit
-u <username>	Assume the identity of the given user (when run as root).
-m <numeric>	max memory to user for items in megabytes, default is 64 MB
-M	return error on memory exhausted (rather than removing items)
-c <numeric>	Max simultaneous connections, default is 1024
-k	lock down all paged memory. Note that there is a limit on how much memory you may lock. Trying to allocate more than that would fail, so be sure you set the limit correctly for the user you started the daemon with (not for -u <username> user; under sh this is done with 'ulimit -S -l NUM_KB').
-v	verbose (print errors/warnings while in event loop)
-vv	very verbose (include client commands and responses)
-h	print the help and exit
-i	print memcached and libevent licenses
-b	run a managed instance (mnemonic: buckets)
-P <file>	save PID in <file>, only used with -d option
-f <factor>	chunk size growth factor, default 1.25
-n <bytes>	minimum space allocated for key+value+flags, default 48

2.2.2 edb-icache-tool

edb-icache-tool provides a command line interface that queries the edb-icache daemon to retrieve statistical information about a specific cache node. The syntax is:

    edb-icache-tool <host[:port]> stats

host specifies the address of the host that you are querying.

port specifies the port that the daemon is listening on.

The following command retrieves statistical information about an Infinite Cache server located at the address, 192.168.23.85 and listening on port 11211:

    # edb-icache-tool 192.168.23.85:11211 stats

Field                  Value
bytes                  1051681421
bytes_read             1410538244
bytes_written          42544414583
cmd_get                5139685
cmd_set                126588
connection_structures  104
curr_connections       4
curr_items             126588
evictions              0
get_hits               5139530
get_misses             155
limit_maxbytes         1073741824
pid                    3047
pointer_size           32
rusage_system          109.077417
rusage_user            21.423743
threads                1
time                   1242367107
total_connections      115
total_items            126588
uptime                 1095
version                1.2.6

EnterpriseDB is the enterprise Postgres and open source database company, offering productized distributions of the PostgreSQL database, also referred to as the Postgres database. EnterpriseDB has two distributions of PostgreSQL. Postgres Plus Standard Server is often used in MySQL migration efforts, and Postgres Plus Advanced Server is often used in Oracle migration projects and includes Oracle compatibility to cut Oracle costs. Visit the EnterpriseDB website to download Postgres, to download PostgreSQL, or to inquire about Postgres services or PostgreSQL services. EnterpriseDB, who employs Postgres leaders including Bruce Momjian and Dave Page, is the leader in supporting Postgres data and PostgreSQL data applications.