This shows you the differences between the selected revision and the current version of the page.
| technology:zenoss:useful_commands 06.16.2010 07:18 | technology:zenoss:useful_commands 07.17.2010 00:31 current | ||
|---|---|---|---|
| Line 103: | Line 103: | ||
| </code> | </code> | ||
| * Start mysqld on boot-up | * Start mysqld on boot-up | ||
| + | |||
| + | * <code mysql> | ||
| + | SELECT severity, COUNT(severity) FROM history WHERE lastTime>(UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 5 MINUTE))) GROUP BY severity UNION ALL SELECT severity, COUNT(severity) FROM status WHERE lastTime>(UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 5 MINUTE))) GROUP BY severity; | ||
| + | </code> | ||
| + | * Show histogram of last five minutes of events | ||
| + | * how many events in each category of severities came in? | ||
| + | * queries both history and status (live events) table | ||
| + | * example of using lastTime which is oddly a 'double' instead of 'timestamp' data type | ||
| ====== Processes ====== | ====== Processes ====== | ||