Differences

This shows you the differences between two versions of the page.

--- sql_queries [2012/02/13 08:26] – created michael
+++ sql_queries [2021/04/24 07:40] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
-Filespaces that where not backed up for $day days:
+Filespaces that where not backed up for $day days:\\
-select f.node_name, n.contact, f.filespace_name, f.backup_start, f.backup_end from filespaces f, nodes n where (backup_end < current_timestamp - $days days) AND (n.node_name = f.node_name)
+  select f.node_name, n.contact, f.filespace_name, f.backup_start, f.backup_end from filespaces f, nodes n where (backup_end < current_timestamp - $days days) AND (n.node_name = f.node_name)
+Maximale und Minimale übertragungsrage eines TSM-Nodes --- abfrage an mysqldb die daten puffert.
+  select node_name, MAX(bytes/(1024*1024*1024)/(CAST((end_time-start_time) as unsigned))*3600), MIN(bytes/(1024*1024*1024)/(CAST((end_time-start_time) as unsigned))*3600) FROM `backups` WHERE node_name like 'DMS%' start_time > '2012-08-01 00:00:00' group by node_name