Difference between revisions of "Stats Design"

Revision as of 19:16, 16 August 2009

This is a placeholder for the Stats design page.

http://bugs.dwscoalition.org/show_bug.cgi?id=124

Table definition:

CREATE TABLE statkeylist (

   statkeyid int unsigned NOT NULL auto_increment, 
   name varchar(255) default NULL, 

   PRIMARY KEY (statkeyid), 
   UNIQUE KEY (name) 

)

CREATE TABLE site_stats (

   category_id INT UNSIGNED NOT NULL, 
   key_id INT UNSIGNED NOT NULL, 
   insert_time INT UNSIGNED NOT NULL, 
   value INT UNSIGNED NOT NULL, 

   -- FIXME: This is good for retrieving data for a single category+key, but 
   -- maybe not as good if we want all keys for the category, with a limit on 
   -- time (ie, last 5 entries, or last 2 weeks). Do we need an extra index? 
   INDEX (category_id, key_id, insert_time) 

)

Storing statistics: http://hg.dwscoalition.org/dw-free/file/67e1042df080/cgi-bin/DW/StatStore.pm

Statistics: http://hg.dwscoalition.org/dw-free/file/67e1042df080/cgi-bin/DW/StatData.pm and http://hg.dwscoalition.org/dw-free/file/67e1042df080/cgi-bin/DW/StatData/

Collecting statistics: http://hg.dwscoalition.org/dw-free/file/67e1042df080/bin/worker/stats-collection and http://hg.dwscoalition.org/dw-free/file/c2251ce4caf8/etc/stats-collection.conf

Displaying statistics: