Importing Apache’s Access Logs into MySQL

In this experiment, we will import Apache’s access logs into the database and do SQL Query to filter the log contents.

Let us begin by producing custom log file from Apache. Modify your httpd.conf to create extra fat-free log files which is suitable to import directly into the database.

Generating custom log files in Apache

Then, we need a database that can store this raw log file.

Creating database/table to hold logs
Usually, men manage getting an erection while having sex and do not have to worry about something embarrassing, such as premature ejaculation. from uk viagra Jelqing and kegel exercises are highly generic levitra prices effective in promoting rigid erection. The combination of any of these and buy cialis generic appalachianmagazine.com can prove to be really handy. With the increasing craze of gadgets among people, it is also impacting levitra cost of sales on our sexual life too.

Importing raw apache logs into MySQL Table

Viewing the logs using SQL Query

Process as you like! eg.: Which page was served unexpectedly slowly?