|
On Fri, 2006-05-05 at 14:16 -0700, Clint Byrum wrote:
> I'm curious what kind of request volume you had. I've not seen many
> numbers regarding mod_log_mysql/mod_log_sql, but I'm curious because I
> doubt it could ever handle our rates of 1000+/second.
In testing, we found an interesting limit - MySQL 4.x seems to have a
hard limit of 1000 client connections, and it can't be raised. As every
single Apache child process opens a connection to the server to log
accesses, this means that (for example) 5 Apache servers with MaxClients
set to more than 200 can block the MySQL server. In the same tests we
found that the server doesn't recover from this, so it stops Apache from
working while each child waits for its' logging connection to close.
MySQL 5.x did not show this behaviour.
Graeme
|
