Riedsio
Riedsio

Reputation: 9926

How do *you* use auto_increment_increment?

Re: MySQL's global configuration option auto_increment_increment.

Other than

  1. multi-master/circular replication in conjunction with auto_increment_offset
  2. artificially "beefing up" stats when user/object id's are visible to the end users

How/Why have you seen auto_increment_increment used in practice?

Upvotes: 2

Views: 1539

Answers (1)

Ish
Ish

Reputation: 29536

It just provide control, it's not used widely, it will allow if i need keys to be like this 10, 20, 30, etc

So i can insert records in between those records, like now i can insert 11,12,13 records (later) in between 10 and 20, which might be helpful in rarest case

Upvotes: 3

Related Questions