Applies To:

Show Versions Show Versions

Manual Chapter: Health and Performance Monitoring Database Schema
Manual Chapter
Table of Contents   |   << Previous Chapter

About customized health and performance monitoring statistics

With Enterprise Manager™ you can collect statistics and view details about the health and activity of the managed devices in your network. You also have the option use this collected data to create your own queries and customized graphs and reports using the details provided in the following sections in conjunction with any MySQL Connector, (available at http://dev.mysql.com/downloads/connector).

Overview of statistics types

Enterprise Manager™ stores in its health and performance monitoring database three types of statistics: counter statistics, gauge statistics, and threshold state statistics.

Counter statistics increment periodically to indicate a rate of change. To report the rate of change for a statistic during a specific period of time, the system performs a query for the counter statistics values and the timestamps for the beginning and end of the specified time period. Once the system receives the query response, it calculates and reports the rate of change.

Gauge statistics are absolute values for certain components, such as temperature, fan speed, and current connections. The system does not have to perform a calculation to report the absolute value of a gauge statistic.

A threshold state statistic is the current state of a specific statistic value as it relates to its threshold. That is, the threshold state indicates if the statistic value is above, below, or within a specified threshold.

Counter statistic query sample

The following SQL query example retrieves the counter statistic values for the server_pkts_in field for a node on the host device, bigip-central.

To calculate the rate of change for this example, the system compares the previous value (perfmon_node_stat p) and the current value (perfmon_node_stat c) in the perfmon_node_stat table. With this data, the system calculates the rate of change for the counter statistic using the calculation (V1-V0) / (T1-T0), where V1 is the value of the server_pkts_in field at time c.t, and V0 is the value of the server_pkts_in field at time p.t. (The insert_order field indicates the previous timestamp and value for that particular node.)

SELECT c.t, IFNULL(ABS(ROUND((p.server_pkts_in - c.server_pkts_in) / TIMESTAMPDIFF(SECOND, p.t, c.t))), 0) AS server_pkts_in_per_sec FROM perfmon_device d, perfmon_device_object o, perfmon_node_stat c, perfmon_node_stat p WHERE d.host_name = 'bigip-central' AND o.perfmon_device_uid = d.uid AND c.perfmon_device_object_uid = o.uid AND (p.insert_order = (c.insert_order – 1) AND p.perfmon_device_object_uid = c.perfmon_device_object_uid) AND c.t BETWEEN TIMESTAMPADD(MINUTE, -60, NOW()) AND NOW() AND p.t BETWEEN TIMESTAMPADD(MINUTE, -60, NOW()) AND NOW();

Gauge statistic query sample

The following example shows a gauge statistic SQL query that retrieves all values over the past hour for the chassis temperature on the host device, bigip-central.

SELECT s.t, s.temperature FROM perfmon_device d, perfmon_device_object o, perfmon_chassis_stat s WHERE d.host_name = 'bigip-central' AND o.perfmon_device_uid = d.uid AND s.perfmon_device_object_uid = o.uid AND s.t BETWEEN TIMESTAMPADD(MINUTE, -60, NOW()) AND NOW();

Threshold state statistic query sample

The following SQL query retrieves the current threshold state values for the perfmon_vip_stat.client_pkts_in field for all virtual servers associated with managed devices.

SELECT d.host_name, do.name, t.min_threshold, t.max_threshold FROM perfmon_threshold_state t, perfmon_device_object do, perfmon_device d WHERE t.perfmon_device_object_uid = do.uid AND t.stat_column_name = 'client_pkts_in' AND d.uid = do.perfmon_device_uid

About the health and performance monitoring database structure

The Enterprise Manager™ health and performance monitoring database consists of fact tables and dimension tables. The following diagram is an overview of the basic structure of the statistics database.

Basic structure of the statistics database

About dimension tables

Dimension tables contain object-specific details about the statistics for each managed device.

Device identification (perfmon_device)

The perfmon_device database table contains details about each managed device.

Field Type Null Value Allowed? Description
uid int unsigned NO Primary key
system_id varchar(128) NO Device identification
host_name varchar(128) NO Host name for the device
address varchar(64) NO IP address of the device
boot_location varchar(16) NO Current boot location
product_name varchar(128) NO Name of installed software
product_version varchar(64) NO Version of installed software
product_build_number varchar(32) NO Build number of installed software
ssl_total_tps int unsigned YES Licensed SSL transactions per minute
ssl_per_core varchar(16) YES Indicates if the SSL per core feature is licensed
appliance_sn varchar(64) YES Serial number of the device
platform varchar(16) YES Platform identification number
cpu_count int YES Number of CPU cores on the device

Device object identification (perfmon_device_object)

The perfmon_device_object database table contains identification details about the network objects associated with each managed device.

Field Type Null Value Allowed? Description
uid int unsigned NO Primary key
perfmon_device_uid int unsigned NO Foreign key on? perfmon_device.uid
name varchar(256) NO Uniquely identifies this object
perform_object_type enum? NO Type of object in the statistics table ( global,?chassis,?cpu,?cpu_info,?disk_space,?udp,?tcp,?http,?clientssl,?vip,?pool,?pool_member,?node)

About fact tables

Fact tables contain fields that are specific to the collected statistics type.

Important:

The partition_number field is not documented in the following fact tables. Do not reference the partition_number field in any custom code that you write, because that field is subject to change.

Chassis statistics (perfmon_chassis_stat)

The perfmon_chassis_stat database table contains the temperature statistics of the chassis for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
temperature int unsigned YES Temperature of chassis gauge

CPU statistics (perfmon_cpu_stat)

The perfmon_cpu_stat database table contains the temperature and fan speed statistics for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
fan_speed smallint unsigned YES Speed of CPU fan gauge
temperature int unsigned YES Temperature of CPU fan gauge

CPU usage statistics (perfmon_cpu_info_stat)

The perfmon_cpu_info_stat database table contains statistics about the CPU usage for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
cpu_usage_ratio smallint unsigned YES Ratio of CPU usage to available CPU capacity gauge

Disk space statistics (perfmon_disk_space_stat)

The perfmon_disk_space_stat database table contains details about the disk space for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics. N/A
t timestamp NO Time of data sample N/A
block_size int unsigned YES Size of blocks on disk gauge
tot_blocks int unsigned YES Number of blocks on disk gauge
free_blocks int unsigned YES Number of unused blocks on disk gauge
block_ratio smallint unsigned YES Ratio of free blocks to available blocks gauge
tot_nodes int unsigned YES Number of disk nodes gauge
free_nodes int unsigned YES Number of free disk nodes gauge

GTM pool member statistics (perfmon_gtm_pool_member_stat)

The perfmon_gtm_pool_member_stat database table contains performance for each managed Global Traffic Manager™ (GTM™) pool member.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
preferred int unsigned YES Rate of requests per second successfully processed by the configured preferred load balancing method counter
alternate int unsigned YES Rate of requests per second successfully processed by the configured alternate load balancing method counter
drop int unsigned YES Rate of requests per second that were not successfully processed, and were returned to the requesting DNS server counter
fallback int unsigned YES Rate of requests per second that were successfully processed by the configured fall-back load balancing method counter

GTM pool statistics (perfmon_gtm_pool_stat)

The perfmon_gtm_pool_stat database table contains performance statistics for each managed Global Traffic Manager™ (GTM™) pool.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
preferred int unsigned YES Rate of requests per second successfully processed by the configured preferred load balancing method counter
dropped int unsigned YES Rate of requests per second that were not successfully processed, and were returned to the requesting DNS server counter
fallback int unsigned YES Rate of requests per second that were successfully processed by the configured fall-back load balancing method counter

GTM virtual server statistics (perfmon_gtm_vs_stat)

The perfmon_gtm_vs_stat database table contains performance and capacity statistics for each managed Global Traffic Manager™ (GTM™) virtual server.

Field Type Null Value Allowed? Description Query type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
cpu int unsigned YES Current amount of CPU used by this GTM virtual server gauge
mem int unsigned YES Current amount of memory used by this GTM server gauge
bits_in int unsigned YES Current amount of throughput received, measured in bits per second gauge
bits_out int unsigned YES Current amount of throughput sent, measured in bits per second gauge
conn bigint unsigned YES Current number of connections, measured per second gauge

GTM wide IP statistics (perfmon_gtm_wideip_stat)

This perfmon_gtm_wideip_stat database table contains performance statistics for each managed Global Traffic Manager™ (GTM™) wide IP.

Field Type Null value allowed? Description Query type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
preferred int unsigned YES Rate of requests per second successfully processed by the configured preferred load balancing method counter
alt int unsigned YES Rate of requests per second successfully processed by the configured alternate load balancing method counter
dropped int unsigned YES Rate of requests per second that were not successfully processed, and were returned to the requesting DNS server counter
fallback int unsigned YES Rate of requests per second that were successfully processed by the configured fall-back load balancing method counter

HTTP traffic statistics (perfmon_http_stat)

The perfmon_http_stat database table contains HTTP-related traffic statistics for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
http_cookie_persist_inserts bigint unsigned YES Rate of successful attempts to insert HTTP headers for cookie persistence (set-cookie header insertions) counter
http_resp_2xx_cnt bigint unsigned YES Rate of server-side responses in range of 200 to 206 (successful responses) counter
http_resp_3xx_cnt bigint unsigned YES Rate of server-side responses in range of 300 to 307 (redirection responses) counter
http_resp_4xx_cnt bigint unsigned YES Rate of server-side responses in range of 400 to 417 (client errors) counter
http_resp_5xx_cnt bigint unsigned YES Rate of server-side responses in range of 500 to 505 (server errors) counter
http_number_reqs bigint unsigned YES Rate of HTTP requests counter
http_get_reqs bigint unsigned YES Rate of HTTP GET requests counter
http_post_reqs bigint unsigned YES Rate of HTTP POST requests counter
http_v9_reqs bigint unsigned YES Rate of version 9 requests counter
http_v10_reqs bigint unsigned YES Rate of version 10 requests counter
http_max_keepalive_req bigint unsigned YES Maximum number of requests made in a connection gauge
http_resp_bucket_1k bigint unsigned YES Rate of responses under 1K counter
http_resp_bucket_4k bigint unsigned YES Rate of responses between 1K and 4K counter
http_resp_bucket_16k bigint unsigned YES Rate of responses between 4K and 16K counter
http_resp_bucket_32k bigint unsigned YES Rate of responses between 16K and 32K counter
http_resp_bucket_64k bigint unsigned YES This field is deprecated; use larger buckets counter
http_idle_conn_splices bigint unsigned YES Rate of response bytes before compression is applied counter
http_idle_conns bigint unsigned YES Rate of idle HTTP connections at the time of query counter
http_precompress_bytes bigint unsigned YES Rate of response bytes before compression is applied counter
http_postcompress_bytes bigint unsigned YES Rate of response bytes after compression is applied counter
http_null_compress_bytes bigint unsigned YES Rate of bytes subjected to NULL compression for license enforcement counter
http_html_precompress_bytes bigint unsigned YES Rate of bytes for HTML MIME types before compression is applied counter
http_html_postcompress_bytes bigint unsigned YES Rate of bytes for HTML MIME types after compression is applied counter
http_css_precompress_bytes bigint unsigned YES Rate of bytes for CSS MIME types before compression is applied counter
http_css_postcompress_bytes bigint unsigned YES Rate of bytes for CSS MIME types after compression is applied counter
http_js_precompress_bytes bigint unsigned YES Rate of bytes for JS MIME types before compression is applied counter
http_js_postcompress_bytes bigint unsigned YES Rate of bytes for JS MIME types after compression is applied counter
http_xml_precompress_bytes bigint unsigned YES Rate of bytes for XML MIME types before compression is applied counter
http_xml_postcompress_bytes bigint unsigned YES Rate of bytes for XML MIME types after compression is applied counter
http_sgml_precompress_bytes bigint unsigned YES Rate of bytes for SGML MIME types before compression is applied counter
http_sgml_postcompress_bytes bigint unsigned YES Rate of bytes for SGML MIME types after compression is applied counter
http_plain_precompress_bytes bigint unsigned YES Rate of bytes for plain MIME types before compression is applied counter
http_plain_postcompress_bytes bigint unsigned YES Rate of bytes for plain MIME types after compression is applied counter
http_octet_precompress_bytes bigint unsigned YES Rate of bytes for octet MIME types before compression is applied counter
http_octet_postcompress_bytes bigint unsigned YES Rate of bytes for octet MIME types after compression is applied counter
http_image_precompress_bytes bigint unsigned YES Rate of bytes for image MIME types before compression is applied counter
http_image_postcompress_bytes bigint unsigned YES Rate of bytes for image MIME types after compression is applied counter
http_video_precompress_bytes bigint unsigned YES Rate of bytes for video MIME types before compression is applied counter
http_video_postcompress_bytes bigint unsigned YES Rate of bytes for video MIME types after compression is applied counter
http_audio_precompress_bytes bigint unsigned YES Rate of bytes for audio MIME types before compression is applied counter
http_audio_postcompress_bytes bigint unsigned YES Rate of bytes for audio MIME types after compression is applied counter
http_other_precompress_bytes bigint unsigned YES Rate of bytes for other MIME types before compression is applied counter
http_other_postcompress_bytes bigint unsigned YES Rate of bytes for other MIME types after compression is applied counter
http_ramcache_hits bigint unsigned YES Rate of RAM cache hits counter
http_ramcache_misses bigint unsigned YES Rate of RAM cache misses counter
http_ramcache_misses_all bigint unsigned YES Rate of RAM cache misses, including data that could not be cached counter
http_ramcache_hit_bytes bigint unsigned YES Rate of RAM cache hits, reported in bytes counter
http_ramcache_miss_bytes bigint unsigned YES Rate of RAM cache misses, excluding data that could not be cached, reported in bytes counter
http_ramcache_miss_bytes_all bigint unsigned YES Rate of all RAM cache misses, reported in bytes counter
http_ramcache_size bigint unsigned YES Maximum available RAM cache available, reported in megabytes gauge
http_ramcache_count bigint unsigned YES Rate of items stored in RAM cache counter
http_ramcache_evictions bigint unsigned YES Rate of items removed from RAM cache to free memory for new items counter

Memory usage and connection statistics (perfmon_global_stat)

The perfmon_global_stat database table contains aggregated server-side and client-side statistics about memory usage and connections for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
client_tot_byte_in bigint unsigned YES Rate of client-side bytes received counter
client_tot_bytes_out bigint unsigned YES Rate of client-side bytes sent counter
client_pkts_in bigint unsigned YES Rate of client-side packets received counter
client_pkts_out bigint unsigned YES Rate of client-side packets sent counter
client_maxconns bigint unsigned YES Maximum number of client-side connections reported since statistics collection was set or reset for the device gauge
client_tot_conns bigint unsigned YES Rate of client-side connections per second counter
client_cur_conns bigint unsigned YES Current number of client-side connections gauge
server_tot_bytes_in bigint unsigned YES Rate of server-side bytes received counter
server_tot_bytes_out bigint unsigned YES Rate of server-side bytes sent counter
server_pkts_in bigint unsigned YES Rate of server-side packets received counter
server_pkts_out bigint unsigned YES Rate of server-side packets sent counter
server_maxconns bigint unsigned YES Maximum number of concurrent server-side connections reported since statistics collection was set or reset for the device gauge
server_cur_conns bigint unsigned YES Current number of active server-side connections gauge
server_tot_conns bigint unsigned YES Rate of server-side connections counter
mem bigint unsigned YES Available memory gauge
mem_used bigint unsigned YES Memory in use gauge
mem_ratio smallint unsigned YES Ratio of available memory to memory in use gauge
dropped bigint unsigned YES Rate of dropped packets counter
err_in bigint unsigned YES Rate of errors received counter
err_out bigint unsigned YES Rate of errors sent counter

LTM node statistics (perfmon_node_stat)

The perfmon_node_stat database table contains statistics for traffic and connections to Local Traffic Manager™ (LTM®) node objects for each managed device.

Field Type Null value allowed? Description Query type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
server_tot_bytes_in bigint unsigned YES Total number of server-side bytes received by the specified node address since statistics collection was set or reset for the device counter
server_tot_bytes_out bigint unsigned YES Rate of server-side bytes sent by the specified node address counter
server_pkts_in bigint unsigned YES Rate of server-side packets received by the specified node address counter
server_pkts_out bigint unsigned YES Rate of server-side packets sent by the specified node address counter
server_maxconns bigint unsigned YES Maximum number of concurrent server-side connections to the specified node address since statistics collection was set or reset for the device gauge
server_tot_conns bigint unsigned YES Rate of server-side connections to the specified node address counter
server_cur_conns bigint unsigned YES Current number of active server-side connections to the specified node address gauge

LTM pool member statistics (perfmon_pool_member_stat)

The perfmon_pool_member_stat database table contains traffic and connection statistics for Local Traffic Manager™ (LTM®) pool members for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
server_tot_bytes_in bigint unsigned YES Rate of server-side bytes received by the specified pool counter
server_tot_bytes_out bigint unsigned YES Rater of server-side bytes sent by the specified pool counter
server_pkts_in bigint unsigned YES Rate of server-side packets received from the specified pool counter
server_pkts_out bigint unsigned YES Rate of server-side packets sent from the specified pool counter
server_maxconns bigint unsigned YES Maximum number of concurrent server-side connections to the specified pool reported since statistics collection was set or reset for the device gauge
server_tot_conns bigint unsigned YES Rate of server-side connections to the specified pool counter
server_cur_conns bigint unsigned YES Current number of server-side connections to the specified pool gauge

LTM pool statistics (perfmon_pool_stat)

The perfmon_pool_stat database table contains statistics for traffic and connections to Local Traffic Manager™ (LTM®) pools for each managed device.

Field Type Null value allowed? Description Query type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
server_tot_bytes_in bigint unsigned YES Rate of server-side bytes received by the specified pool counter
server_tot_bytes_out bigint unsigned YES Rate of server-side bytes sent by the specified pool counter
server_pkts_in bigint unsigned YES Rate of server-side packets received from the specified pool counter
server_pkts_out bigint unsigned YES Rate of server-side packets sent from the specified pool counter
server_maxconns bigint unsigned YES Maximum number of server-side connections to the specified pool reported since statistics collection was set or reset for the device gauge
server_tot_conns bigint unsigned YES Rate of server-side connections to the specified pool reported counter
server_cur_conns bigint unsigned YES Current number of active server-side connections to the specified pool gauge

TCP connection statistics (perfmon_tcp_stat)

The perfmon_tcp_stat database table contains TCP connection statistics for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
open int unsigned YES Rate of current open TCP connections counter
closewait int unsigned YES Rate of current TCP connections in CLOSE-WAIT/LAST-ACK state counter
finwait int unsigned YES Rate of current connections in FIN-WAIT/CLOSING state counter
timewait int unsigned YES Rate of current connections in TIME-WAIT state counter
accept bigint unsigned YES Rate of TCP connections accepted counter
acceptfails bigint unsigned YES Rate of TCP connections not accepted counter
conn bigint unsigned YES Rate of TCP connections established counter
connfail bigint unsigned YES Rate of TCP connection failures counter
expires bigint unsigned YES Rate of TCP connections that expired due to idle timeout counter
abandons bigint unsigned YES Rate of TCP connections abandoned due to retries and Keep-Alive attempts counter
rxrst bigint unsigned YES Rate of received RST packets counter
rxbadsum bigint unsigned YES Rate of bad checksum packets counter
rxbadseg bigint unsigned YES Rate of malformed segments counter
rxcookie bigint unsigned YES Rate of received SYN-cookies counter
rxbadcookie bigint unsigned YES Rate of bad SYN-cookies counter
syncacheover bigint unsigned YES Rate of SYN-cache overflow counter
txrexmits bigint unsigned YES Rate of retransmitted segments counter

Threshold state (perfmon_threshold_state)

The perfmon_threshold_state database table contains the current threshold state of each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
stat_column_name varchar(256) NO Identifies the individual statistics to which this threshold applies threshold
collection interval int unsigned NO Interval at which this statistic is collected threshold
status enum ? NO Status of the statistic collection (enabled,?disabled,? profile_change) threshold
min_threshold bigint unsigned YES Minimum value of threshold threshold
threshold_state enum? NO State of the threshold range ( BELOW_MIN_THRESHOLD,?ABOVE_MAX_THRESHOLD,?WITHIN_THRESHOLD) threshold
threshold_exceeded_since timestamp YES Current database has exceeded threshold since this time threshold
last_alert_fired timestamp YES Time that the last alert was triggered for this out-of-threshold event threshold

UDP connection statistics (perfmon_udp_stat)

The perfmon_udp_stat database table contains UDP connection statistics for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
open int unsigned YES Rate of current open UDP connections counter
accept bigint unsigned YES Rte of accepted UDP connections counter
acceptfails bigint unsigned YES Rate of UDP connections that failed because they were not accepted counter
conn bigint unsigned YES Rate of established UDP connections counter
connfail bigint unsigned YES Rate of failed UDP connections counter
expires bigint unsigned YES Rate of expired connections due to idle timeout counter
rdxgram bigint unsigned YES Rate of datagrams received counter
rxbaddgram bigint unsigned YES Rate of malformed datagrams counter
rxunreach bigint unsigned YES Rate of received ICMP messages counter
rxnosum bigint unsigned YES Rate of UDP connections with no checksum counter
txdgram bigint unsigned YES Rate of transmitted datagram packets counter

LTM virtual server statistics (perfmon_vip_stat)

The perfmon_vip_stat database table contains statistics about the connection statistics of Local Traffic Manager™ (LTM®) virtual servers configured for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
client_tot_byte_in bigint unsigned YES Rate of client-side bytes received by the specified virtual server counter
client_tot_bytes_out bigint unsigned YES Rate of client-side bytes sent from the specified virtual server counter
client_pkts_in bigint unsigned YES Rate of client-side packets received by the specified virtual server counter
client_pkts_out bigint unsigned YES Rate of client-side packets sent from the specified virtual server counter
client_maxconns bigint unsigned YES Maximum client-side connections to the specified virtual server gauge
client_tot_conns bigint unsigned YES Rate of client-side connections to the specified virtual server counter
client_cur_conns bigint unsigned YES Current number of client-side connections to the specified virtual server gauge
Table of Contents   |   << Previous Chapter

Was this resource helpful in solving your issue?




NOTE: Please do not provide personal information.



Incorrect answer. Please try again: Please enter the words to the right: Please enter the numbers you hear:

Additional Comments (optional)