cancel
Showing results for 
Search instead for 
Did you mean: 

information on show t_c T131

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

holger_becker
Employee
Employee
0 Kudos

Hi,

you have to enable this additional measurements by executing

x_cons <dbname> time enable

Kind regards

Holger

Answers (1)

Answers (1)

Former Member
0 Kudos

That did the trick Holger. Thank you for your assistance.