Login or Register to Ask a Question and Join Our Community


Software Releases - RSS News

Apache SQL analyser 0.7 (Default branch)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums News, Links, Events and Announcements Software Releases - RSS News Apache SQL analyser 0.7 (Default branch)
# 1  
Old 01-02-2008
Apache SQL analyser 0.7 (Default branch)
asql allows you to run SQL queries against logfiles formatted in the Apache common log fileformat. You may load multiple log files into asession, then run queries using a full SQLimplementation, to find things such as the mostcommon referers to your site, the greediestdownloaders, and much more. Internally, each logfile is parsed and imported into a temporarySQLite database, so performance is very good.License: GNU General Public License v2Changes:
This release correctly parses the date and times of requests from Apache common log files. To aid scripting, an initialization file is now loaded at present, to load any commonly requested log files or run queries automatically at startup.Image

More...
Login or Register to Ask a Question

Previous Thread | Next Thread

1 More Discussions You Might Find Interesting

1. Web Development

Using IP.Board on FreeBSD, having SQL/Apache Issues

Server: FreeBSD 7.2-RELEASE MYSQL Version: MYSQL 5.1.36 PHP Version: 5.2.10 (apache2handler) IP.Board Version: v3.0.2 Safe Mode: OFF For the most part previously IP.Board, forum software, has run fine without any issues. Regular web pages and .php pages seem to load fine without any issues.... (2 Replies)
Discussion started by: Dark Severance
2 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

data::objectdriver::driver::cache::apache

Data::ObjectDriver::Driver::Cache::Apache(3pm)		User Contributed Perl Documentation	    Data::ObjectDriver::Driver::Cache::Apache(3pm)

NAME

       Data::ObjectDriver::Driver::Cache::Apache - object driver for caching objects in Apache's request space

SYNOPSIS

	   package MyObject;
	   use base qw( Data::ObjectDriver::BaseObject );

	   __PACKAGE__->install_properties({
	       ...
	       driver => Data::ObjectDriver::Driver::Cache::Apache->new(
		   fallback => Data::ObjectDriver::Driver::Cache::Memcached->new(
		       cache	=> Cache::Memcached->new({ servers => @MEMCACHED_SERVERS }),
		       fallback => Data::ObjectDriver::Driver::DBI->new( @$DBI_INFO ),
		   ),
	       ),
	       ...
	   });

	   1;

DESCRIPTION

       Data::ObjectDriver::Driver::Cache::Apache provides automatic caching of retrieved objects in the per-request memory space of your Apache
       mod_perl processes, when used in conjunction with your actual object driver. It can be used to provide even faster results over memcached
       when requesting objects that have already been requested during the same request by some other part of your application, at the cost of the
       memory necessary to store the objects.

       If your models can be used in an Apache mod_perl application as well as another context such as a command line shell, consider replacing
       the Apache layer of your caching with a "Data::ObjectDriver::Driver::Cache::RAM" layer when Apache is not available. See
       Data::ObjectDriver::Driver::Cache::Apache.

USAGE

       o   Data::ObjectDriver::Driver::Cache::Apache->new(%params)

	   Required members of %params are:

	   o   "fallback"

	       The "Data::ObjectDriver" object driver from which to request objects that are not found in the Apache process cache.

DIAGNOSTICS

       The Apache driver provides integration with the "Data::ObjectDriver" debug and profiling systems. As these systems are designed around SQL
       queries, synthetic queries are logged to represent caching operations. The operations generated by this driver are:

       o   "APACHECACHE_GET ?"

	   Retrieve an object. The argument is the cache key for the requested object.

       o   "APACHECACHE_ADD ?,?"

	   Add an object to the cache. The arguments are the cache key for the object and the flattened representation of the object to cache.

       o   "APACHECACHE_SET ?,?"

	   Put an object in the cache. The arguments are the cache key for the object and the flattened representation of the object to cache.

       o   "APACHECACHE_DELETE ?"

	   Remove an object from the cache. The argument is the cache key for the object to invalidate.

SEE ALSO

       Apache, Apache2::RequestUtil

LICENSE

       Data::ObjectDriver is free software; you may redistribute it and/or modify it under the same terms as Perl itself.

AUTHOR &; COPYRIGHT
       Except where otherwise noted, Data::ObjectDriver is Copyright 2005-2006 Six Apart, cpan@sixapart.com. All rights reserved.

perl v5.12.4							    2011-08-29			    Data::ObjectDriver::Driver::Cache::Apache(3pm)