active_user

active_user — Clustered. Stores user activity data, such as tracking types of user activity on a per-hour basis (example: $u had login activity during this hour). An "active user" is a user who has hit a LiveJournal page while logged-in, within the specified time period. Only used if memcached servers are available, and the site administrator has not disabled active user tracking. Clustered activity data from the current or previous hour is not harvested, to avoid counting duplicates. The year, month, day, hour, and userid columns make up the primary key, for duplicate checking. Please see also active_user_summary and clustertrack2.

active_user

Column name Type Null Default Description
year smallint   0  
month tinyint   0  
day tinyint   0  
hour tinyint   0  
userid int unsigned   0  
type char(1)    
Key name Type Column(s)
PRIMARY PRIMARY