Media IDs incrementing by 3

I’m not sure if this is intended or not, but I’ve noticed when uploading media items in bulk, the ID numbers are incrementing by 3, rather than 1.
Thought I’d point it out in case it’s not meant to actually be doing that.

Version 2.2.2 Cloud

Very eagle-eyed there!

Yes it’s normal and expected. It’s because on Cloud we use multi-master Galera based clustering and that increments in threes to avoid insert conflicts.

There’s a more technical explanation of why it does that here if you’re interested:

On a local installation with standard MySQL (no clustering) you’d expect them to increment by 1.

Great, thanks for clarifying (and the technical info!) Good to know.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.