Live Visitors Widget crashes if one visitor has hundreds of page views
|Reported by:||theboss||Owned by:|
|Priority:||normal||Milestone:||1.12.x - Piwik 1.12.x|
I am tracking 750+ sites with > 100,000 page views/day. I notice when that the Live Visitors section often attempts to show (if the js doesn't crash the browser first) a visit that contains all of the pages (or all sites, not sure) registered in the system. I haven't been able to really figure out what's happening here because the browser usually crashed or slows it down to the point that I can't do anything. But I notice that loads a visit with a HUGE list of pages they "viewed". Thousands of those little multi colored folder icons. Mousing over them shows all (or most) of the sites we are tracking.
I ran this query (nearly crashed the server):
SELECT * FROM piwik_log_visit WHERE DATE( visit_last_action_time ) = '2012-02-28' ORDER BY visit_total_actions DESC
Found a bunch of rows with > 100 actions but couldn't really see how to track it to a certain visitor. I searched "piwik_log_link_visit_action" for the "idvisitor" but 0 rows found for them. If you could advise I could try to give more information.
The most actions was about 450 but there are far more actions showing on the live visitors if I had to guess.
Change History (7)
comment:6 Changed 21 months ago by matt (mattab)
- Resolution set to fixed
- Status changed from new to closed