Is a spin lock a lock? What are the ways to implement it?

all the spin locks I see are implemented using CAS technology, without mutexes, and are often used for lock-free programming, so spin locks should not be locks, am I right? In addition, is there any other way to implement spin lock besides using CAS?

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bde269-3011c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bde269-3011c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?