httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Kew <n...@webthing.com>
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 <freebsd.ports@tipstrade.net> 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:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message