[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Problems with openldap-2.1.22 slowing down over time.
- To: openldap-software@OpenLDAP.org
- Subject: Problems with openldap-2.1.22 slowing down over time.
- From: Matthew Schumacher <matt.s@aptalaska.net>
- Date: Wed, 12 Nov 2003 13:12:18 -0900
- User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031007
List,
I have been fighting with slow down issues with openldap. I wrote a
query that I run ever hour to monitor performance. Over time the query
gets to be very slow (47 secs at the beginning of the attached log) only
using 2% of the cpu, then I tried to slapindex the database and it takes
minutes per record to index so I ctl-c and it leaves the database
completely corrupt.
If I export the database into an ldif file then delete the openldap-data
dir and reload it, then the query goes back to 1sec for a while and
eventually slows down again.
Anyone know what this could be, I'm not sure how to identify the problem.
This database is only updated though a php interface I wrote, but it is
queried by sendmail, nss_ldap, pam_ldap, php, and perl.
Thanks,
schu
Logs:
Sun Nov 9 14:07:01 AKST 2003: 1.01user 0.05system 0:47.65elapsed 2%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 15:07:01 AKST 2003: 1.00user 0.05system 0:46.57elapsed 2%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 16:07:01 AKST 2003: 0.97user 0.06system 0:49.70elapsed 2%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 17:07:01 AKST 2003: 1.06user 0.04system 0:44.72elapsed 2%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 18:07:01 AKST 2003: 1.04user 0.01system 0:45.85elapsed 2%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 19:07:01 AKST 2003: 1.02user 0.06system 0:45.59elapsed 2%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 20:04:12 AKST 2003: 1.02user 0.05system 0:01.10elapsed 96%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 20:07:01 AKST 2003: 1.09user 0.07system 0:01.55elapsed 74%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 21:07:01 AKST 2003: 1.14user 0.04system 0:01.68elapsed 70%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 22:07:01 AKST 2003: 1.03user 0.07system 0:01.51elapsed 72%CPU
(0avgtext+0avgdata 0maxresident)k
Sun Nov 9 23:07:01 AKST 2003: 0.88user 0.07system 0:01.50elapsed 63%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 00:07:01 AKST 2003: 1.11user 0.05system 0:01.55elapsed 74%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 01:07:01 AKST 2003: 0.94user 0.06system 0:01.50elapsed 66%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 02:07:01 AKST 2003: 1.11user 0.02system 0:01.56elapsed 72%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 03:07:01 AKST 2003: 1.06user 0.05system 0:01.53elapsed 72%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 04:07:01 AKST 2003: 1.05user 0.05system 0:01.54elapsed 71%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 05:07:01 AKST 2003: 1.03user 0.08system 0:01.56elapsed 70%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 06:07:01 AKST 2003: 1.03user 0.08system 0:01.66elapsed 66%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 07:07:01 AKST 2003: 1.02user 0.05system 0:01.67elapsed 63%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 08:07:01 AKST 2003: 0.98user 0.09system 0:01.58elapsed 67%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 09:07:01 AKST 2003: 1.07user 0.09system 0:02.55elapsed 45%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 10:07:01 AKST 2003: 1.06user 0.03system 0:01.56elapsed 69%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 11:07:01 AKST 2003: 0.93user 0.08system 0:02.56elapsed 39%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 12:07:02 AKST 2003: 0.90user 0.04system 0:02.62elapsed 35%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 13:07:01 AKST 2003: 1.03user 0.08system 0:03.49elapsed 31%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 14:07:01 AKST 2003: 1.03user 0.03system 0:03.58elapsed 29%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 15:07:01 AKST 2003: 1.05user 0.02system 0:02.52elapsed 42%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 16:07:01 AKST 2003: 1.05user 0.07system 0:02.53elapsed 44%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 17:07:01 AKST 2003: 0.97user 0.07system 0:03.57elapsed 29%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 18:07:01 AKST 2003: 1.02user 0.04system 0:02.52elapsed 42%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 19:07:01 AKST 2003: 0.99user 0.10system 0:03.55elapsed 30%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 20:07:01 AKST 2003: 0.94user 0.06system 0:02.57elapsed 38%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 21:07:02 AKST 2003: 0.92user 0.08system 0:03.54elapsed 28%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 22:07:01 AKST 2003: 0.96user 0.03system 0:03.60elapsed 27%CPU
(0avgtext+0avgdata 0maxresident)k
Mon Nov 10 23:07:01 AKST 2003: 1.07user 0.06system 0:04.55elapsed 24%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 00:07:01 AKST 2003: 1.04user 0.04system 0:03.58elapsed 30%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 01:07:01 AKST 2003: 1.00user 0.03system 0:03.69elapsed 27%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 02:07:01 AKST 2003: 1.02user 0.04system 0:03.70elapsed 28%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 03:07:01 AKST 2003: 0.91user 0.11system 0:04.59elapsed 22%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 04:07:01 AKST 2003: 1.07user 0.03system 0:03.53elapsed 31%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 05:07:01 AKST 2003: 1.04user 0.02system 0:04.59elapsed 23%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 06:07:01 AKST 2003: 0.99user 0.08system 0:03.56elapsed 30%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 07:07:01 AKST 2003: 1.02user 0.08system 0:04.57elapsed 24%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 08:07:01 AKST 2003: 0.96user 0.04system 0:05.56elapsed 17%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 09:07:01 AKST 2003: 1.01user 0.04system 0:03.57elapsed 29%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 10:07:02 AKST 2003: 1.05user 0.07system 0:05.62elapsed 19%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 11:07:01 AKST 2003: 1.01user 0.08system 0:07.73elapsed 14%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 12:07:01 AKST 2003: 0.97user 0.06system 0:06.52elapsed 15%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 13:07:01 AKST 2003: 1.04user 0.04system 0:09.49elapsed 11%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 14:07:01 AKST 2003: 1.04user 0.07system 0:09.88elapsed 11%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 15:07:01 AKST 2003: 1.02user 0.04system 0:06.57elapsed 16%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 16:07:01 AKST 2003: 0.93user 0.08system 0:06.57elapsed 15%CPU
(0avgtext+0avgdata 0maxresident)k
Tue Nov 11 17:07:01 AKST 2003: 1.11user 0.07system 0:07.57elapsed 15%CPU
(0avgtext+0avgdata 0maxresident)k