Public feed #378640

Someone

public text v1 · immutable
Raw Edit
·published 2007-03-02 17:07 UTC
rendered paste body
mysql> show databases;
+----------+
| Database |
+----------+
| graficas |
| test     |
+----------+
2 rows in set (0.00 sec)

mysql> use graficas;
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_graficas        |
+---------------------------+
| cdef                      |
| cdef_items                |
| colors                    |
| data_input                |
| data_input_data           |
| data_input_fields         |
| data_local                |
| data_template             |
| data_template_data        |
| data_template_data_rra    |
| data_template_rrd         |
| graph_local               |
| graph_template_input      |
| graph_template_input_defs |
| graph_templates           |
| graph_templates_gprint    |
| graph_templates_graph     |
| graph_templates_item      |
| graph_tree                |
| graph_tree_items          |
| host                      |
| host_graph                |
| host_snmp_cache           |
| host_snmp_query           |
| host_template             |
| host_template_graph       |
| host_template_snmp_query  |
| poller                    |
| poller_command            |
| poller_item               |
| poller_output             |
| poller_reindex            |
| poller_time               |
| rra                       |
| rra_cf                    |
| settings                  |
| settings_graphs           |
| settings_tree             |
| snmp_query                |
| snmp_query_graph          |
| snmp_query_graph_rrd      |
| snmp_query_graph_rrd_sv   |
| snmp_query_graph_sv       |
| user_auth                 |
| user_auth_perms           |
| user_auth_realm           |
| user_log                  |
| version                   |
+---------------------------+
48 rows in set (0.00 sec)

mysql> select * from rra;
+----+----------------------------------+----------------------------+----------------+-------+------+----------+
| id | hash                             | name                       | x_files_factor | steps | rows | timespan |
+----+----------------------------------+----------------------------+----------------+-------+------+----------+
|  1 | c21df5178e5c955013591239eb0afd46 | Daily (5 Minute Average)   |            0.5 |     1 |  600 |    86400 |
|  2 | 0d9c0af8b8acdc7807943937b3208e29 | Weekly (30 Minute Average) |            0.5 |     6 |  700 |   604800 |
|  4 | e36f3adb9f152adfa5dc50fd2b23337e | Yearly (1 Day Average)     |            0.5 |   288 |  797 | 33053184 |
|  3 | 6fc2d038fb42950138b0ce3e9874cc60 | Monthly (2 Hour Average)   |            0.5 |    24 |  775 |  2678400 |
+----+----------------------------------+----------------------------+----------------+-------+------+----------+
4 rows in set (0.00 sec)

mysql>