Pinger Data Analysis

 mysql> use pinger
Database changed
mysql> show tables;
+------------------+
| Tables_in_pinger |
+------------------+
| DATA             |
| NODE             |
+------------------+
2 rows in set (0.00 sec)

mysql> desc NODE;
+------ ------------ ---- --- -------+---------------+
| Field   | Type            | Null | Key | Default     | Extra          |
+------ ------------ ---- --- -------+---------------+
| id        | smallint(6)     | NO   | PRI | NULL    | auto_increment |
| name  |  varchar(100) | YES  |     | NULL      |                |
| ip        | varchar(15)   | YES  |     | NULL       |                |
+------ ------------ ---- --- -------+---------------+
3 rows in set (0.01 sec)
mysql> desc DATA;
+------------- ----------- ---- --- -------+------+
| Field           |  Type        | Null | Key | Default | Extra |
+------------- ----------- ---- --- -------+------+
| source        | smallint(6) | YES  |     | NULL    |       |
| destination  | smallint(6) | YES  |     | NULL    |       |
| packet_size | smallint(6) | YES  |     | NULL    |       |
| epock         | int(11)     | YES  |     | NULL    |       |
| packet_loss | tinyint(4)  | YES  |     | NULL    |       |
| min            | float(4,2)  | YES  |     | NULL    |       |
| avg            | float(4,2)  | YES  |     | NULL    |       |
| max           | float(4,2)  | YES  |     | NULL    |       |
+------------ ----------- ---- --- -------+------+
8 rows in set (0.00 sec)