© Jesper Wisborg Krogh 2021
J. W. KroghMySQL Concurrencyhttps://doi.org/10.1007/978-1-4842-6652-6_18

18. Case Study: Semaphores

Jesper Wisborg Krogh1  
(1)
Hornsby, NSW, Australia
 

Mutex and semaphore contention is one of the most elusive kinds of contention you can come across as except for extreme situations, you will not directly notice any issues. Instead, the contention tends to materialize as an overall added latency and throughput reduction that can be hard to put your finger on. Then out of the blue, you may have crossed a load threshold, and the contention causes your server to come to a grinding halt.

This chapter goes through a case study of investigating contention on the adaptive hash index rw-semaphore. However, do be aware that semaphore ...

Get MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.