Home / server / Questions / 204861
Accepted
Tom Smykowski
Asked: 2010-11-23 12:03:41 +0800 CST

Errorlog, accesslog, slow query log, execution time log, traffic and req per sec into one tool?

  • 772

I'm searching for a tool designed for LAMP server that combines server Error log, Access log, slow query log, takes time of execution of PHP scripts,traffic and req per sec statistics (for example from RRDTool) and put it all into one chronological list.

Do you know this kind of tool?

performance mysql php lamp lighttpd

1 Answers

  1. Best Answer

    Splunk is a great tool for this, and free for limited processing. However, if you're looking for a homegrown solution, I would just standardize the date format, cat them all together, and then pipe them through sort. I.e.,

    cat ALL_LOGS | sort on standard field
    • 1