Differences

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

--- sql_queries [2012/08/17 13:25] – michael
+++ sql_queries [2021/04/24 07:40] (current) – external edit 127.0.0.1
@@ Line 6: / Line 6: @@
 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
+  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