Mar 23 2009 AFS failure analysis
- Jon Gorrono (Unlicensed)
Content service events
Sat Mar 14 btwn 15:10 and 15:50:
Event |
count |
|---|---|
content.revise |
1 |
content.read |
250 |
content.new |
25 |
Sat Mar 28 btwn 15:10 and 15:50:
Event |
count |
|---|---|
content.read |
105 |
Sat Apr 25 btwn 15:10 and 15:50:
Event |
count |
|---|---|
content.delete |
1 |
content.read |
158 |
content.new |
31 |
Sat May 23 btwn 15:10 and 15:50:
Event |
count |
|---|---|
content.revise |
1 |
content.read |
95 |
content.new |
7 |
Count of all types of events, Sat May 23 and day before:
(Last Sat of Spring Quarter)
SELECT TO_CHAR(event_date, 'YYYY-MM-DD HH24') AS Hour,
COUNT(*) AS Events
FROM sakai_event
where
EVENT like 'content.%'
and event_date > to_date('May 22, 2009 00:10', 'Mon dd, YYYY HH24:mi')
and event_date < to_date('May 23, 2009 23:50', 'Mon dd, YYYY HH24:mi')
GROUP BY TO_CHAR(event_date, 'YYYY-MM-DD HH24')
ORDER BY 1;
results:
Day |
hour |
#-events |
|---|---|---|
2009-05-22 |
00 |
1674 |
2009-05-22 |
01 |
1985 |
2009-05-22 |
02 |
1912 |
2009-05-22 |
03 |
2519 |
2009-05-22 |
04 |
2480 |
2009-05-22 |
05 |
2746 |
2009-05-22 |
06 |
2336 |
2009-05-22 |
07 |
1661 |
2009-05-22 |
08 |
1058 |
2009-05-22 |
09 |
678 |
2009-05-22 |
10 |
404 |
2009-05-22 |
11 |
254 |
2009-05-22 |
12 |
165 |
2009-05-22 |
13 |
387 |
2009-05-22 |
14 |
615 |
2009-05-22 |
15 |
1491 |
2009-05-22 |
16 |
2022 |
2009-05-22 |
17 |
2573 |
2009-05-22 |
18 |
2396 |
2009-05-22 |
19 |
2074 |
2009-05-22 |
20 |
1996 |
2009-05-22 |
21 |
2955 |
2009-05-22 |
22 |
1749 |
2009-05-22 |
23 |
1665 |
2009-05-23 |
00 |
849 |
2009-05-23 |
01 |
551 |
2009-05-23 |
02 |
715 |
2009-05-23 |
03 |
1186 |
2009-05-23 |
04 |
801 |
2009-05-23 |
05 |
633 |
2009-05-23 |
06 |
533 |
2009-05-23 |
07 |
309 |
2009-05-23 |
08 |
213 |
2009-05-23 |
09 |
84 |
2009-05-23 |
10 |
27 |
2009-05-23 |
11 |
15 |
2009-05-23 |
12 |
28 |
2009-05-23 |
13 |
95 |
2009-05-23 |
14 |
116 |
2009-05-23 |
15 |
137 |
2009-05-23 |
16 |
473 |
2009-05-23 |
17 |
664 |
2009-05-23 |
18 |
791 |
2009-05-23 |
19 |
719 |
2009-05-23 |
20 |
763 |
2009-05-23 |
21 |
780 |
2009-05-23 |
22 |
560 |
2009-05-23 |
23 |
259 |
(for comparison) Count of all types of events, Sat Mar 14 and day before:
(Mar 14 is the last Sat of the Winter Quarter)
SELECT TO_CHAR(event_date, 'YYYY-MM-DD HH24') AS Hour,
COUNT(*) AS Events
FROM sakai_event
where
EVENT like 'content.%'
and event_date > to_date('Mar 13, 2009 00:10', 'Mon dd, YYYY HH24:mi')
and event_date < to_date('Mar 14, 2009 23:50', 'Mon dd, YYYY HH24:mi')
GROUP BY TO_CHAR(event_date, 'YYYY-MM-DD HH24')
ORDER BY 1;
results
day |
hour |
#-events |
|---|---|---|
2009-03-13 |
00 |
1855 |
2009-03-13 |
01 |
1965 |
2009-03-13 |
02 |
1806 |
2009-03-13 |
03 |
1895 |
2009-03-13 |
04 |
1650 |
2009-03-13 |
05 |
1920 |
2009-03-13 |
06 |
1914 |
2009-03-13 |
07 |
1240 |
2009-03-13 |
08 |
854 |
2009-03-13 |
09 |
447 |
2009-03-13 |
10 |
239 |
2009-03-13 |
11 |
133 |
2009-03-13 |
12 |
126 |
2009-03-13 |
13 |
221 |
2009-03-13 |
14 |
313 |
2009-03-13 |
15 |
970 |
2009-03-13 |
16 |
1774 |
2009-03-13 |
17 |
2089 |
2009-03-13 |
18 |
2685 |
2009-03-13 |
19 |
2395 |
2009-03-13 |
20 |
2814 |
2009-03-13 |
21 |
1966 |
2009-03-13 |
22 |
2423 |
2009-03-13 |
23 |
2716 |
2009-03-14 |
00 |
1808 |
2009-03-14 |
01 |
1349 |
2009-03-14 |
02 |
1964 |
2009-03-14 |
03 |
1354 |
2009-03-14 |
04 |
1675 |
2009-03-14 |
05 |
1613 |
2009-03-14 |
06 |
1379 |
2009-03-14 |
07 |
931 |
2009-03-14 |
08 |
489 |
2009-03-14 |
09 |
287 |
2009-03-14 |
10 |
196 |
2009-03-14 |
11 |
151 |
2009-03-14 |
12 |
86 |
2009-03-14 |
13 |
86 |
2009-03-14 |
14 |
201 |
2009-03-14 |
15 |
408 |
2009-03-14 |
16 |
668 |
2009-03-14 |
17 |
1050 |
2009-03-14 |
18 |
1789 |
2009-03-14 |
19 |
2741 |
2009-03-14 |
20 |
3065 |
2009-03-14 |
21 |
3768 |
2009-03-14 |
22 |
3207 |
2009-03-14 |
23 |
2395 |
Count of all types of events, Fri Mar 21 and day before:
From 8pm to 11pm on Thursday 20th:
The number of events for each file (>14):
file ref |
count |
|---|---|
/content/group/4141a796-68f5-498e-8049-be120b6d9e59/support_training.html |
13827 |
/content/group/2b735588-4977-4a08-a439-d32aac669135/Students_ Sound File/Sec. 5/LHill.mp3 |
3932 |
/content/group/2b735588-4977-4a08-a439-d32aac669135/Students_ Sound File/ymatsumoto.wav |
1943 |
/content/group/7bbf9c20-3b34-4bfc-a187-f7c5158630a6/Lab Material/Pre-Lab Data/Anemones--Quiz Formatted.jpg |
144 |
/content/group/2b44131f-bb47-4b30-9774-b8b83707327b/Home Page/BIS103 Spring2008 Lecture Titles.htm |
114 |
/content/group/c15a19a5-11ac-403d-9249-ef0acf254748/Goldberg_s Lectures PDFs/Endocrine-Topic1.Sp09.pptx.pdf |
92 |
/content/attachment/675ae3a9-8c88-458f-a48a-1d6ea79a888d/Assignments/08541301-104e-4812-b64f-a0d07359f764/AutotutoriaAccess.pdf |
62 |
/content/group/914bfb71-514a-40aa-9f22-76f321be8b7c/Class Notes/Suff principle and other processing studies.doc |
44 |
/content/group/a1d58e35-c999-4de7-9193-7c8d995acbde/ARE136_grades_520.pdf |
40 |
/content/attachment/675ae3a9-8c88-458f-a48a-1d6ea79a888d/Assignments/f9eb50f4-9a17-4963-bf7c-a04b916f68d0/Homework8.pdf |
40 |
/content/group/024965e9-0979-401a-8258-1dc1612f2697/Sample LPs/UWP LP sample 3.doc |
40 |
/content/group/675ae3a9-8c88-458f-a48a-1d6ea79a888d/PLS21webpage/Lecture/index.htm |
39 |
/content/group/cfc79ef2-1082-45ca-9dda-4f99cc5ada66/Pre-discussion Worksheets/Prediscussion 8.pdf |
36 |
/content/attachment/675ae3a9-8c88-458f-a48a-1d6ea79a888d/Assignments/cc409f6d-7ca2-4a72-bca6-14068db2bbf6/homework7.pdf |
35 |
/content/group/70f1eaea-5e25-4bf4-9d21-39a6c5edab21/Practice Exams/Practice 2_Solution.pdf |
34 |
/content/group/024965e9-0979-401a-8258-1dc1612f2697/Sample LPs/UWP LP sample 2.doc |
33 |
/content/attachment/b2ad15ef-2075-4f65-9889-6f3ca0d8cd1d/Assignments/5f5ed4de-29f3-4e38-825a-6a8527ea4cb5/Assignment for 5-27.doc |
33 |
/content/group/be2cd4ac-5e31-4657-a719-ec47f3780377/p151_ch14_happy_post.pdf |
32 |
/content/group/7d37043b-170b-4016-b8c4-5053317513e6/Exams/Exam II/Practice Exam II - W06 KEY.pdf |
31 |
/content/group/7bbf9c20-3b34-4bfc-a187-f7c5158630a6/Discussion/Discussion 6/teach a man to share a fish.pdf |
31 |
/content/group/b93d827d-f929-4583-8665-8b59ea45db91/Proposal/Review Questions for Proposal.doc |
31 |
/content/group/14d92dea-81f1-4dd7-9206-481f61f4d0a3/Death Row Consumption Discussion Questions.doc |
31 |
/content/group/b040e8af-4262-419c-af5c-3eade23f1e0c/fsm120/includes/style/header.css |
30 |
/content/group/b040e8af-4262-419c-af5c-3eade23f1e0c/fsm120/includes/style/page.css |
30 |
/content/group/b040e8af-4262-419c-af5c-3eade23f1e0c/fsm120/images/hudsonSmall.jpg |
30 |
/content/group/b040e8af-4262-419c-af5c-3eade23f1e0c/fsm120/includes/style/main.css |
30 |
/content/group/b040e8af-4262-419c-af5c-3eade23f1e0c/fsm120/index.htm |
30 |
/content/group/b040e8af-4262-419c-af5c-3eade23f1e0c/fsm120/includes/style/image.css |
30 |
/content/group/b040e8af-4262-419c-af5c-3eade23f1e0c/fsm120/includes/style/info.css |
30 |
/content/group/b040e8af-4262-419c-af5c-3eade23f1e0c/fsm120/includes/style/mouseover.css |
30 |
/content/group/024965e9-0979-401a-8258-1dc1612f2697/Sample LPs/UWP sample LP 1.doc |
29 |
/content/group/e1df77d4-1a54-4735-ac7f-adc2793ec81b/lecture ppts/pre8A2009lecture14.pdf |
28 |
/content/group/fecbe683-ce40-4a8a-84de-80fa59a3cf76/Proposal/PUF proposal.doc |
28 |
/content/group/5e8c5130-e4c7-4c23-99bf-b45bec147cf3/exam-solutions/midterm-2-102-s09-solutions.pdf |
28 |
/content/group/b20d5b51-518b-4fe6-9e81-7a3596c4626a/practice_files/white dress.psd |
27 |
/content/group/7d37043b-170b-4016-b8c4-5053317513e6/Exams/Exam II/Practice Exam II - S06 KEY.pdf |
27 |
/content/group/a0a16202-4b29-4aa2-a04b-de15694ebe39/Practice Exams/Practice MT 2.pdf |
27 |
/content/group/513af10c-8474-46f8-b398-ce8212964b3c/ANT 1 midterm comments.pdf |
27 |
/content/group/d9390772-047e-4d06-8064-c701126fb0f8/Intranet Internal Files/UCD_FinAid_logo_235.gif |
26 |
/content/group/513af10c-8474-46f8-b398-ce8212964b3c/Discussion Section Handouts/Section 7 Ant 1 S09.pdf |
25 |
/content/group/7fb91f36-a456-4eab-a42e-e44dd0ea4304/Assigned Readings/HARRIS_MISCHE EDUCATING FOR PEACE.pdf |
25 |
/content/group/2b44131f-bb47-4b30-9774-b8b83707327b/MIDTERM TWO STUDY AIDS/Old Midterm Two Samples/SampleMidterm2key.pdf |
24 |
/content/group/c15a19a5-11ac-403d-9249-ef0acf254748/Topical Revs Goldber_s Lect/TopicalRevRespSp09.pdf |
23 |
/content/group/7d37043b-170b-4016-b8c4-5053317513e6/Exams/Exam II/Practice Exam II - W07.pdf |
23 |
/content/group/7d37043b-170b-4016-b8c4-5053317513e6/Exams/Exam II/Practice Exam II - W07 KEY.pdf |
22 |
/content/group/1745bd55-5132-4905-b372-4e707e497acd/Lecture Slides/Lecture 14/EQ-lect14_6_.pdf |
22 |
/content/group/eb65b955-3bde-4d22-a1f7-5cc462c953a0/Your_Collage_should_combine.doc |
21 |
/content/group/b2ad15ef-2075-4f65-9889-6f3ca0d8cd1d/In The Lead Sample Writing.doc |
21 |
/content/group/a0a16202-4b29-4aa2-a04b-de15694ebe39/Practice Exams/Practice MT 2 answ.pdf |
21 |
/content/group/eb65b955-3bde-4d22-a1f7-5cc462c953a0/UWP 101 Collage Assignment S09.doc |
21 |
/content/group/2b44131f-bb47-4b30-9774-b8b83707327b/MIDTERM TWO STUDY AIDS/Old Midterm Two Samples/Midterm2KeyWhiteVersion.pdf |
21 |
/content/group/c15a19a5-11ac-403d-9249-ef0acf254748/Topical Revs Goldber_s Lect/TopicRevCVSp09.pdf |
21 |
/content/group/dd9adcab-6322-4a4d-aa84-9c0dff1708d1/English 10C front.jpg |
20 |
/content/group/ed8bed52-ee72-40a3-aea1-ebac66339448/Quiz 2a/DES144 Quiz 2A List.pdf |
20 |
/content/group/2b735588-4977-4a08-a439-d32aac669135/Computer Lab/Lab_0520.pdf |
20 |
/content/group/675ae3a9-8c88-458f-a48a-1d6ea79a888d/PLS21webpage/Lecture/CH08ppt/ImageEditing.html |
19 |
/content/group/7d37043b-170b-4016-b8c4-5053317513e6/Exams/Exam II/Practice Exam II - W06.pdf |
19 |
/content/group/c9bd0ee0-ebc6-4fe4-b8b5-8a0b0046a53f/Practice Exams/Practice Exam 2.pdf |
19 |
/content/group/675ae3a9-8c88-458f-a48a-1d6ea79a888d/PLS21webpage/Lecture/CH08ppt/MSPaint.png |
19 |
/content/group/675ae3a9-8c88-458f-a48a-1d6ea79a888d/PLS21webpage/Lecture/CH08ppt/Irfanview.png |
19 |
/content/group/4b5bba21-20e6-4074-901d-4085ff4b9412/Midterm _2 Study Guide.doc |
18 |
/content/group/c9bd0ee0-ebc6-4fe4-b8b5-8a0b0046a53f/Practice Exams/Practice Exam II S07.pdf |
18 |
/content/group/7bbf9c20-3b34-4bfc-a187-f7c5158630a6/Lecture slides/Speciation.Part2.2009.pdf |
18 |
/content/group/22448505-145a-44fa-9140-86a2aaa3c3b9/Exam Information/Exam.Equations.Midterm2.pdf |
18 |
/content/group/7d37043b-170b-4016-b8c4-5053317513e6/Exams/Exam II/Practice Exam II - S06.pdf |
18 |
/content/group/740ddc7a-a693-4043-9c5e-a5e285b97cdf/Class Lecture Slides/to_parent.pdf |
18 |
/content/group/142e0811-f4ac-4980-ab6d-c77c15a3248d/Midterm Keys/BIS101MT209aKey.pdf |
18 |
/content/group/eb65b955-3bde-4d22-a1f7-5cc462c953a0/Collage Checklist.doc |
18 |
/content/group/c9bd0ee0-ebc6-4fe4-b8b5-8a0b0046a53f/Practice Exams/Practice Exam II F06.pdf |
18 |
/content/group/18babeed-d662-42e7-9754-c02503efdddb/Spring09Versions/assets/DBcss.css |
18 |
/content/group/a2c6e965-e801-4a9a-a1ec-a381daeff83e/ARE171B_grades_520.pdf |
17 |
/content/group/18babeed-d662-42e7-9754-c02503efdddb/Spring09Versions/prelab8/prelab8S09.htm |
17 |
/content/group/7d37043b-170b-4016-b8c4-5053317513e6/Exams/Exam II/Practice Exam II - S05 KEY.pdf |
17 |
/content/group/7d37043b-170b-4016-b8c4-5053317513e6/Exams/Exam II/Practice Exam II - S05.pdf |
17 |
/content/group/7bbf9c20-3b34-4bfc-a187-f7c5158630a6/Lecture slides/Lecture18Slides.pdf |
16 |
/content/group/c15a19a5-11ac-403d-9249-ef0acf254748/Practice Exams/NPB101MT2Sum08NoKey.pdf |
16 |
/content/group/5b962eeb-80cd-42e1-9121-53b720adf49f/Lecture Posts/Lecture 13 5-20-09 Alcohol.ppt |
15 |
/content/group/c15a19a5-11ac-403d-9249-ef0acf254748/Goldberg_s Lectures PDFs/Renal1_2_3Rev09.pptx.pdf |
15 |
/content/group/c15a19a5-11ac-403d-9249-ef0acf254748/Goldberg_s Lectures PDFs/CV-Sp09.pptx.pdf |
15 |
/content/group/bc2f43cd-792a-40ac-b45e-1cde4c1274fc/Laboratory handouts/Lab8Student2009.pdf |
15 |
/content/group/2b44131f-bb47-4b30-9774-b8b83707327b/MIDTERM TWO STUDY AIDS/Old Midterm Two Samples/Midterm2noAnswersSp08.pdf |
15 |
/content/group/2b44131f-bb47-4b30-9774-b8b83707327b/Extra Problems for Midterm 2/MoreStudyQuestionsMidterm2.pdf |
15 |
/content/group/8b3eacfe-1d01-4c44-83e5-fb746a67987c/Lectures/Lecture08_Slides.pdf |
15 |
/content/group/2b44131f-bb47-4b30-9774-b8b83707327b/Extra Problems for Midterm 2/ProblemSet4NEW.pdf |
15 |
/content/group/f9594a07-76c6-4da5-a92b-9b2ac33857a4/Practice Exams/Exam 2/Practice Exam II S07.pdf |
15 |
/content/group/f9594a07-76c6-4da5-a92b-9b2ac33857a4/Practice Exams/Exam 2/Practice Exam II F06.pdf |
15 |
/content/group/f9594a07-76c6-4da5-a92b-9b2ac33857a4/Practice Exams/Exam 2/Practice Exam II F06 KEY.pdf |
15 |
/content/group/eb65b955-3bde-4d22-a1f7-5cc462c953a0/collage_elements_2009.doc |
15 |
/content/group/f9594a07-76c6-4da5-a92b-9b2ac33857a4/Practice Exams/Exam 2/Prctice_Exam2.pdf |
15 |
/content/group/0df0ce59-6435-44dc-8006-a77fdf70bfc6/bioprelab link page_comments.html |
15 |
/content/group/bc2f43cd-792a-40ac-b45e-1cde4c1274fc/Alternate final and review.pdf |
15 |
/content/group/7c74f5c3-0e19-4dae-8833-17347108aa7d/Materials/Poster/AlphabetPoster.jpg |
14 |
/content/attachment/35f2ba3f-4a3c-4736-8de3-91ec65356356/Announcements/b1c4219c-380e-4023-a74d-50aedb9a1a12/extra credit.pdf |
14 |
/content/group/c15a19a5-11ac-403d-9249-ef0acf254748/Goldberg_s Lectures PDFs/RespirationSp09.pptx.pdf |
14 |
From 10pm to 11pm on Thur May 20
The number of events for each file (>14):
file ref |
count |
|---|---|
/content/group/4141a796-68f5-498e-8049-be120b6d9e59/support_training.html |
12736 |
/content/group/c15a19a5-11ac-403d-9249-ef0acf254748/Goldberg_s Lectures PDFs/Endocrine-Topic1.Sp09.pptx.pdf |
92 |
/content/group/2b44131f-bb47-4b30-9774-b8b83707327b/Home Page/BIS103 Spring2008 Lecture Titles.htm |
45 |
/content/group/7bbf9c20-3b34-4bfc-a187-f7c5158630a6/Lab Material/Pre-Lab Data/Anemones--Quiz Formatted.jpg |
44 |
/content/attachment/b2ad15ef-2075-4f65-9889-6f3ca0d8cd1d/Assignments/5f5ed4de-29f3-4e38-825a-6a8527ea4cb5/Assignment for 5-27.doc |
33 |
/content/group/fecbe683-ce40-4a8a-84de-80fa59a3cf76/Proposal/PUF proposal.doc |
27 |
/content/group/b93d827d-f929-4583-8665-8b59ea45db91/Proposal/Review Questions for Proposal.doc |
26 |
/content/group/14d92dea-81f1-4dd7-9206-481f61f4d0a3/Death Row Consumption Discussion Questions.doc |
24 |
/content/group/d9390772-047e-4d06-8064-c701126fb0f8/Intranet Internal Files/UCD_FinAid_logo_235.gif |
21 |
/content/group/b2ad15ef-2075-4f65-9889-6f3ca0d8cd1d/In The Lead Sample Writing.doc |
21 |
/content/group/7bbf9c20-3b34-4bfc-a187-f7c5158630a6/Discussion/Discussion 6/teach a man to share a fish.pdf |
18 |
/content/group/cfc79ef2-1082-45ca-9dda-4f99cc5ada66/Pre-discussion Worksheets/Prediscussion 8.pdf |
16 |
/content/group/a0a16202-4b29-4aa2-a04b-de15694ebe39/Practice Exams/Practice MT 2.pdf |
15 |
hardest hit AFS vols during May 23 outage:
- /var/sakai/content
- /var/sakai/content/vol100
- /var/sakai/content/vol31