CmonStats properties
The samples provided the backend are object oriented constructs (they are grouped into classes and these classes support inheritance). Every sample inherits the properties of the CmonStats class. The properties of the CmonStats:
created
The epoch time of the first measurement held by this sample. The type is ulonglong, the default value is 0.hostid
The ID of the host (hostname). The type is int, the default value is 0.interval
Sample length in milliseconds. The type is int, the default value is 0, the unit of measurement is "ms".sampleends
Sample start time. The type is ulonglong, the default value is 0.samplekey
A unique string ID identifies the sample set. The type is string, the default value is "".serverid
The unique identifier of the CmonHost instance (for co-located services). The type is int, the default value is 0.
CmonDiskStat properties
The CmonDiskStat samples hold information about one specific disk partition on one specific computer.
blocksize
The used blocksize. The type is int, the default value is 0, the unit of measurement is "byte".device
The device name of the partition (e.g. /dev/hda1). The type is string, the default value is "".filesystem
The name of the file-system (e.g. ext3). The type is string, the default value is "".free
The size of the free part on the partition in bytes. The type is ulonglong, the default value is 0.mount_option
The options used when the device was mounted. The type is string, the default value is "".mountpoint
The mount point of the given partition (e.g. /home). The type is string, the default value is "".reads
Shows how many read (IO number, not bytes) operation was performed in the sample interval. The type is ulonglong, the default value is 0.readspersec
Shows how many read operation was performed in one seconds. One could calculate a similar value by dividing the number of writes with the length of the interval, but that would provide the average speed while the 'readpersec' is the maximum of this speed found while sampling. For IOPS graphs. The type is ulonglong, the default value is 0, the unit of measurement is "1/s".sectorsread
Shows how much data read has been performeed in the sample interval. The type is ulonglong, the default value is 0.sectorswritten
Shows how much data write has been performeed in the sample interval. The type is ulonglong, the default value is 0.total
The total size of the partition in bytes. The type is ulonglong, the default value is 0.utilization
A percent value (between 0.0 and 1.0) that shows how much time of the disk was actually used. The type is double, the default value is 0, the unit of measurement is "%".writes
Shows how many write (IO number, not bytes) operation was performed in the sample interval. The type is ulonglong, the default value is 0.writespersec
Shows how many write operation was performed in one seconds. One could calculate a similar value by dividing the number of writes with the length of the interval, but that would provide the average speed while the 'writespersec' is the maximum of this speed found while sampling. For IOPS graphs. The type is ulonglong, the default value is 0, the unit of measurement is "1/s".
CmonCpuStats properties
The CmonCpuStats obejcts hold information about one specific CPU and a computer that holds it in the cluster. Since one computer can hold multiple processors, the same data (e.g. uptime) might be found in more than one sample.
busy
Same as 'user' + 'sys'. The type is double, the default value is 0, the unit of measurement is "%".cpuid
The numerical ID for the given CPU. Valid IDs start from 0. The type is int, the default value is -1.cpumhz
The maximum of the real CPU frequency measured in megaHertz. The type is int, the default value is 0, the unit of measurement is "MHz".cpumodelname
The model name is a human readable string representing the model of the physical CPU. The type is string, the default value is "".cpuphysicalid
When a CPU has multiple cores the entries with different CPU IDs has the same physical ID. The type is int, the default value is -1.cputemp
The CPU temperature measured in Celsius. The type is double, the default value is 0.guest
Time spent running a virtual CPU for guest operating systems. The type is double, the default value is 0, the unit of measurement is "%".idle
Similar to 'user', but this shows how much CPU time is not used/free. The type is double, the default value is 0, the unit of measurement is "%".iowait
Similar to 'user', but this shows how much CPU time is spent waiting for the I/O. The type is double, the default value is 0, the unit of measurement is "%".irq
Time servicing interrupts and softirqs. The type is double, the default value is 0, the unit of measurement is "%".loadavg1
The one minute load average reported by the given host. The type is int, the default value is -1.loadavg15
Load average for 15 minutes. The type is int, the default value is -1.loadavg5
Load average for 5 minutes. The type is int, the default value is -1.steal
Similar to 'user' but it shows how much CPU time is lost becauseother virtual machine took the CPU. The type is double, the default value is 0, the unit of measurement is "%".sys
Similar to 'user', but this shows how much CPU time is used in kernel mode. The type is double, the default value is 0, the unit of measurement is "%".uptime
The uptime of the computer in seconds. The type is ulonglong, the default value is 0.user
This property shows how much of the processor time is used in user mode. The type is double, the default value is 0, the unit of measurement is "%".
CmonMemoryStats properties
The CmonMemoryStats objects hold information about the operational memory and the virtual memory of one given host.
memoryutilization
The ratio of used memory. The type is double, the default value is 0, the unit of measurement is "%".pgpgin
The number of pages paged in since boot. The type is ulonglong, the default value is 0.pgpgout
The number of pages paged out in since boot. The type is ulonglong, the default value is 0.pswpin
The number of pages swapped in since boot. The type is ulonglong, the default value is 0.pswpout
The number of pages swapped out since boot. The type is ulonglong, the default value is 0.rambuffers
The amount of physical RAM used for file buffers. The type is ulonglong, the default value is 0, the unit of measurement is "byte".ramcached
The amount of physical RAM, used as cache memory. The type is ulonglong, the default value is 0, the unit of measurement is "byte".ramfree
The amount of physical RAM, left unused by the system. The type is ulonglong, the default value is 0, the unit of measurement is "byte".ramfreemin
The minimum value of the free RAM property in the interval. The type is ulonglong, the default value is 0, the unit of measurement is "byte". This property is private, accessible only for the controller.ramtotal
Total amount of physical RAM. The type is ulonglong, the default value is 0, the unit of measurement is "byte".swapfree
The total amount of swap free. The type is ulonglong, the default value is 0.swaptotal
The total amount of swap available. The type is ulonglong, the default value is 0.swaputilization
The ratio of used swap. The type is double, the default value is 0, the unit of measurement is "%".
CmonNetworkStats properties
The CmonNetworkStats class samples holds information about one specific network interface in a specific computer.
The network statistics will inherit the fields decribed in the CmonStats properties section.
interface
The name of the interface. The type is string, the default value is "".rxBytes
The number of the received bytes. The type is ulonglong, the default value is 0, the unit of measurement is "byte".rxDrops
The number of dropped packages while transmitting. The type is ulonglong, the default value is 0, the unit of measurement is "pocket".rxErrors
The number of malformed packages received. The type is ulonglong, the default value is 0, the unit of measurement is "pocket".rxFrames
Packets received with frame error I think. The type is ulonglong, the default value is 0, the unit of measurement is "frame".rxMulticasts
The number of multicast packages received. The type is ulonglong, the default value is 0, the unit of measurement is "pocket".rxPackets
The number of the received packets. The type is ulonglong, the default value is 0, the unit of measurement is "pocket".txBytes
The number of the sent bytes. The type is ulonglong, the default value is 0, the unit of measurement is "byte".txDrops
The number of dropped packages. The type is ulonglong, the default value is 0, the unit of measurement is "pocket".txErrors
The number of errors while transmitting. The type is ulonglong, the default value is 0, the unit of measurement is "pocket".txPackets
The number of the sent packets. The type is ulonglong, the default value is 0, the unit of measurement is "pocket".
CmonSqlStats properties
Some SQL statistics are available for every individual databases some are available for every server. The CmonSqlStats class holds data for a server and not for a database.
ABORTED_CLIENTS
The number of connections that were aborted because the client died without closing the connection properly. The type is int, the default value is 0. This property is a counter data-type.ABORTED_CONNECTS
The number of failed attempts to connect to the MySQL server. The type is int, the default value is 0. This property is a counter data-type.ARCHIVED_COUNT
Number of WAL files that have been successfully archived. The type is int, the default value is 0. This property is a counter data-type.BUFFERS_ALLOC
Number of buffers allocated. The type is int, the default value is 0, the unit of measurement is "buffer". This property is a counter data-type.BUFFERS_BACKEND
Number of buffers written directly by a backend. The type is int, the default value is 0, the unit of measurement is "buffer". This property is a counter data-type.BUFFERS_BACKEND_FSYNC
Number of times a backend had to execute its own fsync call. The type is int, the default value is 0. This property is a counter data-type.BUFFERS_CHECKPOINT
Number of buffers written during checkpoints. The type is int, the default value is 0, the unit of measurement is "buffer". This property is a counter data-type.BUFFERS_CLEAN
Number of buffers written by the background writer. The type is int, the default value is 0. This property is a counter data-type.BYTES_RECEIVED
Total size (in bytes) of received by server. The type is int, the default value is 0, the unit of measurement is "seconds". This property is a counter data-type.CHECKPOINTS_REQ
Number of requested checkpoints that have been performed. The type is int, the default value is 0. This property is a counter data-type.CHECKPOINTS_TIMED
Number of scheduled checkpoints that have been performed. The type is int, the default value is 0. This property is a counter data-type.CHECKPOINT_SYNC_TIME
Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, in milliseconds. The type is int, the default value is 0, the unit of measurement is "ms". This property is a counter data-type.CHECKPOINT_WRITE_TIME
Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds. The type is double, the default value is 0, the unit of measurement is "ms". This property is a counter data-type.COM_DELETE
The number of times the DELETE statement has been executed. The type is int, the default value is 0. This property is a counter data-type.COM_INSERT
The number of times the INSERT statement has been executed. The type is int, the default value is 0. This property is a counter data-type.COM_REPLACE
The number of times the REPLACE statement has been executed. The type is int, the default value is 0. This property is a counter data-type.COM_SELECT
The number of times the SELECT statement has been executed. The type is int, the default value is 0. This property is a counter data-type.COM_UPDATE
The number of times the UPDATE statement has been executed. The type is int, the default value is 0. This property is a counter data-type.CONNECTIONS
The number of connection attempts (successful or not) to the MySQL server. The type is int, the default value is 0. This property is a counter data-type.CREATED_TMP_DISK_TABLES
The number of internal on-disk temporary tables created by the server while executing statements. The type is int, the default value is 0, the unit of measurement is "table". This property is a counter data-type.CREATED_TMP_FILES
How many temporary files mysqld has created. The type is int, the default value is 0. This property is a counter data-type.CREATED_TMP_TABLES
The number of internal temporary tables created by the server while executing statements. The type is int, the default value is 0, the unit of measurement is "table". This property is a counter data-type.FAILED_COUNT
Number of failed attempts for archiving WAL files. The type is int, the default value is 0. This property is a counter data-type.HANDLER_DELETE
The number of times that rows have been deleted from tables. The type is int, the default value is 0. This property is a counter data-type.HANDLER_READ_FIRST
The number of times the first entry in an index was read. The type is int, the default value is 0. This property is a counter data-type.HANDLER_READ_KEY
The number of requests to read a row based on a key. The type is int, the default value is 0. This property is a counter data-type.HANDLER_READ_LAST
The number of requests to read the last key in an index. The type is int, the default value is 0. This property is a counter data-type.HANDLER_READ_NEXT
The number of requests to read the next row in key order. The type is int, the default value is 0. This property is a counter data-type.HANDLER_READ_PREV
The number of requests to read the previous row in key order. The type is int, the default value is 0. This property is a counter data-type.HANDLER_READ_RND
The number of requests to read a row based on a fixed position. The type is int, the default value is 0. This property is a counter data-type.HANDLER_READ_RND_NEXT
The number of requests to read the next row in the data file. The type is int, the default value is 0. This property is a counter data-type.HANDLER_UPDATE
The number of requests to update a row in a table. The type is int, the default value is 0. This property is a counter data-type.HANDLER_WRITE
The number of requests to insert a row in a table. The type is int, the default value is 0. This property is a counter data-type.INNODB_BUFFER_POOL_PAGES_DATA
The number of pages in the InnoDB buffer pool containing data. The type is int, the default value is 0, the unit of measurement is "page".INNODB_BUFFER_POOL_PAGES_DIRTY
The current number of dirty pages in the InnoDB buffer pool. The type is int, the default value is 0, the unit of measurement is "page".INNODB_BUFFER_POOL_PAGES_FLUSHED
The number of requests to flush pages from the InnoDB buffer pool. The type is int, the default value is 0. This property is a counter data-type.INNODB_BUFFER_POOL_PAGES_FREE
The number of free pages in the InnoDB buffer pool. The type is int, the default value is 0, the unit of measurement is "page".INNODB_BUFFER_POOL_PAGES_LRU_FLUSHED
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.INNODB_BUFFER_POOL_PAGES_MADE_NOT_YOUNG
Pages not young as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output. The type is int, the default value is 0, the unit of measurement is "page".INNODB_BUFFER_POOL_PAGES_MADE_YOUNG
Pages made young as shown in the INSERT BUFFER AND ADAPTIVE HASH INDEX section of the SHOW ENGINE INNODB STATUS output. The type is int, the default value is 0, the unit of measurement is "page".INNODB_BUFFER_POOL_PAGES_MISC
The number of pages in the InnoDB buffer pool that are busy because they have been allocated for administrative overhead The type is int, the default value is 0, the unit of measurement is "page".INNODB_BUFFER_POOL_PAGES_OLD
Undocumented property. The type is int, the default value is 0, the unit of measurement is "byte".INNODB_BUFFER_POOL_PAGES_TOTAL
The total size of the InnoDB buffer pool, in pages. The type is int, the default value is 0, the unit of measurement is "page".INNODB_DATA_FSYNCS
The number of fsync() operations so far. The type is int, the default value is 0. This property is a counter data-type.INNODB_DATA_PENDING_FSYNCS
The current number of pending fsync() operations. The type is int, the default value is 0.INNODB_DATA_PENDING_READS
The current number of pending reads. The type is int, the default value is 0.INNODB_DATA_PENDING_WRITES
The current number of pending writes. The type is int, the default value is 0.INNODB_DATA_READ
The amount of data read since the server was started. The type is int, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.INNODB_DATA_READS
The total number of data reads. The type is int, the default value is 0. This property is a counter data-type.INNODB_DATA_WRITES
The total number of data writes. The type is int, the default value is 0. This property is a counter data-type.INNODB_DATA_WRITTEN
The amount of data written so far, in bytes. The type is int, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.INNODB_LOG_WAITS
Number of times InnoDB was forced to wait for log writes to be flushed due to the log buffer being too small. The type is int, the default value is 0.INNODB_LSN_CURRENT
Log sequence number. The type is int, the default value is 0.INNODB_LSN_FLUSHED
Flushed up to log sequence number. The type is int, the default value is 0.INNODB_LSN_LAST_CHECKPOINT
Log sequence number last checkpoint. The type is int, the default value is 0.INNODB_OS_LOG_FSYNCS
The number of fsync() writes done to the InnoDB redo log files. The type is int, the default value is 0, the unit of measurement is "write". This property is a counter data-type.INNODB_OS_LOG_WRITTEN
The number of bytes written to the InnoDB redo log files. The type is int, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.INNODB_PAGES_CREATED
The number of pages created by operations on InnoDB tables. The type is int, the default value is 0, the unit of measurement is "page". This property is a counter data-type.INNODB_PAGES_READ
The number of pages read by operations on InnoDB tables. The type is int, the default value is 0, the unit of measurement is "page". This property is a counter data-type.INNODB_PAGES_WRITTEN
The number of pages written by operations on InnoDB tables. The type is int, the default value is 0, the unit of measurement is "page". This property is a counter data-type.MAXWRITTEN_CLEAN
Number of times the background writer stopped a cleaning scan because it had written too many buffers. The type is int, the default value is 0. This property is a counter data-type.OPENED_TABLES
The number of tables that have been opened. The type is int, the default value is 0, the unit of measurement is "table". This property is a counter data-type.OPEN_TABLES
The number of tables that are open. The type is int, the default value is 0, the unit of measurement is "table". This property is a counter data-type.QUERIES
The number of statements executed by the server. The type is int, the default value is 0, the unit of measurement is "statement". This property is a counter data-type.QUESTIONS
The number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the QUERIES variable. The type is int, the default value is 0, the unit of measurement is "statement". This property is a counter data-type.SELECT_FULL_JOIN
The number of joins that perform table scans because they do not use indexes. The type is int, the default value is 0, the unit of measurement is "join". This property is a counter data-type.SELECT_FULL_RANGE_JOIN
The number of joins that used a range search on a reference table. The type is int, the default value is 0, the unit of measurement is "join". This property is a counter data-type.SELECT_RANGE
The number of joins that used ranges on the first table. The type is int, the default value is 0, the unit of measurement is "join". This property is a counter data-type.SELECT_RANGE_CHECK
The number of joins without keys that check for key usage after each row. The type is int, the default value is 0, the unit of measurement is "join". This property is a counter data-type.SELECT_SCAN
The number of joins that did a full scan of the first table. The type is int, the default value is 0, the unit of measurement is "join". This property is a counter data-type.SLOW_QUERIES
The number of queries that have taken more than long_query_time seconds. The type is int, the default value is 0, the unit of measurement is "query". This property is a counter data-type.THREADS_CACHED
The number of threads in the thread cache. The type is int, the default value is 0.THREADS_CONNECTED
The number of currently open connections. The type is int, the default value is 0.THREADS_CREATED
The number of threads created to handle connections. The type is int, the default value is 0.THREADS_RUNNING
The number of threads that are not sleeping. The type is int, the default value is 0.WSREP_FLOW_CONTROL_PAUSED
The fraction of time since the last FLUSH STATUS command that replication was paused due to flow control. The type is double, the default value is 0.WSREP_FLOW_CONTROL_PAUSED_NS
Total time spent in a paused state measured in nanoseconds. The type is int, the default value is 0, the unit of measurement is "nsec". This property is a counter data-type.WSREP_FLOW_CONTROL_RECV
The number of FC_PAUSE events the node has received, including those the node has sent. The type is int, the default value is 0. This property is a counter data-type.WSREP_FLOW_CONTROL_SENT
The number of FC_PAUSE events the node has sent. The type is int, the default value is 0. This property is a counter data-type.WSREP_LOCAL_BF_ABORTS
Number of local transactions that were aborted by slave transactions while being executed. The type is int, the default value is 0, the unit of measurement is "transaction". This property is a counter data-type.WSREP_LOCAL_RECV_QUEUE
Current length of the recv queue. The type is int, the default value is 0.WSREP_LOCAL_RECV_QUEUE_AVG
Recv queue length averaged over interval since the last FLUSH STATUS command. The type is double, the default value is 0.WSREP_LOCAL_RECV_QUEUE_MAX
The maximum length of the recv queue since the last FLUSH STATUS command. The type is int, the default value is 0.WSREP_LOCAL_RECV_QUEUE_MIN
The minimum length of the recv queue since the last FLUSH STATUS command. The type is int, the default value is 0.WSREP_LOCAL_SEND_QUEUE
Current length of the send queue. The type is int, the default value is 0.WSREP_LOCAL_SEND_QUEUE_AVG
Recv queue length averaged over interval since the last FLUSH STATUS command. The type is double, the default value is 0.WSREP_LOCAL_SEND_QUEUE_MAX
The maximum length of the send queue since the last FLUSH STATUS command. The type is int, the default value is 0.WSREP_LOCAL_SEND_QUEUE_MIN
The minimum length of the send queue since the last FLUSH STATUS command. The type is int, the default value is 0.WSREP_RECEIVED_BYTES
Total size (in bytes) of writesets received from other nodes. The type is int, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.WSREP_REPLICATED_BYTES
Total size (in bytes) of writesets sent to other nodes. The type is int, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.WSREP_REPL_DATA_BYTES
Total size (in bytes) of data replicated. The type is int, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.WSREP_REPL_KEYS_BYTES
Total size (in bytes) of keys replicated. The type is int, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.WSREP_REPL_OTHER_BYTES
Total size of other bits replicated. The type is int, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.blocks-hit
Number of times disk blocks were found already in the buffer cache, so that a read was not necessary. The type is int, the default value is 0.blocks-read
Number of disk blocks read. The type is int, the default value is 0.commits
Number of transactions that have commited. The type is int, the default value is 0.connections
umber of backends currently connected to this database. The type is int, the default value is 0.rollbacks
Number of transactions that have been rolled back. The type is int, the default value is 0.rows-deleted
Number of rows deleted by queries. The type is int, the default value is 0.rows-fetched
Number of rows fetched by queries. The type is int, the default value is 0.rows-inserted
Number of rows inserted by queries. The type is int, the default value is 0.rows-updated
Number of rows updated by queries. The type is int, the default value is 0.
CmonDatabaseStats properties
The CmonDatabaseStats objects represent samples that are created about one specific database.
NOTE: this is only used currently by PostgreSQL.
blocks-hit
Number of buffer hits. The type is ulonglong, the default value is 0.blocks-read
Number of disk blocks read. The type is ulonglong, the default value is 0.databaseName
Undocumented property. The type is string, the default value is "".idx-hit
Number of buffer hits in all indexes. The type is ulonglong, the default value is 0.idx-read
Number of disk blocks read from all indexes. The type is ulonglong, the default value is 0.tidx-hit
Number of buffer hits in this table's TOAST table indexes. The type is ulonglong, the default value is 0.tidx-read
Number of disk blocks read from this table's TOAST table indexes. The type is ulonglong, the default value is 0.toast-hit
Number of buffer hits in this table's TOAST table. The type is ulonglong, the default value is 0.toast-read
Number of disk blocks read from this table's TOAST table. The type is ulonglong, the default value is 0.
CmonTcpStats properties
The CmonTcpStats objects represent samples of TCP network statistics.
TCP network error rate can be computed with this formula: 100 * retransmitted_segments / Sent_segments
received_bad_segments
Number of received tcp segments that was bad in some way. The type is ulonglong, the default value is 0.received_segments
The number of received tcp segments. The type is ulonglong, the default value is 0.retransmitted_segments
Number of tcp segments was need to be repeated. The type is ulonglong, the default value is 0.sent_segments
The number of sent tcp segments. The type is ulonglong, the default value is 0.
CmonMongoStats properties
The CmonMongoStats objects represent samples of Mongo database statistics.
asserts.msg
The number of message assertions raised since the MongoDB process started. Check the log file for more information about these messages. The type is int, the default value is 0.asserts.regular
The number of regular assertions raised since the MongoDB process started. Check the log file for more information about these messages. The type is int, the default value is 0.asserts.user
The number of 'user asserts' that have occurred since the last time the MongogDB process started. These are errors that user may generate, such as out of disk space or duplicate key. You can prevent these assertions by fixing a problem with your application or deployment. Check the MongoDB log for more information. The type is int, the default value is 0.asserts.warning
The number of warnings raised since the MongoDB process started. Check the log file for more information about these warnings. The type is int, the default value is 0.connections.available
The number of unused incoming connections available. The type is int, the default value is 0.connections.current
The number of the current connections to this server. The type is int, the default value is 0.connections.totalCreated
The total number of connections made to the database since server was started. The type is ulonglong, the default value is 0.globalLock.activeClients.readers
The number of the active client connections performing read operations. The type is int, the default value is 0.globalLock.activeClients.writers
The number of active client connections performing write operations. The type is int, the default value is 0.globalLock.currentQueue.readers
The number of operations that are currently queued and waiting for the read lock. The type is int, the default value is 0.globalLock.currentQueue.writers
The number of operations that are currently queued and waiting for the write lock. The type is int, the default value is 0.globalLock.lockTime
The value of lockTime represents the time, in microseconds, since the database last started, that the globalLock has been held. The type is int, the default value is 0.globalLock.ratio
If this ratio is closer to 1.0 than 0.0, then fewer operations are responsible for a greater portion of server’s use (relatively). The type is int, the default value is 0.globalLock.totalTime
The time, in microseconds, since the database last started. The type is int, the default value is 0.metrics.cursor.open.noTimeout
The number of open cursors with theoption DBQuery.Option.noTimeout set to prevent timeout after a period of inactivity. The type is int, the default value is 0.metrics.cursor.open.total
The number of cursors that MongoDB is maintaining for clients. Because MongoDB exhausts unused cursors, typically this value small or zero. However, if there is a queue, stale tailable cursors, or a large number of operations this value may rise. The type is int, the default value is 0.metrics.cursor.timedOut
The total number of cursors that have timed out since the server process started. If this number is large or growing at a regular rate, this may indicate an application error. The type is int, the default value is 0.network.bytesIn
The total number of bytes received since server was started. The type is ulonglong, the default value is 0.network.bytesOut
The total number of bytes sent since server was started. The type is ulonglong, the default value is 0.opcounters.command
The total number of commands since server was started. The type is int, the default value is 0.opcounters.delete
The total number of deletes since server was started. The type is int, the default value is 0.opcounters.getmore
The total number of getmore operations since server was started. The type is int, the default value is 0.opcounters.insert
The total number of insertions since server was started. The type is int, the default value is 0.opcounters.query
The total number of queries since server was started. The type is int, the default value is 0.opcounters.update
The total number of updates since server was started. The type is int, the default value is 0.replSetStatus.replicationLag
Lag (time in seconds) between the last operation applied on the primary node and this (secondary) node. The type is int, the default value is 0.wiredTiger.cache.bytes currently in the cache
Size in byte of the data currently in cache. This value should not be greater than the maximum bytes configured value. The type is int, the default value is 0.wiredTiger.cache.maximum bytes configured
Maximum cache size. The type is int, the default value is 0.wiredTiger.cache.modified pages evicted
Main statistics for page eviction. The type is int, the default value is 0.wiredTiger.cache.tracked dirty bytes in the cache
Size in bytes of the dirty data in the cache. This value should be less than the bytes currently in the cache value. The type is int, the default value is 0.wiredTiger.cache.unmodified unmodified pages evicted
Main statistics for page eviction. The type is int, the default value is 0.wiredTiger.concurrentTransactions.read.available
When the number of available read or write tickets remaining reaches zero, new read or write requests will be queued until a new read or write ticket is available. The type is int, the default value is 0.wiredTiger.concurrentTransactions.read.out
A document that returns information on the number of concurrent of read and write transactions allowed into the WiredTiger storage engine The type is int, the default value is 0.wiredTiger.concurrentTransactions.write.available
When the number of available read or write tickets remaining reaches zero, new read or write requests will be queued until a new read or write ticket is available. The type is int, the default value is 0.wiredTiger.concurrentTransactions.write.out
A document that returns information on the number of concurrent of read and write transactions allowed into the WiredTiger storage engine The type is int, the default value is 0.
CmonNdbStats properties
The CmonNdbStats objects represent samples of an NDB node.
aborts
ndbinfo.counters aborts The type is ulonglong, the default value is 0. This property is a counter data-type.commits
ndbinfo.counters commits The type is ulonglong, the default value is 0. This property is a counter data-type.dm_total_bytes
The total bytes of the DataMemory The type is ulonglong, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.dm_used_bytes
The used bytes of the DataMemory The type is ulonglong, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.im_total_bytes
The total used bytes of the IndexMemory The type is ulonglong, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.im_used_bytes
The used used bytes of the IndexMemory The type is ulonglong, the default value is 0, the unit of measurement is "byte". This property is a counter data-type.operations
ndbinfo.counters operations The type is ulonglong, the default value is 0. This property is a counter data-type.range_scans
ndbinfo.counters range_scans The type is ulonglong, the default value is 0. This property is a counter data-type.reads
ndbinfo.counters reads The type is ulonglong, the default value is 0. This property is a counter data-type.simple_reads
ndbinfo.counters simple_reads The type is ulonglong, the default value is 0. This property is a counter data-type.table_scans
ndbinfo.counters table_scans The type is ulonglong, the default value is 0. This property is a counter data-type.transactions
ndbinfo.counters transactions The type is ulonglong, the default value is 0. This property is a counter data-type.writes
ndbinfo.counters writes The type is ulonglong, the default value is 0. This property is a counter data-type.
CmonProxySqlStats properties
The CmonProxySqlStats objects represent samples of an ProxySql node.
ACTIVE_TRANSACTIONS
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.BACKEND_QUERY_TIME_NSEC
Undocumented property. The type is int, the default value is 0.CLIENT_CONNECTIONS_ABORTED
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.CLIENT_CONNECTIONS_CONNECTED
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.CLIENT_CONNECTIONS_CREATED
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.COM_AUTOCOMMIT
Undocumented property. The type is int, the default value is 0.COM_AUTOCOMMIT_FILTERED
Undocumented property. The type is int, the default value is 0.COM_COMMIT
Undocumented property. The type is int, the default value is 0.COM_COMMIT_FILTERED
Undocumented property. The type is int, the default value is 0.COM_ROLLBACK
Undocumented property. The type is int, the default value is 0.COM_ROLLBACK_FILTERED
Undocumented property. The type is int, the default value is 0.CONNPOOL_MEMORY_BYTES
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.MYSQL_BACKEND_BUFFERS_BYTES
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.MYSQL_FRONTEND_BUFFERS_BYTES
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.MYSQL_MONITOR_WORKERS
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.MYSQL_SESSION_INTERNAL_BYTES
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.MYSQL_THREAD_WORKERS
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.QUERIES_BACKENDS_BYTES_RECV
Undocumented property. The type is int, the default value is 0.QUERIES_BACKENDS_BYTES_SENT
Undocumented property. The type is int, the default value is 0.QUERY_CACHE_BYTES_IN
Undocumented property. The type is int, the default value is 0.QUERY_CACHE_BYTES_OUT
Undocumented property. The type is int, the default value is 0.QUERY_CACHE_COUNT_GET
Undocumented property. The type is int, the default value is 0.QUERY_CACHE_COUNT_GET_OK
Undocumented property. The type is int, the default value is 0.QUERY_CACHE_COUNT_SET
Undocumented property. The type is int, the default value is 0.QUERY_CACHE_ENTRIES
Undocumented property. The type is int, the default value is 0.QUERY_CACHE_MEMORY_BYTES
Undocumented property. The type is int, the default value is 0.QUERY_CACHE_PURGED
Undocumented property. The type is int, the default value is 0.QUERY_PROCESSOR_TIME_NSEC
Undocumented property. The type is int, the default value is 0.QUESTIONS
Undocumented property. The type is int, the default value is 0.SERVERS_TABLE_VERSION
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.SERVER_CONNECTIONS_ABORTED
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.SERVER_CONNECTIONS_CONNECTED
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.SERVER_CONNECTIONS_CREATED
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.SLOW_QUERIES
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.SQLITE3_MEMORY_BYTES
Undocumented property. The type is int, the default value is 0. This property is a counter data-type.
CmonHaProxyStats properties
The CmonHaProxyStats objects represent samples of an HaProxy node.
act
number of active servers (backend), server is active (server) The type is int, the default value is 0.addr
address:port or "unix". IPv6 has brackets around the address. The type is string, the default value is "".agent_code
numeric code reported by agent if any (unused for now) The type is int, the default value is 0.agent_desc
short human-readable description of agent_status The type is string, the default value is "".agent_duration
time in ms taken to finish last check The type is int, the default value is 0.agent_fall
agent's "fall" parameter, normally 1 The type is int, the default value is 1.agent_health
agent's health parameter, between 0 and rise+fall-1 The type is int, the default value is 0.agent_rise
agent's "rise" parameter, normally 1 The type is int, the default value is 1.agent_status
status of last agent check.: The type is string, the default value is "UNK".algo
load balancing algorithm The type is string, the default value is "".bck
number of backup servers (backend), server is backup (server) The type is int, the default value is 0.bin
bytes in The type is int, the default value is 0.bout
bytes out The type is int, the default value is 0.check_code
layer5-7 code, if available The type is int, the default value is 0.check_desc
short human-readable description of check_status The type is string, the default value is "".check_duration
time in ms took to finish last health check The type is int, the default value is 0.check_fall
server's "fall" parameter used by checks The type is int, the default value is 0.check_health
server's health check value between 0 and rise+fall-1 The type is int, the default value is 0.check_rise
server's "rise" parameter used by checks The type is int, the default value is 0.check_status
status of last health check. The type is string, the default value is "UNK".chkdown
number of UP->DOWN transitions. The backend counter counts transitions to the whole backend being down, rather than the sum of the counters for each server. The type is int, the default value is 0.chkfail
number of failed checks. (Only counts checks failed when the server is up.) The type is int, the default value is 0.cli_abrt
number of data transfers aborted by the client The type is int, the default value is 0.comp_byp
number of bytes that bypassed the HTTP compressor (CPU/BW limit) The type is int, the default value is 0.comp_in
number of HTTP response bytes fed to the compressor The type is int, the default value is 0.comp_out
number of HTTP response bytes emitted by the compressor The type is int, the default value is 0.comp_rsp
number of HTTP responses that were compressed The type is int, the default value is 0.conn_rate
number of connections over the last elapsed second The type is int, the default value is 0.conn_rate_max
highest known conn_rate The type is int, the default value is 0.conn_tot
cumulative number of connections The type is int, the default value is 0.cookie
server's cookie value or backend's cookie name The type is int, the default value is 0.ctime
the average connect time in ms over the 1024 last requests The type is int, the default value is 0.dcon
requests denied by "tcp-request connection" rules The type is int, the default value is 0.downtime
total downtime (in seconds). The value for the backend is the downtime for the whole backend, not the sum of the server downtime. The type is int, the default value is 0.dreq
requests denied because of security concerns. The type is int, the default value is 0.dresp
responses denied because of security concerns. The type is int, the default value is 0.dses
requests denied by "tcp-request session" rules The type is int, the default value is 0.econ
number of requests that encountered an error trying to connect to a backend server. The backend stat is the sum of the stat for all servers of that backend, plus any connection errors not associated with a particular server (such as the backend having no active servers). The type is int, the default value is 0.ereq
request errors. Some of the possible causes are: The type is int, the default value is 0.eresp
response errors. srv_abrt will be counted here also. The type is int, the default value is 0.hanafail
failed health checks details The type is int, the default value is 0.hrsp_1xx
http responses with 1xx code The type is int, the default value is 0.hrsp_2xx
http responses with 2xx code The type is int, the default value is 0.hrsp_3xx
http responses with 3xx code The type is int, the default value is 0.hrsp_4xx
http responses with 4xx code The type is int, the default value is 0.hrsp_5xx
http responses with 5xx code The type is int, the default value is 0.hrsp_other
http responses with other codes (protocol error) The type is int, the default value is 0.iid
unique proxy id The type is int, the default value is 0.intercepted
cum. number of intercepted requests (monitor, stats) The type is int, the default value is 0.last_agt
last agent check contents or textual error The type is string, the default value is "".last_chk
last health check contents or textual error The type is string, the default value is "".lastchg
number of seconds since the last UP<->DOWN transition The type is int, the default value is 0.lastsess
number of seconds since last session assigned to server/backend The type is int, the default value is 0.lbtot
total number of times a server was selected, either for new sessions, or when re-dispatching. The server counter is the number of times that server was selected. The type is int, the default value is 0.mode
proxy mode (tcp, http, health, unknown) The type is string, the default value is "unknown".pid
process id (0 for first instance, 1 for second, ...) The type is int, the default value is 0.pxname
proxy name The type is string, the default value is "".qcur
current queued requests. For the backend this reports the number queued without a server assigned. The type is int, the default value is 0.qlimit
configured maxqueue for the server, or nothing in the value is 0 (default, meaning no limit) The type is int, the default value is 0.qmax
max value of qcur The type is int, the default value is 0.qtime
the average queue time in ms over the 1024 last requests The type is int, the default value is 0.rate
number of sessions per second over last elapsed second The type is int, the default value is 0.rate_lim
configured limit on new sessions per second The type is int, the default value is 0.rate_max
max number of new sessions per second The type is int, the default value is 0.req_rate
HTTP requests per second over last elapsed second The type is int, the default value is 0.req_rate_max
max number of HTTP requests per second observed The type is int, the default value is 0.req_tot
total number of HTTP requests received The type is int, the default value is 0.rtime
the average response time in ms over the 1024 last requests (0 for TCP) The type is int, the default value is 0.scur
current sessions The type is int, the default value is 0.sid
server id (unique inside a proxy) The type is int, the default value is 0.slim
configured session limit The type is int, the default value is 0.smax
max sessions The type is int, the default value is 0.srv_abrt
number of data transfers aborted by the server (inc. in eresp) The type is int, the default value is 0.status
status (UP/DOWN/NOLB/MAINT/MAINT(via)/MAINT(resolution)...) The type is string, the default value is "".stot
cumulative number of sessions The type is int, the default value is 0.svname
service name (FRONTEND for frontend, BACKEND for backend, any name for server/listener) The type is string, the default value is "".throttle
current throttle percentage for the server, when slowstart is active, or no value if not in slowstart. The type is int, the default value is 0.tracked
id of proxy/server if tracking is enabled. The type is int, the default value is 0.ttime
the average total session time in ms over the 1024 last requests The type is int, the default value is 0.type
(0=frontend, 1=backend, 2=server, 3=socket/listener) The type is int, the default value is 0.weight
total weight (backend), server weight (server) The type is int, the default value is 0.wredis
number of times a request was redispatched to another server. The server value counts the number of times that server was switched away from. The type is int, the default value is 0.wretr
number of times a connection to a server was retried. The type is int, the default value is 0.
CmonDbStats properties
The CmonDbStats objects represent sample of DB growth.
act
number of active servers (backend), server is active (server) The type is int, the default value is 0.addr
address:port or "unix". IPv6 has brackets around the address. The type is string, the default value is "".agent_code
numeric code reported by agent if any (unused for now) The type is int, the default value is 0.agent_desc
short human-readable description of agent_status The type is string, the default value is "".agent_duration
time in ms taken to finish last check The type is int, the default value is 0.agent_fall
agent's "fall" parameter, normally 1 The type is int, the default value is 1.agent_health
agent's health parameter, between 0 and rise+fall-1 The type is int, the default value is 0.agent_rise
agent's "rise" parameter, normally 1 The type is int, the default value is 1.agent_status
status of last agent check.: The type is string, the default value is "UNK".algo
load balancing algorithm The type is string, the default value is "".bck
number of backup servers (backend), server is backup (server) The type is int, the default value is 0.bin
bytes in The type is int, the default value is 0.bout
bytes out The type is int, the default value is 0.check_code
layer5-7 code, if available The type is int, the default value is 0.check_desc
short human-readable description of check_status The type is string, the default value is "".check_duration
time in ms took to finish last health check The type is int, the default value is 0.check_fall
server's "fall" parameter used by checks The type is int, the default value is 0.check_health
server's health check value between 0 and rise+fall-1 The type is int, the default value is 0.check_rise
server's "rise" parameter used by checks The type is int, the default value is 0.check_status
status of last health check. The type is string, the default value is "UNK".chkdown
number of UP->DOWN transitions. The backend counter counts transitions to the whole backend being down, rather than the sum of the counters for each server. The type is int, the default value is 0.chkfail
number of failed checks. (Only counts checks failed when the server is up.) The type is int, the default value is 0.cli_abrt
number of data transfers aborted by the client The type is int, the default value is 0.comp_byp
number of bytes that bypassed the HTTP compressor (CPU/BW limit) The type is int, the default value is 0.comp_in
number of HTTP response bytes fed to the compressor The type is int, the default value is 0.comp_out
number of HTTP response bytes emitted by the compressor The type is int, the default value is 0.comp_rsp
number of HTTP responses that were compressed The type is int, the default value is 0.conn_rate
number of connections over the last elapsed second The type is int, the default value is 0.conn_rate_max
highest known conn_rate The type is int, the default value is 0.conn_tot
cumulative number of connections The type is int, the default value is 0.cookie
server's cookie value or backend's cookie name The type is int, the default value is 0.ctime
the average connect time in ms over the 1024 last requests The type is int, the default value is 0.dcon
requests denied by "tcp-request connection" rules The type is int, the default value is 0.downtime
total downtime (in seconds). The value for the backend is the downtime for the whole backend, not the sum of the server downtime. The type is int, the default value is 0.dreq
requests denied because of security concerns. The type is int, the default value is 0.dresp
responses denied because of security concerns. The type is int, the default value is 0.dses
requests denied by "tcp-request session" rules The type is int, the default value is 0.econ
number of requests that encountered an error trying to connect to a backend server. The backend stat is the sum of the stat for all servers of that backend, plus any connection errors not associated with a particular server (such as the backend having no active servers). The type is int, the default value is 0.ereq
request errors. Some of the possible causes are: The type is int, the default value is 0.eresp
response errors. srv_abrt will be counted here also. The type is int, the default value is 0.hanafail
failed health checks details The type is int, the default value is 0.hrsp_1xx
http responses with 1xx code The type is int, the default value is 0.hrsp_2xx
http responses with 2xx code The type is int, the default value is 0.hrsp_3xx
http responses with 3xx code The type is int, the default value is 0.hrsp_4xx
http responses with 4xx code The type is int, the default value is 0.hrsp_5xx
http responses with 5xx code The type is int, the default value is 0.hrsp_other
http responses with other codes (protocol error) The type is int, the default value is 0.iid
unique proxy id The type is int, the default value is 0.intercepted
cum. number of intercepted requests (monitor, stats) The type is int, the default value is 0.last_agt
last agent check contents or textual error The type is string, the default value is "".last_chk
last health check contents or textual error The type is string, the default value is "".lastchg
number of seconds since the last UP<->DOWN transition The type is int, the default value is 0.lastsess
number of seconds since last session assigned to server/backend The type is int, the default value is 0.lbtot
total number of times a server was selected, either for new sessions, or when re-dispatching. The server counter is the number of times that server was selected. The type is int, the default value is 0.mode
proxy mode (tcp, http, health, unknown) The type is string, the default value is "unknown".pid
process id (0 for first instance, 1 for second, ...) The type is int, the default value is 0.pxname
proxy name The type is string, the default value is "".qcur
current queued requests. For the backend this reports the number queued without a server assigned. The type is int, the default value is 0.qlimit
configured maxqueue for the server, or nothing in the value is 0 (default, meaning no limit) The type is int, the default value is 0.qmax
max value of qcur The type is int, the default value is 0.qtime
the average queue time in ms over the 1024 last requests The type is int, the default value is 0.rate
number of sessions per second over last elapsed second The type is int, the default value is 0.rate_lim
configured limit on new sessions per second The type is int, the default value is 0.rate_max
max number of new sessions per second The type is int, the default value is 0.req_rate
HTTP requests per second over last elapsed second The type is int, the default value is 0.req_rate_max
max number of HTTP requests per second observed The type is int, the default value is 0.req_tot
total number of HTTP requests received The type is int, the default value is 0.rtime
the average response time in ms over the 1024 last requests (0 for TCP) The type is int, the default value is 0.scur
current sessions The type is int, the default value is 0.sid
server id (unique inside a proxy) The type is int, the default value is 0.slim
configured session limit The type is int, the default value is 0.smax
max sessions The type is int, the default value is 0.srv_abrt
number of data transfers aborted by the server (inc. in eresp) The type is int, the default value is 0.status
status (UP/DOWN/NOLB/MAINT/MAINT(via)/MAINT(resolution)...) The type is string, the default value is "".stot
cumulative number of sessions The type is int, the default value is 0.svname
service name (FRONTEND for frontend, BACKEND for backend, any name for server/listener) The type is string, the default value is "".throttle
current throttle percentage for the server, when slowstart is active, or no value if not in slowstart. The type is int, the default value is 0.tracked
id of proxy/server if tracking is enabled. The type is int, the default value is 0.ttime
the average total session time in ms over the 1024 last requests The type is int, the default value is 0.type
(0=frontend, 1=backend, 2=server, 3=socket/listener) The type is int, the default value is 0.weight
total weight (backend), server weight (server) The type is int, the default value is 0.wredis
number of times a request was redispatched to another server. The server value counts the number of times that server was switched away from. The type is int, the default value is 0.wretr
number of times a connection to a server was retried. The type is int, the default value is 0.
1.8.14