Showengine innodb status

Showengine innodb status

1、SEMAPHORES

4 OSWAIT ARRAY INFO: reservation count13569, signal count 11421

5 --Thread1152170336 has waited at./../include/buf0buf.ic line 630 for 0.00 seconds

the semaphore:

6 Mutex at 0x2a957858b8 created filebuf0buf.c line 517, lock var 0

7 waiters flag 0

8 waitis ending

9 --Thread1147709792 has waited at./../include/buf0buf.ic line 630 for 0.00 seconds

the semaphore:

10 Mutex at 0x2a957858b8 created filebuf0buf.c line 517, lock var 0

11 waiters flag 0

12 waitis ending

13 Mutexs pin waits 5672442, rounds3899888, OS waits 4719

14 RW-shared spins 5920, OS waits 2918;RW-excl spins 3463, OS waits 3163

 

如果是一个高并发的系统，需要关注这一部分的输出。

有2部分组成，event counter和可选项输出，当前等待的事件（current waits）

 

第4行表示OS WAIT的信息。Reservation count表示innodb产生了多少次OS WAIT，signal count表示进行OS WAIT的线程ÿ