Hacker News new | ask | show | jobs
by markhops 3674 days ago
Stupid question here: what are serial keys, and how do they impose locks?
1 comments
markhops 3674 days ago
Ah, did he mean "SERIAL" as in "BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE" ... and the reason why this locks a table is because the database, on insert, needs to figure out a valid key?
link