MySQL Forums
Forum List  »  Install & Repo

show full processlist in 5.6.14
Posted by: Olof Mattsson
Date: October 08, 2013 07:41AM

Hi,

Did an upgrade of a 5.5.28 to 5.6.14 today and found something odd when running "show full processlist".

show full processlist in 5.6.14:
select max(last_report) as "Latest poll time ", cid as "ins_no",mon_stat,sub_tp,substring(sub_exptp,9,1) as "Reprogramming status",
max(from_unixtime(svr.intm)) as "Latest service",spi.`s#ins`
from ge_logs.alive_tracker_log atl force index (last_report_cid_ix)
left join reporting.sbn_panel_info spi on (atl.cid=spi.ins_no)
left join sbnmain.sv_requests svr on (svr.`s#ins`=spi.`s#ins`)
where atl.last_report >= vTimeStart
and atl.last_report <= vTimeStop
and spi.dealer like vDealer
and atl.userName like vRec
and spi.sub_tp like vSubTp
and substring(sub_exptp,9,1) like vSubExpTp
and atl.dealer = vDealId
group by 2
order by 1 desc;


show full processlist in 5.5.28:
select max(last_report) as "Latest poll time ", cid as "ins_no",mon_stat,sub_tp,substring(sub_exptp,9,1) as "Reprogramming status",
max(from_unixtime(svr.intm)) as "Latest service",spi.`s#ins`
from ge_logs.alive_tracker_log atl force index (last_report_cid_ix)
left join reporting.sbn_panel_info spi on (atl.cid=spi.ins_no)
left join sbnmain.sv_requests svr on (svr.`s#ins`=spi.`s#ins`)
where atl.last_report >= NAME_CONST('vTimeStart',_latin1'2013-10-01 00:00:00' COLLATE 'latin1_swedish_ci')
and atl.last_report <= NAME_CONST('vTimeStop',_latin1'2013-10-07 23:59:59' COLLATE 'latin1_swedish_ci')
and spi.dealer like NAME_CONST('vDealer',_latin1'%DNO%' COLLATE 'latin1_swedish_ci')
and atl.userName like NAME_CONST('vRec',_latin1'%MIX%' COLLATE 'latin1_swedish_ci')
and spi.sub_tp like NAME_CONST('vSubTp',_latin1'%DCOM%' COLLATE 'latin1_swedish_ci')
and substring(sub_exptp,9,1) like NAME_CONST('vSubExpTp',_latin1'%' COLLATE 'latin1_swedish_ci')
and atl.dealer = NAME_CONST('vDealId',350)
group by 2
order by 1 desc;

In 5.5.28 the variables was expanded and readable but that is not showing in 5.6.14. We have a application that runs stored procedures and it was handy to be able to copy the running query and do an explain on it without editing.

I there an option that we have missed to turn this back on?

Options: ReplyQuote


Subject
Written By
Posted
show full processlist in 5.6.14
October 08, 2013 07:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.