New answers tagged lock
INDEX(type, stamp) should speed up "Select 1" significantly, even without LOCK IN SHARE MODE. (Please provide SHOW CREATE TABLE for further discussion.) Edit Even though you have type and stamp in indexes, having these two fields in this order will be optimal for "Select 1": INDEX(type, stamp). This is because the optimizer can drill into the BTree to ...
Top 50 recent answers are included