Memory State

Loading #files.recordCount# files... insert into point (timestamp, createDate, mem_total, mem_used, mem_used_cache, swap_total, swap_used ) values (, now(), , , , , ) select last_insert_id() as id insert into process_point (pointId, processId, instanceCount, pageFaults, resident, virtual ) values (, , , , , ) delete from process_point where pointId in ( select id from point where timestamp < now() - interval 7 day ) limit 2500 delete from point where id not in ( select pointId from process_point ) select id, timestamp, mem_total, mem_used, mem_used_cache, swap_total, swap_used from point where timestamp > order by timestamp select cast(group_concat(distinct p.id) as char) as idList, ifnull(a.id, min(p.id)) as lookupId, ifnull(a.alias, left(p.name, 15)) as alias, a.id is not null as hasAlias, ifnull(a.color, '000000') as color from process p inner join process_point pp on p.id = pp.processId left outer join alias a on p.aliasId = a.id where pp.pointId >= group by ifnull(a.id, ifnull(a.alias, left(p.name, 15))) having hasAlias or max(pp.resident) > 32 * 1024 select id as pointId , ifnull(( select sum(resident) from process_point where pointId = p.id and processId in () ), 0) resident_#i# , ifnull(( select sum(virtual) from process_point where pointId = p.id and processId in () ), 0) virtual_#i# , ifnull(( select sum(pageFaults) from process_point where pointId = p.id and processId in () ), 0) pageFaults_#i# , 0 as pageFaultDelta_#i# from point p where timestamp > and minute(timestamp) % 20 = (floor(minute(now()) / 10) * 10) % 20 select p.id, a.color, ifnull(a.alias, left(p.name, 35)) as alias, pp.instanceCount, pp.pageFaults, pp.resident, pp.virtual from process_point pp inner join process p on pp.processId = p.id left outer join alias a on p.aliasId = a.id where pp.pointId = order by pp.resident desc http://chart.apis.google.com/chart ?cht=lc &chs=800x300 &chxt=x,r &chxl=0:|#timeFormat(point.timestamp, 'HH:mm')#|#timeFormat(point.timestamp[round(point.recordCount * i / 8)], 'H:mm')# |1:|0|#numberFormat(physicalScale / 4096, ",")#|#numberFormat(physicalScale / 2048, ",")#|#numberFormat(physicalScale / 4096 * 3, ",")#|#numberFormat(physicalScale / 1024, ",")# &chg=12.5,12.5 &chdlp=t &chf=c,ls,90,eeeeee,#physicalScale == 0 ? 0 : physicalMax / physicalScale#,ffffff,1 &chtt=Resident+Memory &chdl=Caches|Total|#chdl# &chco=ffffdd,ff0000,#chco# &chd=s: #chartEncode(valueList(point.mem_used), min, physicalScale)# ,#chartEncode(valueList(point.mem_used_cache), min, physicalScale)# ,#chartEncode(valueList("get.resident_#i#"), min, physicalScale)# &chm=b,ffffdd,0,1,0 http://chart.apis.google.com/chart ?cht=lc &chs=800x250 &chxt=x,r &chxl=0:|#timeFormat(point.timestamp, 'HH:mm')#|#timeFormat(point.timestamp[round(point.recordCount * i / 8)], 'H:mm')# |1:|0|#numberFormat(virtualScale / 4096, ",")#|#numberFormat(virtualScale / 2048, ",")#|#numberFormat(virtualScale / 4096 * 3, ",")#|#numberFormat(virtualScale / 1024, ",")# &chg=12.5,12.5 &chdlp=t &chf=c,ls,90,eeeeee,#virtualScale == 0 ? 0 : physicalMax / virtualScale#,ffffff,1 &chtt=Virtual+Memory &chdl=#chdl# &chco=#chco# &chd=s: ,#chartEncode(valueList("get.virtual_#i#"), min, virtualScale)# http://chart.apis.google.com/chart ?cht=lc &chs=800x250 &chxt=x,r &chxl=0:|#timeFormat(point.timestamp, 'HH:mm')#|#timeFormat(point.timestamp[round(point.recordCount * i / 8)], 'H:mm')# |1:|0|#numberFormat(faultScale / 4, ",")#|#numberFormat(faultScale / 2, ",")#|#numberFormat(faultScale / 4 * 3, ",")#|#numberFormat(faultScale, ",")# &chg=12.5,12.5 &chdlp=t &chtt=Page+Faults &chdl=#chdl# &chco=#chco# &chd=s: ,#chartEncode(valueList("get.pageFaultDelta_#i#"), min, faultScale)# http://chart.apis.google.com/chart ?cht=lc &chs=800x200 &chxt=x,r &chxl=0:|#timeFormat(point.timestamp, 'HH:mm')#|#timeFormat(point.timestamp[round(point.recordCount * i / 8)], 'H:mm')# |1:|0|#numberFormat(swapScale / 4096, ",")#|#numberFormat(swapScale / 2048, ",")#|#numberFormat(swapScale / 4096 * 3, ",")#|#numberFormat(swapScale / 1024, ",")# &chg=12.5,12.5 &chf=c,ls,90,eeeeee,#swapScale == 0 ? 0 : swapMax / swapScale#,ffffff,1 &chtt=Swap &chco=ff0000 &chd=s: #chartEncode(valueList(point.swap_used), min, swapScale)# Memory State

Processes as of #timeFormat(point.timestamp[point.recordCount], "HH:mm:ss")#

Process	Instances	Page Faults	Resident	Virtual
#alias#	#instanceCount#	#numberFormat(pageFaults, ",")#	#numberFormat(resident, ",")#	#numberFormat(virtual, ",")#