Hi Achim, Am 29.03.2012 um 17:21 schrieb Joachim Astel:
> I have recognized a load issue when doing parallel searches within the > openxpki database. > > When I try ~ 20 parallel queries to the OpenXPKI database by dowing > a database search after certificates - each witch an increased number > of entries to be shown per page to 100, the load of the machine is > going up very fast because the machine is waiting for I/O. > > Is there some way to finetune this (restrict maximum number of parallel > API connections, optimize I/O with search queries et al.)? sorry for the late answer, I was on vacation. Back in town now, catching up with my emails... I assume your database schema is missing the proper indices. I noticed that the database initialization code does not produce all necessary index declarations. In our setup we added additional ones which solved a similar problem. The following is an excerpt from our database init script for one of our Oracle installations. In particular, have a look at the indices on the workflow_context table. CREATE INDEX wf_state_state on workflow (workflow_state); CREATE INDEX cert_realm_index on certificate (pki_realm); CREATE INDEX csr_profile_index on csr (profile); CREATE INDEX csr_role_index on csr (role); CREATE INDEX cert_csrid_index on certificate (req_key); CREATE INDEX wf_realm_index on workflow (pki_realm); CREATE INDEX csr_subject_index on csr (subject); CREATE INDEX wf_context_value_index on workflow_context (workflow_context_value); CREATE INDEX cert_role_index on certificate (role); CREATE INDEX wf_hist_wfserial_index on workflow_history (workflow_id); CREATE INDEX wf_context_key_index on workflow_context (workflow_context_key); CREATE INDEX wf_type_index on workflow (workflow_type); CREATE INDEX cert_subject_index on certificate (subject); CREATE INDEX cert_identifier_index on certificate (identifier); CREATE INDEX cert_status_index on certificate (status); CREATE INDEX cert_attributes_key_index on certificate_attributes (attribute_contentkey); CREATE INDEX cert_attributes_value_index on certificate_attributes (attribute_value); Hope this helps, Martin ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ OpenXPKI-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-devel
