xSQL Server Instrumentation

xSQL is a highly configurable database server. To start xSQL as a server it is simply necessary to specify a port number for remote clients to connect to. For example, the following command (run in directory samples\xsql\scripts) starts xSQL as a server for an in-memory database of 100Mb, listening on port 5000 and using configuration file xsql.cfg:

 
    ..\..\..\target\bin\xsql.exe -size 100m -p 5000 -c xsql.cfg
     

There are a number of command line options and alternatively a configuration file can be used to specify a rich variety of xSQL startup and runtime parameters.

Please use the links in the following table to view the specified server instrumentation capabilities:

Storage	Examine database storage usage
Security	Security Parameters
Logging	Logging runtime statistics and session activity
AIO	Asynchronous file I/O for Persistent Databases
Automatic Restart	Automatic restart of the xSQL server after it has been terminated abruptly
Recover	Recovering shared memory databases
xtop	Using the Unix-Linux xtop utility to display xSQL runtime statistics