Hey guys,

I am running Apache 2.2 and did try out mod_log_mysql to make my logs to to an mysql table. Unfortunately I do run apache in prefork mode and in peak times, there are arround 700 processes running. The bad thing is that mod_log_mysql makes a new mysql connection for every single thread. This is not just causing a major mysql slowdown but also neither myisam nor innodb are able to handle the number of insters ( 3 million lines in about 12 hours ) from so man different clients and crash the table.

Is there any other solution that keeps to one mysql connection?

Regards,
Samy

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: [EMAIL PROTECTED]
  "   from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to