httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Kew <>
Subject Re: [users@httpd] mod_dav getcontenttype high number of authentication queries
Date Tue, 02 Aug 2011 13:01:54 GMT
On Tue, 02 Aug 2011 11:56:20 +0100
FreeBSD Ports <> 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 to 
> the 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?

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.

Nick Kew

The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:> for more info.
To unsubscribe, e-mail:
   "   from the digest:
For additional commands, e-mail:

View raw message