Re: [AMaViS-user] Wow! CPU "high load"... [was Wow! CPU overload...]

On Thu, Aug 11, 2005 at 12:12:44PM -0400, Matt Juszczak wrote:

> >You might try to make better indexes on the LDAP server before
> >upgrading the hardware.
> >
>
> Paul,
>
> Yep, tried this yesterday :) that was the problem. Added another index
> for mailRoutingAddress (I already had mailLocalAddress created but I
> guess the mailRoutingAddress needed one too) and now we're experiencing
> instant mail delivery with no queues :)

You definitely want to make sure you have indexes on any attribute used
in searches, it can make a huge difference as you found out. If you're
using OpenLDAP and 'bdb' databases you also want to make sure and
configure the Berkely DB environment with a DB_CONFIG file, and use
db_stat to check things. Below is an excerpt from one of our mail
servers at work:

$ db_stat-4.2 -h /var/db/openldap-data -m

31MB 257KB 604B Total cache size.
1 Number of caches.
31MB 264KB Pool individual cache size.
0 Requested pages mapped into the process' address space.
4253M Requested pages found in the cache (100%).
40 Requested pages not found in the cache.
4374 Pages created in the cache.
40 Pages read into the cache.
405215 Pages written from the cache to the backing file.
0 Clean pages forced from the cache.
0 Dirty pages forced from the cache.
0 Dirty pages written by trickle-sync thread.
4414 Current total page count.
4228 Current clean page count.
186 Current dirty page count.
4099 Number of hash buckets used for page location.
4253M Total number of times hash chains searched for a page.
4 The longest hash chain searched for a page.
1617M Total number of hash buckets examined for page location.
4222M The number of hash bucket locks granted without waiting.
0 The number of hash bucket locks granted after waiting.
0 The maximum number of times any hash bucket lock was waited for.
16125 The number of region locks granted without waiting.
0 The number of region locks granted after waiting.
4514 The number of page allocations.
0 The number of hash buckets examined during allocations
0 The max number of hash buckets examined for an allocation
0 The number of pages examined during allocations
0 The max number of pages examined for an allocation
....
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: mailAlternateAddress.bdb
4096 Page size.
0 Requested pages mapped into the process' address space.
44M Requested pages found in the cache (100%).
2 Requested pages not found in the cache.
656 Pages created in the cache.
2 Pages read into the cache.
94273 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: mailAccountStatus.bdb
4096 Page size.
0 Requested pages mapped into the process' address space.
1035M Requested pages found in the cache (100%).
2 Requested pages not found in the cache.
34 Pages created in the cache.
2 Pages read into the cache.
7041 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: mail.bdb
4096 Page size.
0 Requested pages mapped into the process' address space.
346M Requested pages found in the cache (100%).
2 Requested pages not found in the cache.
635 Pages created in the cache.
2 Pages read into the cache.
83314 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
....

Correctly sizing the cache can make a big difference as answers can be
pulled from it vs acessing the disks.

--
Patience HELL! Let's kill something!

Mike Hall,
System Admin - Rock Island Communications <mikeh@rockisland.com>
System Admin - riverside.org, ssdd.org <mhall@riverside.org>


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/