LANDesk cores need a bit of hand holding. ldms_core keeps cruft from piling up and tells you about problems. It produces statistics, alerts, and advice for monitoring the health of LANDesk Management Suite and Security Suite.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001216s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.066489s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000993s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001111s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000831s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003353s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000898s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003647s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015177s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001160s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 228210 [ RunTime:0.017027s ]