THE Wiki

User Tools

Site Tools

Trace: • performance_memory_etc • sql_queries
sql_queries

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
sql_queries [2012/02/13 08:26] – michaelsql_queries [2021/04/24 07:40] (current) – external edit 127.0.0.1
Line 4: Line 4:
 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
sql_queries.1329121590.txt.gz · Last modified: 2021/04/24 07:38 (external edit)