|
IDS Forum
Re: wait for mutex
Posted By: FRANK Date: Wednesday, 20 August 2014, at 10:47 a.m.
In Response To: Re: wait for mutex (Fernando Nunes)
Thanks, Fernando!
Here it is, confused ...
We indeed have ER slow/ data queued issue now
Frank
informix@walter ~]$ onstat -g wmx
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:54:05
-- 11847728 Kbytes
Mutexes with waiters:
mid addr name holder lkcnt waiter
waittime
6543 1d9fbc8f0 rqmut_trg_send 5496 0 227 0
5504 0
98 0
196 0
107 0
5488 0
7605 1dbb72ee0 CDRDSn0022 4484 0 210 17
4430 17
4585 17
4754 17
4528 17
4481 17
4897 17
4527 17
4526 17
4608 17
4752 17
214 17
205 17
195 16
4554 16
206 16
213 16
4618 16
4695 16
4425 16
4619 16
4560 16
4428 16
4500 16
4448 16
4555 16
4603 16
4609 16
4584 16
4607 16
4502 16
4447 16
4604 16
4896 16
4602 16
4895 16
4753 16
204 16
4426 16
4634 16
Number of mutexes on VP free lists: 10735
Read/Write Locks
addr id name slocks xlock waiters
[informix@walter ~]$ onstat -g lmx
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:54:17
-- 11847728 Kbytes
Locked mutexes:
mid addr name holder lkcnt waiter
waittime
6307 1d9c113d0 qtrMutex31 5488 0
6543 1d9fbc8f0 rqmut_trg_send 5496 0 5495 0
5488 0
6547 1d9fbcb90 rqrest_trg_send 5496 0
7605 1dbb72ee0 CDRDSn0022 4484 0 210 29
4430 29
4585 29
4754 29
4528 29
4481 29
4897 29
4527 29
4526 29
4608 29
4752 29
214 29
205 29
195 28
4554 28
206 28
213 28
4618 28
4695 28
4425 28
4619 28
4560 28
4428 28
4500 28
4448 28
4555 28
4603 28
4609 28
4584 28
4607 28
4502 28
4447 28
4604 28
4896 28
4602 28
4895 28
4753 28
204 28
4426 28
4634 28
Number of mutexes on VP free lists: 12879
Read/Write Locks
addr id name slocks xlock waiters
[informix@walter ~]$
On Wed, Aug 20, 2014 at 10:37 AM, Fernando Nunes <domusonline@gmail.com>
wrote:
> onstat -g wmx and onstat -g lmx to see what is the mutex...
> It can be hard to "see"...
> Regards
>
> On Wed, Aug 20, 2014 at 3:34 PM, FRANK <yunyaoqu@gmail.com> wrote:
>
> > Folks,
> >
> > Normally I do not see S---- in output of onstat -u, but now I see.
> >
> > Any comments?
> >
> > Thanks
> > Frank
> >
> > RHEL 6
> >
> > [informix@walter ngdc_er_20140820]$ onstat -u
> > IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:38:50
> > -- 11847728 Kbytes
> > Userthreads
> > address flags sessid user tty wait tout
> > locks nreads nwrites
> > 1d81b3028 ---P--D 1 informix - 0 0
> > 0 398 1015
> > 1d81b3880 ---P--F 0 informix - 0 0
> > 0 0 12778
> > 1d81b40d8 ---P--F 0 informix - 0 0
> > 0 0 18875
> > 1d81b4930 ---P--F 0 informix - 0 0
> > 0 0 11092
> > 1d81b5188 ---P--F 0 informix - 0 0
> > 0 0 18161
> > 1d81b59e0 ---P--F 0 informix - 0 0
> > 0 0 26058
> > 1d81b6238 ---P--F 0 informix - 0 0
> > 0 0 35724
> > 1d81b6a90 ---P--F 0 informix - 0 0
> > 0 0 12501
> > 1d81b72e8 ---P--F 0 informix - 0 0
> > 0 0 36521
> > 1d81b7b40 ---P--F 0 informix - 0 0
> > 0 0 15588
> > 1d81b8398 ---P--F 0 informix - 0 0
> > 0 0 46021
> > 1d81b8bf0 ---P--F 0 informix - 0 0
> > 0 0 2964
> > 1d81b9448 ---P--F 0 informix - 0 0
> > 0 0 183203
> > 1d81b9ca0 ---P--F 0 informix - 0 0
> > 0 0 47100
> > 1d81ba4f8 ---P--F 0 informix - 0 0
> > 0 0 18092
> > 1d81bad50 ---P--F 0 informix - 0 0
> > 0 0 47221
> > 1d81bb5a8 ---P--F 0 informix - 0 0
> > 0 0 13200
> > 1d81bbe00 ---P--- 18 informix - 0 0
> > 0 0 63
> > 1d81bc658 ---P--B 19 informix - 0 0
> > 0 515817 4096
> > 1d81bceb0 Y--P--B 20 informix - 1d8cf0e50 0
> > 0 459361 3977
> > 1d81bdf60 ---P--D 24 informix - 0 0
> > 0 4 0
> > 1d81be7b8 ---P--D 23 informix - 0 0
> > 0 0 0
> > 1d81bf010 ---P--- 43 informix - 0 0
> > 1 240 21860
> > 1d81bf868 Y--P--- 143 informix - 1db2aadc8 0
> > 1 8 22528
> > 1d81c00c0 ---P--- 33 informix - 0 0
> > 0 0 0
> > 1d81c0918 Y--P--- 141 informix - 1db2ccb78 0
> > 1 9 3
> > 1d81c1170 ---P--- 35 informix - 0 0
> > 1 0 0
> > 1d81c19c8 Y--P--- 36 informix - 1d9910448 0
> > 3 0 0
> > 1d81c2220 Y--P--D 41 informix - 48bdf970 0
> > 0 0 0
> > 1d81c2a78 ---P--- 44 informix - 0 0
> > 1 666 32901
> > 1d81c32d0 ---P--- 45 informix - 0 0
> > 1 711 32575
> > 1d81c3b28 ---P--- 46 informix - 0 0
> > 0 3 0
> > 1d81c4380 ---P--- 47 informix - 0 0
> > 1 240 442
> > 1d81c4bd8 ---P--- 48 informix - 0 0
> > 1 237 317
> > 1d81c5430 ---P--- 49 informix - 0 0
> > 1 197 329
> > 1d81c5c88 ---P--- 50 informix - 0 0
> > 1 165 552
> > 1d81c64e0 ---P--- 51 informix - 0 0
> > 2 202 252
> > 1d81c6d38 ---P--- 52 informix - 0 0
> > 1 304 76
> > 1d81c7590 ---P--- 53 informix - 0 0
> > 1 211 859
> > 1d81c7de8 ---P--- 54 informix - 0 0
> > 2 223 298
> > 1d81c8640 ---P--- 55 informix - 0 0
> > 1 204 414
> > 1d81c8e98 ---P--- 56 informix - 0 0
> > 1 263 329
> > 1d81c96f0 ---P--- 57 informix - 0 0
> > 2 237 364
> > 1d81c9f48 ---P--- 58 informix - 0 0
> > 2 302 174
> > 1d81ca7a0 ---P--- 136 informix - 0 0
> > 1 4 0
> > 1d81caff8 S--P--- 137 informix - 1d9fbc8f0 0
> > 1 186322 0
> > 1d81cb850 ---P--- 138 informix - 0 0
> > 0 272298 0
> > 1d81cc0a8 ---P--- 139 informix - 0 0
> > 1 44 0
> > 1d81cc900 S--P--- 142 informix - 1dbb72ee0 0
> > 0 0 211
> > 1d81cd158 Y--P--- 144 informix - 1db2aadc8 0
> > 1 9 23680
> > 1d81cd9b0 S--P--- 4692 informix - 1dbb72ee0 0
> > 2 3 4
> > 1d81ce208 S--P--- 4531 informix - 1dbb72ee0 0
> > 2 0 47
> > 1d81cea60 Y--P--- 235 saapmgr - 1def80778 0
> > 1 125 0
> > 1d81cf2b8 S--P--- 4693 informix - 1dbb72ee0 0
> > 2 3 1
> > 1d81d0bc0 S--P--- 151 informix - 1dbb72ee0 0
> > 2 13166 33392
> > 1d81d1418 S--P--- 152 informix - 1dbb72ee0 0
> > 2 14148 32374
> > 1d81d1c70 S--P--- 153 informix - 1dbb72ee0 0
> > 2 13705 31162
> > 1d81d2d20 ---P--- 155 informix - 0 0
> > 1 8890 0
> > 1d81d3dd0 Y--P--- 157 informix - 1db2aaca8 0
> > 2 13781 32324
> > 1d81d4628 Y--P--- 4827 informix - 1db2aaca8 0
> > 2 4 0
> > 1d81d4e80 S--P--- 159 informix - 1dbb72ee0 0
> > 2 13480 32593
> > 1d81d56d8 S--P--- 160 informix - 1dbb72ee0 0
> > 2 14200 32926
> > 1d81d5f30 Y--P--- 2693 saapmgr - 1e5a69148 0
> > 1 0 46
> > 1d81d6788 Y--P--- 173 informix - 1db2aadc8 0
> > 1 2 17280
> > 1d81d6fe0 Y--P--- 238 saapmgr - 1e029cca8 0
> > 1 0 0
> > 1d81d7838 Y--P--- 239 saapmgr - 1e3846028 0
> > 1 2 0
> > 1d81d8090 Y--P--- 237 saapmgr - 1dc95d4c8 0
> > 1 1 0
> > 1d81d88e8 Y--P--- 260 saapmgr - 1dcaccd78 0
> > 2 757 3042
> > 1d81d9140 Y--P--- 244 saapmgr - 1dfffeb78 0
> > 1 40 0
> > 1d81d9998 Y--P--- 258 saapmgr - 1e3176be0 0
> > 1 0 0
> > 1d81da1f0 Y--P--- 236 saapmgr - 1de8514c8 0
> > 1 1 0
> > 1d81daa48 Y--P--- 241 saapmgr - 1e0d85c28 0
> > 1 2 0
> > 1d81db2a0 Y--P--- 262 saapmgr - 1dcb5d538 0
> > 2 454 2717
> > 1d81dbaf8 Y--P--- 242 saapmgr - 1dcadf148 0
> > 1 0 0
> > 1d81dc350 Y--P--- 240 saapmgr - 1de777308 0
> > 1 1 0
> > 1d81dcba8 Y--P--- 254 saapmgr - 1dcb2f788 0
> > 1 3 0
> > 1d81dd400 Y--P--- 243 saapmgr - 1dd7a1df8 0
> > 1 1 0
> > 1d81ddc58 Y--P--- 259 saapmgr - 1dcb5d1d8 0
> > 2 820 2800
> > 1d81de4b0 Y--P--- 256 saapmgr - 1ddc9ac68 0
> > 1 9 0
> > 1d81ded08 Y--P--- 2647 wwwmgr - 1dd5c9708 0
> > 1 26 76
> > 1d81df560 Y--P--- 261 saapmgr - 1dd7ec2f8 0
> > 2 773 3510
> > 1d81dfdb8 Y--P--- 263 saapmgr - 1e12b86c0 0
> > 2 743 3245
> > 1d81e0610 Y--P--- 246 saapmgr - 1dd7c64a8 0
> > 1 0 0
> > 1d81e0e68 Y--P--- 264 saapmgr - 1e12b8ca8 0
> > 2 440 3917
> > 1d81e16c0 Y--P--- 265 saapmgr - 1dea7b3d0 0
> > 2 727 3044
> > 1d81e1f18 Y--P--- 266 saapmgr - 1dea7ba48 0
> > 1 460 3202
> > 1d81e2770 Y--P--- 267 saapmgr - 1e12b8f78 0
> > 2 651 3378
> > 1d81e2fc8 Y--P--- 268 saapmgr - 1e04de580 0
> > 1 891 3256
> > 1d81e3820 Y--P--- 269 saapmgr - 1e04debf8 0
> > 1 856 1164
> > 1d81e4078 Y--P--- 270 saapmgr - 1de6233d0 0
> > 1 2122 1273
> > 1d81e48d0 Y--P--- 271 saapmgr - 1e00966e8 0
> > 1 69 1045
> > 1d81e5128 Y--P--- 272 saapmgr - 1de623df0 0
> > 1 127 1460
> > 1d81e5980 Y--P--- 273 saapmgr - 1df259318 0
> > 1 63 1225
> > 1d81e61d8 Y--P--- 274 saapmgr - 1df259900 0
> > 1 65 1009
> > 1d81e6a30 Y--P--- 275 saapmgr - 1e028fa88 0
> > 1 86 1122
> > 1d81e7288 Y--P--- 276 saapmgr - 1e0324740 0
> > 1 73 1041
> > 1d81e7ae0 Y--P--- 277 saapmgr - 1e0324d28 0
> > 1 117 1273
> > 1d81e8338 Y--P--- 278 saapmgr - 1dcb43958 0
> > 1 69 1117
> > 1d81e8b90 Y--P--- 279 saapmgr - 1e317a630 0
> > 1 128223 247740
> > 1d81e93e8 Y--P--- 2737 saapmgr - 1dbb7f268 0
> > 1 0 26
> > 1d81e9c40 Y--P--- 4588 saapmgr - 1e182d428 0
> > 1 1 0
> > 1d81ea498 Y--P--- 282 saapmgr - 1dd7f96e8 0
> > 1 294 6235
> > 1d81eacf0 Y--P--- 283 saapmgr - 1dd7f9808 0
> > 1 186523 286151
> > 1d81eb548 Y--P--- 284 saapmgr - 1dd7b6788 0
> > 1 2224 337
> > 1d81ebda0 Y--P--- 285 saapmgr - 1dcb9bda8 0
> > 1 0 0
> > 1d81ec5f8 S--P--- 4473 informix - 1dbb72ee0 0
> > 6 4 140
> > 1d81ece50 S--P--- 4500 informix - 1dbb72ee0 0
> > 2 7 16
> > 1d81ed6a8 Y--P--- 288 saapmgr - 1e1638e38 0
> > 1 0 0
> > 1d81edf00 Y--P--- 289 saapmgr - 1de7e7028 0
> > 1 0 0
> > 1d81ee758 Y--P--- 290 saapmgr - 1e0cf49b8 0
> > 1 0 0
> > 1d81eefb0 Y--P--- 291 saapmgr - 1de713db0 0
> > 1 0 0
> > 1d81ef808 Y--P--- 292 saapmgr - 1df78b308 0
> > 1 0 23
> > 1d81f0060 Y--P--- 293 saapmgr - 1de9f9ef8 0
> > 1 0 51
> > 1d81f08b8 Y--P--- 297 saapmgr - 1e0886418 0
> > 1 5 0
> > 1d81f1110 Y--P--- 2738 saapmgr - 1dd875ce0 0
> > 1 0 0
> > 1d81f1968 Y--P--- 318 saapmgr - 1dfeff290 0
> > 1 94881 281121
> > 1d81f21c0 S--P--- 4393 informix - 1dbb72ee0 0
> > 2 15 438
> > 1d81f3270 Y--P--- 433 saapmgr - 1df83c278 0
> > 1 5 0
> > 1d81f3ac8 Y--P--- 1078 saapmgr - 1de046f18 0
> > 1 14 0
> > 1d81f4320 S--P--- 4828 informix - 1dbb72ee0 0
> > 2 0 5
> > 1d81f4b78 Y--P--- 4501 informix - 1db2aaca8 0
> > 2 7 18
> > 1e5116880 ---PR-- 5020 saapmgr - 0 0
> > 1 8901 0
> > 1e5117930 Y--P--- 2495 wwwmgr - 1dff80c28 0
> > 1 0 0
> > 1e5118188 L--P--- 4548 informix - 49a59840 120
> > 2 5 13
> > 1e51189e0 S--P--- 4376 informix - 1dbb72ee0 0
> > 2 97 451
> > 1e5119a90 Y--P--- 4430 informix - 1db2aaca8 0
> > 2 4 39
> > 1e511a2e8 S--P--- 4374 informix - 1dbb72ee0 0
> > 2 103 735
> > 1e511bbf0 Y--P--- 4427 informix - 1db2aaca8 0
> > 2 12 230
> > 1e511cca0 Y--P--- 5017 saapmgr - 1dd25f148 0
> > 1 7 43
> > 1e511d4f8 Y--P--- 2692 saapmgr - 1ee97e6a0 0
> > 1 0 18
> > 1e511dd50 Y--P--- 4448 informix - 1db2aaca8 0
> > 2 8 27
> > 1e511ee00 Y--P--- 4629 saapmgr - 1df4555f8 0
> > 1 0 0
> > 1e511f658 Y--P--- 4580 informix - 1db2aaca8 0
> > 2 4 13
> > 1e5120708 Y--P--- 3385 saapmgr - 1dbc6dad8 0
> > 1 0 0
> > 1e5122010 S--P--- 4506 informix - 1dbb72ee0 0
> > 2 10 279
> > 1e5122868 Y--P--- 5022 saapmgr - 1e0694bf8 0
> > 1 0 0
> > 1e5124170 Y--P--- 2739 saapmgr - 1ef31c028 0
> > 1 0 67
> > 1e51249c8 Y--P--- 4555 informix - 1db2aaca8 0
> > 2 5 16
> > 1e5125220 Y--P--- 2690 saapmgr - 1ee6c0d68 0
> > 1 0 51
> > 1e51262d0 Y--P--- 4372 informix - 1db2aaca8 0
> > 2 96 431
> > 1e5126b28 Y--P--- 2463 wwwmgr - 1ebf224a8 0
> > 1 6 0
> > 1e5127380 Y--P--- 2540 saapmgr - 1ed0f7cd8 0
> > 1 0 48
> > 1e5128430 S--P--- 4474 informix - 1dbb72ee0 0
> > 2 2 6
> > 1e5128c88 Y--P--- 2541 saapmgr - 1de9f16a0 0
> > 1 0 66
> > 1e5129d38 S--P--- 4394 informix - 1dbb72ee0 0
> > 2 25 32
> > 1e512b640 Y--P--- 4472 informix - 1db2aaca8 0
> > 5 8 15
> > 1e512be98 Y--P--- 4704 wwwmgr - 1e1a05d48 0
> > 1 46 17
> > 1e512cf48 Y--P--- 4565 informix - 1db2aaca8 0
> > 2 5 3
> > 1e512d7a0 S--P--- 4549 informix - 1dbb72ee0 0
> > 2 7 21
> > 1e512e850 S--P--- 4691 informix - 1dbb72ee0 0
> > 2 3 5
> > 1e512f0a8 Y--P--- 4829 informix - 1db2aaca8 0
> > 2 2 0
> > 1e512f900 S--P--- 4550 informix - 1dbb72ee0 0
> > 2 4 12
> > 1e5131208 S--P--- 4554 informix - 1dbb72ee0 0
> > 2 5 8
> > 1e5133368 Y--P--- 4371 informix - 1db2aaca8 0
> > 2 99 431
> > 1e5135d20 S--P--- 4637 informix - 1dbb72ee0 0
> > 2 7 5
> > 1e5136578 Y--P--- 4564 informix - 1db2aaca8 0
> > 2 7 11
> > 1e51386d8 Y--P--- 4628 saapmgr 1 1dbaedec8 0
> > 2 35202 0
> > 1e5139788 S--P--- 4553 informix - 1dbb72ee0 0
> > 2 4 140
> > 1e5139fe0 S--P--- 4446 informix - 1dbb72ee0 0
> > 2 6 191
> > 1e513c998 Y--P--- 4530 informix - 1db2aaca8 0
> > 2 7 13
> > 160 active, 256 total, 203 maximum concurrent
> >
> > --001a113ac4681904d00501107e85
> >
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
> --20cf303bf57605a7b70501108c39
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113a75a22a5ca7050110afc2
Messages In This Thread
- wait for mutex
FRANK -- Wednesday, 20 August 2014, at 10:33 a.m.
- Re: wait for mutex
Fernando Nunes -- Wednesday, 20 August 2014, at 10:37 a.m.
- Re: wait for mutex
FRANK -- Wednesday, 20 August 2014, at 10:47 a.m.
- RE: wait for mutex
Paul Watson -- Wednesday, 20 August 2014, at 10:44 a.m.
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|