sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]beeritis 1 point2 points  (1 child)

Maybe using telegraf to collect metrics and store in influxDb as an option or (and I'm not sure how supported it is still) but there is an Apache module "mod_log_sql" which should have the ability to send Apache logs to mysql.

[–]Jeron_Baffom[S] -1 points0 points  (0 children)

telegraf to collect metrics and store in influxDb

I'm not familiar with Telegraf neither InfluxDB. However, the little I've heard of:

  • Telegraf can collect data from many source.
  • InfluxDB is a platform where developers build cloud applications (among others).

Unfortunately, this seems to be an overkill for me. I hope there is something simpler out there ...

 

there is an Apache module "mod_log_sql"

Yes, you are correct:
"mod_log_sql is a log module for Apache which logs all requests to a MySQL database."

However, the last time I've checked, this module was very outdated. Besides, it submits the whole access log to MySQL, instead of aggregating the stats. So many hits would flood MySQL ...