 |
 |
On Sun, 22 Apr 2007, Antun Balaz wrote: > Seems that I found the solution. There are three items I would like to pint > out to: > > 1) Adding simple > > index objectclass eq > index GlueVOViewLocalID eq > > to /etc/init.d/bdii in ldbm database definitions section solved the problem on > our BDII_site. I suppose that some indexing should be added to BDII (both site > and top-level) by YAIM, since otherwise there will be problems of this type on > other sites as well. Earlier I had some indexing which was overridden by the > latest reconfiguration. Relevant link from SEE-GRID Wiki, created by Valentin > Vidic: > > http://wiki.egee-see.org/index.php/Fixing_BDII_response_time > > This is the recommended method to find out what are the attributes BDII should > be indexed on. Let me comment on that. We did not yet add indexes to the BDII because of contradictory evidence and worries about the overall effect: each index will speed up a particular query, but it also takes a possibly significant amount of CPU time to create the index, which may slow down the BDII operation! This is a concern for very busy top-level BDIIs like lcg-bdii.cern.ch. Last week we discussed doing some experiments to decide which indexes should be added. I suspect we will essentially implement Valentin's recommendations.