InnoDB will notice circular dependencies and return an error instantly, to prevent deadlocks.In InnoDB, secondary indexes contain primary key values. So if your primary key is large, other indexes will also be large.