How many row should lock when using SELECT .. FOR UPDATE LIMIT 1 – Mysql
I have a simple table with an index on the count column | Counts | CREATE TABLE `Counts` ( `id` bigint NOT NULL, `count` int NOT NULL, PRIMARY KEY (`id`), KEY `count_i` (`count`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | INSERT…