On 02/08/11 14:39, FreeBSD Ports wrote:
On 02/08/11 14:01, Nick Kew wrote:Positive, it's reproducable & I can tell exactly how man queries will be executed by looking at what type of PROPFIND is being done, depth & directory contents. I am however going to set up an Ubuntu VM and see if I observe the same behaviour.On Tue, 02 Aug 2011 11:56:20 +0100 FreeBSD Ports<freebsd.ports@xxxxxxxxxxxxx> wrote:I'm using Apache 2.2.19 on FreeBSD 7.3 mod_dav v.1.0.3 mod_auth_mysql v.3.0.0 I've noticed that when I make a simple PROPFIND request to get just a getcontenttype tag a large number of authentication queries are made tothe mysql server, however if a PROPFIND with any of the other tags (eg.getcontentlength) is made, only one authentication query is made.That difference is indeed puzzling. Are you sure of it?Unfortunately, mod_authn_socache appears to be for Apache 2.3 & later, it's a great idea though and will have to look into it.The large number of queries happens when the server runs a subrequest on each file to determine whether it's accessible (and therefore whether to include it in the listing). In a normal listing you can turn it on and off with the ShowForbidden option, but I'd have to RTFM to tell whether mod_dav supports an equivalent. But that doesn't explain the difference! FWIW, even if you can't turn the behaviour off, you can avoid the repeated SQL queries with mod_authn_socache. In your case, I'd expect that to get you a substantial performance improvement.
Well, I can confirm that the same is happening on Apache on a Ubuntu 11.04 VM.
Probably the easiest thing to do is to alter the clients so they don't request the content type.
--------------------------------------------------------------------- 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
|