Hi Martin, this is a bug. I checked the schema code and it looks like I mixed up INDEX and PRIMARY_KEY. I put it on my todo list.
Sorry Michael Am 02.04.2012 11:20, schrieb Martin Bartosch: > 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 -- ___________________________________________________________________ Michael Bell Humboldt-Universitaet zu Berlin Tel.: +49 (0)30-2093 70143 ZE Computer- und Medienservice Fax: +49 (0)30-2093 70135 Unter den Linden 6 [email protected] D-10099 Berlin ___________________________________________________________________ PGP Fingerprint: 09E4 3D29 4156 2774 0F2C C643 D8BD 1918 2030 5AAB
smime.p7s
Description: S/MIME Kryptografische Unterschrift
------------------------------------------------------------------------------ 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
