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