Slow instance response and CPU load
We are running informix 12.10.FC4W1@solaris on ORCL,SPARC-T5-2 server, it is
observed that many mutex with RR_ID found in onstat -g lmx.
onstat -g lmx
IBM Informix Dynamic Server Version 12.10.FC4W1 -- On-Line (Prim) -- Up 5 days
02:58:49 -- 2232320 Kbytes
Locked mutexes:
mid addr name holder lkcnt waiter waittime
9165 11059d6b8 RR_ID hash 180 0 1 2108 1
12771 1
7405 1
1044 1
7432 1
6186 1
11455 1
1663 1
4656 1
1096 1
1068 1
1103 1
5913 1
6045 1
1051 1
13322 1
1064 0
Errors found in tcb queue.
May be caused by changing data structures.
Number of mutexes on VP 1 free list: 82
Number of mutexes on VP 2 free list: 0
Number of mutexes on VP 3 free list: 0
Number of mutexes on VP 4 free list: 0
Number of mutexes on VP 5 free list: 0
Number of mutexes on VP 6 free list: 0
Number of mutexes on VP 7 free list: 0
Number of mutexes on VP 8 free list: 0
Number of mutexes on VP 9 free list: 208
Number of mutexes on VP 10 free list: 8
Number of mutexes on VP 11 free list: 14
Number of mutexes on VP 12 free list: 27323
Number of mutexes on VP 13 free list: 27840
Number of mutexes on VP 14 free list: 14879
Number of mutexes on VP 15 free list: 10065
Number of mutexes on VP 16 free list: 10386
Number of mutexes on VP 17 free list: 1100
Number of mutexes on VP 18 free list: 10308
Number of mutexes on VP 19 free list: 4946
Number of mutexes on VP 20 free list: 5310
Number of mutexes on VP 21 free list: 2059
Number of mutexes on VP 22 free list: 1905
Number of mutexes on VP 23 free list: 4812
Number of mutexes on VP 24 free list: 0
Number of mutexes on VP 25 free list: 0
Number of mutexes on VP 26 free list: 0
Number of mutexes on VP 27 free list: 0
Total number of mutexes on VP free lists: 121245