Very nice tutorial, this is what I've been looking for - though for CentOS. I'm sure I can adapt it as required. However, my question is, does logged to a database instead of a file show any sort of performance issues? I currently have an environment with several virtual hosts - all of which I would like to convert to a DB to log, for both access and errors. Should I expect any sort of performace hit when I convert to a database to log these errors? Each of these existing sites is database intensive in its own right. Will this cause problems?
To be honest, for high-traffic web sites, I wouldn't use MySQL logging. I haven't made any benchmarks, but I'm sure it needs more resources than logging to a file.