Hot Shard Event Allowance Refresh Timeline Explained

Hi Lois, Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋

Based on the knowledge sources, hot shard limits in Mixpanel are applied on a per-day basis. The threshold is 200K events per distinct_id per event date for user analytics, and 1M events per group identifier per event date for group analytics.When Mixpanel detects a hot shard (when you exceed these thresholds), it transforms subsequent events with the same distinct_id and calendar day. This means that the allowance refreshes on a daily basis - each new calendar day starts with a fresh count toward the threshold.The documentation indicates that hot shard detection and remediation happens at the ingestion level and is specific to a combination of distinct_id and event_date. Once you've fixed your implementation, the hot shard detection would reset for the next calendar day.If you need to fix historical data that was affected by hot shard remediation, the documentation provides guidance on how to export, transform, and re-import the affected events, depending on whether they involve Group Analytics or not.Hot Shard Limits explains that the threshold is applied per event date, suggesting that the allowance refreshes daily.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

Based on the knowledge sources, Mixpanel uses your project's timezone setting to determine when a new date starts. Sessions (and by extension, hot shard limits which are applied per calendar day) are reset every 24 hours at midnight according to your project timezone.For projects created before January 1, 2023, Mixpanel converts event timestamps to your project timezone before writing the event to your data stores. For projects created after that date, Mixpanel records all events in UTC at intake, but still uses your project timezone setting when outputting results.By default, Mixpanel sets your timezone to UTC if you haven't changed it. Project owners and admins can change the timezone in Project Settings.Managing Timezones for Projects explains how Mixpanel handles timezones, and Sessions confirms that "Sessions are reset every 24 hours at midnight (according to your project timezone)."So regarding your hot shard allowance, it will refresh at midnight in your project's configured timezone.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.