Skip the "autoincrement" unless you actually need it. You probably don't. 99.9999999999999% of the time autoincrement is used when it is not required because "it sounds nice" and not because it fulfills any useful purpose (other than consuming CPU and I/O for no useful purpose). Avoid that trap. Do not use autoincrement unless you need it, and you probably don't.