Hi All, show engine innodb status gives the following information. I am not able to draw conclusion.
SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 97641, signal count 97303 --Thread 1140881760 has waited at log0log.c line 1986 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x2ba97e301ad8 created in file log0log.c line 801 a writer (thread id 1140881760) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file log0log.c line 1986 Last time write locked in file log0log.c line 1782 Mutex spin waits 0, rounds 1480195, OS waits 17032 RW-shared spins 155109, OS waits 76582; RW-excl spins 5896, OS waits 3598 Thanks, -- Krishna Chandra Prajapati
