[really attaching the SQL select queries]
mysql> use cacti;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT id FROM host WHERE disabled = '' ORDER BY id;
+----+
| id |
+----+
| 1 |
| 2 |
| 3 |
| 4 |
| 6 |
| 7 |
| 8 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 24 |
| 25 |
| 26 |
| 27 |
| 29 |
| 30 |
| 31 |
| 32 |
| 34 |
| 35 |
| 36 |
| 37 |
| 42 |
| 43 |
| 44 |
| 45 |
| 48 |
| 49 |
| 50 |
| 51 |
| 52 |
+----+
41 rows in set (0.00 sec)
mysql> SELECT count(*) FROM poller_time WHERE end_time='0000-00-00 00:00:00'
-> ;
+----------+
| count(*) |
+----------+
| 1 |
+----------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT local_data_id, rrd_name FROM poller_output
-> ;
+---------------+-----------+
| local_data_id | rrd_name |
+---------------+-----------+
| 545 | cpu_user |
| 546 | load_1min |
+---------------+-----------+
2 rows in set (0.00 sec)
mysql> SELECT count(*) FROM poller_time WHERE poller_id=0 AND
end_time>'0000-00-00 00:00:00';
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
mysql> select poller_output.output, poller_output.time,
poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name,
poller_item.rrd_num from (poller_output,poller_item) where
(poller_output.local_data_id=poller_item.local_data_id and
poller_output.rrd_name=poller_item.rrd_name);
Empty set (0.00 sec)
mysql> SELECT COUNT(*) FROM poller_command;
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
