Changes between Version 8 and Version 9 of AddStarMD_PV2

Timestamp:

Jun 6, 2014, 3:21:15 PM (12 years ago)

Author:

heather

Comment:

--

AddStarMD_PV2

@@ -77 +77 @@
 }}}
 
+=== useful queries for monitoring ===
+
+ * check information about addstar Runs
+{{{
+select minidvodb_group, stage, state, fault,  count(*) from addRun left join addProcessedExp using (add_id)  where minidvodb_group like 'MD__.PV2.201406%' group by minidvodb_group, stage, state, fault;
+}}}
+
+ * check information about minidvodbs 
+
+{{{
+select minidvodb_name, state, fault from minidvodbRun left join minidvodbProcessed using (minidvodb_id)  where minidvodb_name like 'MD__.PV2.201406%';
+}}}
+
+
 === how to addstar part 2 (merge) ===