Changes between Version 15 and Version 16 of ippToPspsIngestof3piPV2

Timestamp:

Jan 20, 2015, 6:59:29 PM (12 years ago)

Author:

heather

Comment:

--

ippToPspsIngestof3piPV2

@@ -424 +424 @@
 
 
+=== Tuesday 7:00pm ===
+
+I've been checking my email (the hourly reports) - there's been no need to restart things since the am. The status of loading at 7pm:
+
+{{{
+mysql> mysql>  select count(*), datastore_product from pending join box on box_ijoin 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   |
++----------+---------------------+
+|     3941 | PSPS_PV2_OB_SLICE00 | 
+|     6088 | PSPS_PV2_OB_SLICE02 | 
+|     8448 | PSPS_PV2_OB_SLICE04 | 
+|     7323 | PSPS_PV2_OB_SLICE06 | 
+|     4570 | PSPS_PV2_OB_SLICE08 | 
+|     3138 | PSPS_PV2_OB_SLICE10 | 
+|     4984 | PSPS_PV2_OB_SLICE12 | 
+|     5379 | PSPS_PV2_OB_SLICE14 | 
+|     8387 | PSPS_PV2_OB_SLICE16 | 
+|    10801 | PSPS_PV2_OB_SLICE18 | 
+|     9729 | PSPS_PV2_OB_SLICE20 | 
+|     6618 | PSPS_PV2_OB_SLICE22 | 
++----------+---------------------+
+12 rows in set (0.18 sec)
+
++----------+
+| count(*) |
++----------+
+|    40287 | 
++----------+
+1 row in set (0.02 sec)
+
++----------+---------------------+
+| count(*) | datastore_product   |
++----------+---------------------+
+|    79406 | PSPS_PV2_OB_SLICE00 | 
++----------+---------------------+
+1 row in set (0.13 sec)
+
+}}}