Avatar of CCVOIP

asked on 

mysql: show engine innodb status

can some help explaining what "SEMAPHORES" section from innodb status means. here is an output from one of our servers
OS WAIT ARRAY INFO: reservation count 389879268
OS WAIT ARRAY INFO: signal count 374056846
Mutex spin waits 592980844, rounds 1405896234, OS waits 11153864
RW-shared spins 451754895, rounds 12596287654, OS waits 372330619
RW-excl spins 7088437, rounds 125464428, OS waits 1928991
Spin rounds per wait: 2.37 mutex, 27.88 RW-shared, 17.70 RW-excl

Open in new window

MySQL ServerDatabasesApplication ServersServer Software

Avatar of undefined
Last Comment
David Johnson, CD

8/22/2022 - Mon