Difference between revisions of "Stats Design"

From Dreamwidth Notes
Jump to: navigation, search
(Initial stub)
 
(Dump some stuff in)
Line 1: Line 1:
 
This is a placeholder for the Stats design page.
 
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:
 +
Displaying statistics:

Revision as of 18:51, 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: Displaying statistics: