Writing Apache’s Logs to MySQL

In Profiling LAMP Applications with Apache’s Blackbox Logs, I discussed using Apache’s built-in logging directives to record server performance metrics. By recording performance metrics, web server administrators can have a historical record of how the server handled incoming HTTP requests. This article expands on that concept by adding a couple of logging directives and recording the logging data directly in a MySQL database.