Web development
fromSitePoint Forums | Web Development & Design Community
16 hours agoMySQL SELECT ... FOR UPDATE causing table lock during high traffic while generating sequential transaction IDs
Allocate numeric sequence values in a fast, separate atomic operation (use an auto-increment/sequence or short INSERT) and then use that value to build TXN codes to avoid long locks.