Changes between Version 7 and Version 8 of ippToPspsIngestof3piPV2

Timestamp:

Jan 18, 2015, 7:04:01 PM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -170 +170 @@
 
 }}}
+
+=== sunday 7:00pm ===
+
+I made a script to email me every hour, it checks the status of the 12 loaders.  Nothing knocked over. Here is the status of loading, 6000 loaded since the am:
+
+{{{
+mysql>  select count(*), datastore_product from pending join box on box_id = id join skychunk on name = skychunk where name like 'PSPS%' group by datastore_product ;select count(*) from batch where dvo_db like 'LAP.PV2%' and loaded_to_datastore =1; select count(*), datastore_product from pending join box on box_id = id join skychunk on name = skychunk where name like 'PSPS%';
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|     5329 | PSPS_PV2_OB_SLICE00 | 
+|     6768 | PSPS_PV2_OB_SLICE02 | 
+|     9142 | PSPS_PV2_OB_SLICE04 | 
+|     9717 | PSPS_PV2_OB_SLICE06 | 
+|     7210 | PSPS_PV2_OB_SLICE08 | 
+|     5734 | PSPS_PV2_OB_SLICE10 | 
+|     6509 | PSPS_PV2_OB_SLICE12 | 
+|     8459 | PSPS_PV2_OB_SLICE14 | 
+|    10572 | PSPS_PV2_OB_SLICE16 | 
+|    12055 | PSPS_PV2_OB_SLICE18 | 
+|    11508 | PSPS_PV2_OB_SLICE20 | 
+|     8313 | PSPS_PV2_OB_SLICE22 | 
++----------+---------------------+
+12 rows in set (0.19 sec)
+
++----------+
+| count(*) |
++----------+
+|    20544 | 
++----------+
+1 row in set (0.02 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|   101316 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.13 sec)
+
+mysql> 
+
+}}}
+