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: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|