preferred order of columns in the key
When building an index for a = constant AND b &gt;= ..., put any and all '=' columns first; end with one 'range': INDEX(a, b).  In your case INDEX(account_id, event_date).

You do need a PRIMARY KEY on your table, but it is unclear whether this is suitable.  The PK must be unique.

For more discussion, see my cookbook. The info is the same for MySQL as for MariaDB.  If you prefer, see MySQL: Building the best INDEX for a given SELECT