I'm trying to analyze an 8gb apache access log file. I've downloaded the file to my machine but it seems to big to manage directly in a text editor. Is there something I can use to parse the details of a log file? I need to look at certain date ranges and certain url redirects. In the end I would like to graph them. An excel would be great to sort and filter but I don't think it can handle a file of that size. Any thoughts?
Also, is there something out there to get this into a database where I can query it directly?