{"id":421,"date":"2008-03-05T16:51:20","date_gmt":"2008-03-05T15:51:20","guid":{"rendered":"http:\/\/wp.devco.net\/?p=421"},"modified":"2011-08-25T14:25:45","modified_gmt":"2011-08-25T13:25:45","slug":"detailed_apache_stats","status":"publish","type":"post","link":"https:\/\/www.devco.net\/archives\/2008\/03\/05\/detailed_apache_stats.php","title":{"rendered":"Detailed Apache Stats"},"content":{"rendered":"<p>Apache has its native <a href=\"http:\/\/httpd.apache.org\/docs\/2.0\/mod\/mod_status.html\">mod_status<\/a> status page that many people use to pull stats into tools such as <a href=\"http:\/\/www.cacti.net\/\">Cacti<\/a> and other <a href=\"http:\/\/oss.oetiker.ch\/rrdtool\/\">RRDTool<\/a> based stats packages.  This works well but does not always provide enough details, questions such as these remain unanswered:\n<\/p>\n<ul>\n<li>How many of my requests are GET and how many are POST?<\/li>\n<li>How many 404 errors and 5xx errors do I get on my site as a whole and for <em>script.php<\/em> specifically?<\/li>\n<li>What is the average response time for the whole server, and for <em>script.php<\/em>? <\/li>\n<li>How many <em>Closed<\/em>, <em>Keep Alive<\/em> and <em>Aborted<\/em> connections do I have?<\/li>\n<\/ul>\n<p>To answer this I wrote a script that keeps a running track of your Apache process, it has many fine grained controls that let you fine tune exactly what to keep stats on. I got the initial idea from an old <a href=\"http:\/\/www.onlamp.com\/\">ONLamp<\/a> article titled <a href=\"http:\/\/www.onlamp.com\/pub\/a\/apache\/2004\/04\/22\/blackbox_logs.html\">Profiling LAMP Applications with Apache&#8217;s Blackbox Logs<\/a>. <\/p>\n<p>The article proposes a custom log format that provides the equivelant to an airplanes blackbox, a flight recorder that records more detail per request than the usual common log formats do. I suggest you read the article for background information. The article though stops short of a full data parser so I wrote one for a client who kindly agreed that I can opensource it. <\/p>\n<p>Using this and some glue in my Cacti I now have graphs showing a profile of the requests I receive for the whole site, but as you are able to apply fine grained controls to select what exactly you&#8217;ll see, you could get per server overview stats and details for just a specific scripts performance and statuses:<\/p>\n<p ><center><img decoding=\"async\" src=\"http:\/\/www.devco.net\/images\/apache_requests.png\"  \/><\/center><\/p>\n<p><center><img decoding=\"async\" src=\"http:\/\/www.devco.net\/images\/apache_request_profile.png\"  \/><\/center> <\/p>\n<p >The script creates on a regular interval a file that contains the performance data, the data is presented in <em>variable=value<\/em> data pairs, I will soon provide a Cacti and Nagios plugin to parse this output to ease integration into these tools. <\/p>\n<p>The performance data includes values such as:<\/p>\n<ul>\n<li>Amount of requests in total<\/li>\n<li>Total size of requests separated by in and out bytes<\/li>\n<li>Average response time<\/li>\n<li>Total processing time.<\/li>\n<li>Counts of connections in Close, Keep Alive and Aborted states.<\/li>\n<li>Counts for each <a href=\"http:\/\/www.w3.org\/Protocols\/rfc2616\/rfc2616-sec10.html\">valid HTTP Status code<\/a>, and aggregates for 1xx, 2xx, 3xx, 4xx and 5xx.<\/li>\n<li>The amount of GET and POST requests.<\/li>\n<li>And detail for each and every unique request the server serves.<\/li>\n<\/ul>\n<p>See the <a href=\"http:\/\/www.devco.net\/pubwiki\/ApacheBlackbox\/SampleStats\">Sample Stats<\/a> for a good example, variables are pretty self explanatory. To keep the data set small and manageable 2 selectors exist, one to choose which requests to keep details for and which to keep stats for. These can be combined with standard Apache directives such as <em>Location<\/em> to provide very fine grained stats for all or a subset of your site.<\/p>\n<p>You would need some glue to plug this into Cacti and Nagios, I will provide a script for this soon as I have time to write up some docs for it.<\/p>\n<p>Install guide etc can be found on my <a href=\"https:\/\/github.com\/ripienaar\/apache-blackbox\">GitHub<\/a> there is also extensive Perldoc Docs in the script, the GitHub also have links to downloading the script.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Apache has its native mod_status status page that many people use to pull stats into tools such as Cacti and other RRDTool based stats packages. This works well but does not always provide enough details, questions such as these remain unanswered: How many of my requests are GET and how many are POST? How many [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","footnotes":""},"categories":[7,6],"tags":[45,121,19,46],"_links":{"self":[{"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/posts\/421"}],"collection":[{"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/comments?post=421"}],"version-history":[{"count":4,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/posts\/421\/revisions"}],"predecessor-version":[{"id":2240,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/posts\/421\/revisions\/2240"}],"wp:attachment":[{"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/media?parent=421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/categories?post=421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devco.net\/wp-json\/wp\/v2\/tags?post=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}