News for hackers. Stuff that matters.
Re:Scaling to 100M: MySQL Is a Better NoSQL by markhops on Thursday May 26, 2016 @12:19PM (#11779171)
Stupid question here: what are serial keys, and how do they impose locks?
Re:Scaling to 100M: MySQL Is a Better NoSQL by markhops on Thursday May 26, 2016 @12:32PM (#11779293)
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?