on 10-10-2007 4:27 PM
Hi,
I am trying to do performance monitoring on livecache. Process is active for thread t131. I use x_cons <sid> show t_c t131 and get the below information, etc.
-
T131 User ( pid = 2248872 ) -
remote_node : oaca12qt remote_pid : 2248872
COM procedure : APS_ORDER_GET_DATA
OMS callback : SQLRequest_method callback_cnt : 31
dispatcher_cnt: 323162 command_cnt : 160887
exclusive_cnt : 104786223 self_susp_cnt : 3760
Resume count 0 total 824937 History [ T2 T2 T2 ]
state_vwait : 0 state_vsleep : 98170 state_vsusp : 37313
prio_total : 103 prio_from_oth : 103
-
However, I was expecting to see much more information per the performance primer documentation...for example:
-
T45 User ( pid = 0 ) -
dispatcher_cnt: 45122 command_cnt : 2302
exclusive_cnt : 12794233 self_susp_cnt : 41886
Resume count 0 total 275 History [ T12 T4 T2 ]
self_read_io : 4300 avg_self_rd_tm: 0.0000
self_write_io : 2419 self_write_pg : 2419 avg_self_wr_tm: 0.0006
dev_read_io : 492 rel_dev_rd_tm : 0.0006 abs_dev_rd_tm : 0.0006
dev_read_pg : 492 pages_per_io : 1.0
dev_write_io : 92 rel_dev_wr_tm : 0.0020 abs_dev_wr_tm : 0.0021
dev_write_pg : 92 pages_per_io : 1.0
state_vsusp : 2 rel_susp_time : 0.1458 abs_susp_time : 0.1458
rcv_rpl_count : 692 rcv_rpl_long : 2 avg_rcv_rpl_t : 0.0994
rpl_rcv_count : 691 rel_rpl_rcv_t : 1.1367 abs_rpl_rcv_t : 1.1369
dev_que_len_0 : 536 dev_que_len_1 : 39 dev_que_len>1 : 9
-
I am using Kernel Version 'Kernel 7.5.0 Build 039-123-135-440'
What is the reason for such a wide difference in information?
I am specifically looking for rcv_rpl_count, rpl_rcv_count, dev_read_io, etc, or more documentation on the information I do have Unfortunately, the mysql site now points us back to service marketplace, which does not have this detail.
Thanks for any assistance.
Margaret
Hi,
you have to enable this additional measurements by executing
x_cons <dbname> time enable
Kind regards
Holger
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That did the trick Holger. Thank you for your assistance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.