需要从各维度统计下载的情况
Categorize downloads by the following hierarchies Date (UTC) Year Month Day Hour Minute Product Product Name Product Major Version Product Full Version Upgrade From Version ( determined by version string after -partial suffix ) Rebuild tag ( suffix string after primary version string ) Target OS ( from &os= parameter ) Request Info Download Type manual | partial | complete ( determined by -partial vs -complete vs any other ) Request Type download | check | other ( determined by GET vs HEAD vs any other ) Request Result success | failure ( determined via 302 vs 404 or any other ) Locale ( localization of product ) Location Continent Country Region City Latitude Longitude User Agent Info ( Possible to be deferred for later version ) UA OS Platform OS Name OS Version UA Browser Classification Desktop | Mobile | Spider | Bot | Other | Unknown Category Gecko | MSIE | WebKit | Opera | Other | Unknown Name Version Engine A Engine B
即时表,每分钟一条记录,rowkey 是时间,各种条件的统计在column里面保存
Table Name: dmo_metrics_realtime
Rowkey format concatenation of
{utc_timestamp_to_minute} (i.e. yyyy-mm-ddTHH:MM )
Counter Columns
dimension product column name format
counter:product:
{download_type}:
{product_name}:
{product_major_version}:
{product_version}:
{product_os}:
{product_rebuild}:
{upgrade_from}
dimension server_info column name format
counter:server_info:
{datacenter_code}:
{server_name}
dimension locale column name format
counter:locale:
{locale_code}
dimension location column name format
counter:location:
{continent_code}:
{country_code}:
{region_code}:
{city_name}:
{latitude}:
{longitude}
dimension user_agent_info *TBD*
examples
rowkey: minutes_2010-05-24T03:33
columns:
counter:product:manual:firefox:3.6:3.6.1:win:: = 1356
counter:product:complete:firefox:3.6:3.6.7:win:: = 12456
counter:product:partial:firefox:3.6:3.6.7:win::3.6.6 = 16334
counter:product:manual:thunderbird:3.1:3.1b2:mac:: = 50
counter:locale:en-US = 50000
counter:locale:pt-PT = 400
counter:locale:ru = 430
counter:location:NA:US:NH:0.000:0.000 = 30
counter:location:NA:US:CA:30.555:-100.999 = 5000
每小时进行多维度的统计
Table Name: dmo_metrics_hourly
Rowkey format concatenation of
{utc_timestamp_to_hour}_
{datacenter_code}:{server_name}_
{download_type}:{product_name}:{product_major_version}:{product_version}: {product_os}:{product_rebuild}:{upgrade_from}_
{locale_code}_
{continent_code}:{country_code}:{region_code}:{city_name}:{latitude}:{longitude}
Dimension Columns
product
dimension:product_download_type = {download_type}
dimension:product_name = {product_name}
dimension:product_major_version = {product_major_version}
dimension:product_version = {product_version}
dimension:product_os = {product_os}
dimension:product_rebuild = {product_rebuild}
dimension:product_upgrade_from = {upgrade_from}
server_info
dimension:datacenter_code = {datacenter_code}
dimension:server_name = {server_name}
locale
dimension:locale_code = {locale_code}
location
dimension:location_continent_code = {continent_code}
dimension:location_country_code = {country_code}
dimension:location_region_code = {region_code}
dimension:location_city_name = {city_name}
dimension:location_latitude = {latitude}
dimension:location_longitude = {longitude}
dimension user_agent_info *TBD*
Counter Column -- long integer updated via incrementColumn API
counter:requests
![(please configure the [header_logo] section in trac.ini)](http://www1.pconline.com.cn/hr/2009/global/images/logo.gif)