Raw data tables

tony2001 edited this page Sep 18, 2014 · 3 revisions

Table of Contents

request table

Stores all the request data.
The table is a cyclic buffer of a certain size, so IDs are reused when the end of the buffer is reached.
doc_size and mem_peak_usage fields are in Kilobytes.

 +------------------+---------------+------+-----+---------+-------+
 | Field            | Type          | Null | Key | Default | Extra |
 +------------------+---------------+------+-----+---------+-------+
 | id               | int(11)       | NO   | PRI | 0       |       |
 | hostname         | varchar(32)   | YES  |     | NULL    |       |
 | req_count        | int(11)       | YES  |     | NULL    |       |
 | server_name      | varchar(64)   | YES  |     | NULL    |       |
 | script_name      | varchar(128)  | YES  |     | NULL    |       |
 | doc_size         | float         | YES  |     | NULL    |       |
 | mem_peak_usage   | float         | YES  |     | NULL    |       |
 | req_time         | float         | YES  |     | NULL    |       |
 | ru_utime         | float         | YES  |     | NULL    |       |
 | ru_stime         | float         | YES  |     | NULL    |       |
 | timers_cnt       | int(11)       | YES  |     | NULL    |       |
 | status           | int(11)       | YES  |     | NULL    |       |
 | memory_footprint | float         | YES  |     | NULL    |       |
 | schema           | varchar(16)   | YES  |     | NULL    |       |
 | tags_cnt         | int(11)       | YES  |     | NULL    |       |
 | tags             | varchar(1024) | YES  |     | NULL    |       |
 +------------------+---------------+------+-----+---------+-------+

timer table

Stores timer data.
The size of this table is not limited.

 +------------+---------+------+-----+---------+-------+
 | Field      | Type    | Null | Key | Default | Extra |
 +------------+---------+------+-----+---------+-------+
 | id         | int(11) | NO   | PRI | 0       |       |
 | request_id | int(11) | NO   | MUL | NULL    |       |
 | hit_count  | int(11) | YES  |     | NULL    |       |
 | value      | float   | YES  |     | NULL    |       |
 +------------+---------+------+-----+---------+-------+

tag table

Stores unique list of tags and their IDs.

 +-------+--------------+------+-----+---------+-------+
 | Field | Type         | Null | Key | Default | Extra |
 +-------+--------------+------+-----+---------+-------+
 | id    | int(11)      | NO   | PRI | NULL    |       |
 | name  | varchar(255) | NO   | UNI | NULL    |       |
 +-------+--------------+------+-----+---------+-------+

timertag table

Stores tag values.

 +----------+-------------+------+-----+---------+-------+
 | Field    | Type        | Null | Key | Default | Extra |
 +----------+-------------+------+-----+---------+-------+
 | timer_id | int(11)     | NO   | MUL | NULL    |       |
 | tag_id   | int(11)     | NO   | MUL | NULL    |       |
 | value    | varchar(64) | YES  |     | NULL    |       |
 +----------+-------------+------+-----+---------+-------+