Tracking events at milli-second granularity

Tracking events at milli-second granularity

摘要

Historically, Mixpanel used to track events at second-level granularity. For example, you could track an event with a timestamp of Jan 2, 2006, 3:04:05am. This caused problems when multiple events were tracked within the same second.

Once they were tracked, there was no way to know the true order in which these events happened. Internally, we sort the events in increasing order of event time, but if two events occurred at the same timestamp, we would sort them lexicographically by the name of the event.