Since the auditlog table can grow substantially, it would be nice to have the ability to partition it. The drawback is that mysql only supports partitioning by columns that are in the primary key, so the clock column would have to be included in the auditlog primary key (auditid, clock)