|
|
|
The admin-system (-vas) report displays FairCom DB Server system-wide statistics in the areas of cache usage, disk I/O, open files, established client connections, file locks, and transactions.
Example
Below is a sample admin-system report produced by executing the command:
ctstat -vas -u ADMIN -p ADMIN -s FAIRCOMS -h 10 -i 2
|
cache |
|
disk i/o |
files |
connect |
|
locks |
transactions |
|||||||
d%h |
%m |
i%h |
%m |
r/s |
w/s |
cur/max |
cur/max |
cur |
l%h |
%m |
dead |
act |
t/s |
r/t |
w/t |
99 |
1 |
99 |
1 |
1 |
1 |
2581/10000 |
2/128 |
0 |
100 |
0 |
0 |
1 |
36 |
0 |
0 |
99 |
1 |
99 |
1 |
2 |
0 |
2581/10000 |
2/128 |
0 |
100 |
0 |
0 |
1 |
35 |
0 |
0 |
99 |
1 |
99 |
1 |
2 |
0 |
2581/10000 |
2/128 |
0 |
100 |
0 |
0 |
1 |
28 |
0 |
0 |
99 |
1 |
99 |
1 |
0 |
0 |
2581/10000 |
2/128 |
0 |
100 |
0 |
0 |
1 |
22 |
0 |
0 |
The columns shown in this report are described as follows:
d%h Data cache hit rate
%m Data cache miss rate [100 - Data cache hit rate]
i%h Index cache hit rate
%m Index cache miss rate [100 - Index cache hit rate]
r/s Disk reads per second
w/s Disk writes per second
cur Current number of open files
max Server limit on number of open files
cur Current number of client connections
max Server limit on number of client connections
cur Number of locks currently held
l%h Lock hit rate [(lock attempts - locks blocked - locks denied) / lock
attempts]
%m Lock miss rate [100 - Lock hit rate]
dead Number of dead locks detected
act Current number of active transactions
t/s Number of transactions per second
r/t Number of read operations per transaction
w/t Number of write operations per transaction
log save Avg log save time per interval (microseconds) when used with the delta (-d) option
