[Building Sakai] Site Stats startup 'costs'

[Watkins, Karen]

Hi Cheryl,

We maintain a separate "history" database that contains the data from SAKAI_EVENT and SAKAI_SESSION tables.  We migrate data from active to "history" once it is 2 days old.  The migration job is a Perl process that runs on a central batch server (not part of our Sakai environment).   We use the "history" database and our active  database when we run the daily "Site Stats" job.   Data remains in the "history" database for 1 year then it is deleted. Our "history" database is running on a separate server (Oracle running on AIX).
Here is some sizing information from our DBA:
The size of "history database" is 553GB.
Total SGA for this database is 627MB
Total PGA for this database is 512MB
CPU is allocated at the host level  - this host has 2 CPUs

Karen

From: Johns, Cheryl [mailto:cheryl.johns at yale.edu]
Sent: Thursday, April 29, 2010 2:43 PM
To: Watkins, Karen; Developers Sakai-Dev
Subject: RE: Site Stats startup 'costs'

Thanks Karen.  Is the separate dB only those two tables?  How powerful of a server is it running on?  (does it run on a separate machine than your regular Sakai dB?)

From: Watkins, Karen [mailto:kwatkins at iupui.edu]
Sent: Thursday, April 29, 2010 2:30 PM
To: Johns, Cheryl; Developers Sakai-Dev
Subject: RE: Site Stats startup 'costs'

At Indiana we have a daily process to process to migrate session and event data to a separate database that is used for our Site Stats process.  The time required for the migration job and the "Site Stats" calculation job varies but takes several hours during our periods of peak usage.   We have isolated all of our batch processes on a separate application server to avoid impact from online activity.

Karen Watkins, Manager, Oncourse Team
Indiana University, UITS
812-856-9049; kwatkins at indiana.edu<mailto:kwatkins at indiana.edu>


From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Johns, Cheryl
Sent: Thursday, April 29, 2010 11:39 AM
To: Developers Sakai-Dev
Subject: [Building Sakai] Site Stats startup 'costs'

Is the only real requirement to run Site Stats in a large organization an additional database to hold events and site/user information?

Cheryl Johns
Applications Support Manager, Instructional Solutions
http://cmi2.yale.edu
The Center for Media and Instructional Innovation
135 College Street, Suite 101
New Haven, CT  06510
Office: 1.203.436.4626

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100429/3165753e/attachment.html