[Date Prev][Date Next] [Chronological] [Thread] [Top]

db_stat find high cpu usage



Title: Firma Institucional

Hello list.

I have a server not performing well - openldap shows high cpu usage and iowait of server is high

db_stat -h /var/lib/ldap -c

555     Last allocated locker ID
0x7fffffff      Current maximum unused locker ID
9       Number of lock modes
1000    Maximum number of locks possible
1000    Maximum number of lockers possible
1000    Maximum number of lock objects possible
40      Number of lock object partitions
10      Number of current locks
645     Maximum number of locks at any one time
18      Maximum number of locks in any one bucket
0       Maximum number of locks stolen by for an empty partition
0       Maximum number of locks stolen for any one partition
141     Number of current lockers
152     Maximum number of lockers at any one time
10      Number of current lock objects
623     Maximum number of lock objects at any one time
6       Maximum number of lock objects in any one bucket
0       Maximum number of objects stolen by for an empty partition
0       Maximum number of objects stolen for any one partition
1237M   Total number of locks requested (1237918767)
1237M   Total number of locks released (1237917421)
0       Total number of locks upgraded
103     Total number of locks downgraded
492M    Lock requests not available due to conflicts, for which we waited (492996269)
1336    Lock requests not available due to conflicts, for which we did not wait
0       Number of deadlocks
0       Lock timeout value
0       Number of locks that have timed out
0       Transaction timeout value
0       Number of transactions that have timed out
736KB   The size of the lock region
3685M   The number of partition locks that required waiting (135%)
3665M   The maximum number of times any partition lock was waited for (108%)
19810   The number of object queue operations that required waiting (0%)
2443M   The number of locker allocations that required waiting (58%)
0       The number of region locks that required waiting (0%)
6       Maximum hash bucket length

Are the lines in red really correct or just side effects ? How do I go about it ? I can have anything else? Increase cache? How?

 db_stat -h /var/lib/ldap -m
12MB 514KB 24B  Total cache size
1       Number of caches
1       Maximum number of caches
12MB 520KB      Pool individual cache size
0       Maximum memory-mapped file size
0       Maximum open file descriptors
0       Maximum sequential buffer writes
0       Sleep after writing maximum sequential buffers
0       Requested pages mapped into the process' address space
788M    Requested pages found in the cache (21%)
2867M   Requested pages not found in the cache (2867396236)
740     Pages created in the cache
2863M   Pages read into the cache (2863007508)
228732  Pages written from the cache to the backing file
2865M   Clean pages forced from the cache (2865409816)
206860  Dirty pages forced from the cache
0       Dirty pages written by trickle-sync thread
681     Current total page count
681     Current clean page count
0       Current dirty page count
2053    Number of hash buckets used for page location
1567M   Total number of times hash chains searched for a page (1567726752)
6       The longest hash chain searched for a page
597M    Total number of hash chain entries checked for page (597110368)
2479M   The number of hash bucket locks that required waiting (61%)
2211M   The maximum number of times any hash bucket lock was waited for (771%)
73M     The number of region locks that required waiting (4%)
0       The number of buffers frozen
0       The number of buffers thawed
0       The number of frozen buffers freed
2867M   The number of page allocations (2867487657)
2436M   The number of hash buckets examined during allocations (2436374360)
4110    The maximum number of hash buckets examined for an allocation
2867M   The number of pages examined during allocations (2867478740)
17      The max number of pages examined for an allocation
76217   Threads waited on page I/O


Thanks very Much.

--

 

Fabián M. Sales
Soporte Técnico & I.T.I Linux

DonWeb 
La Actitud Es Todo
www.DonWeb.com

 


Nota de confidencialidad: Este mensaje y archivos adjuntos al mismo son confidenciales, de uso exclusivo para el destinatario del mismo. La divulgación y/o uso del mismo sin autorización por parte de DonWeb.com queda prohibida.
DonWeb.com no se hace responsable del mensaje por la falsificación y/o alteración del mismo.
De no ser Ud el destinatario del mismo y lo ha recibido por error, por favor, notifique al remitente y elim?elo de su sistema.
Confidentiality Note: This message and any attachments (the message) are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited by DonWeb.com.
DonWeb.com shall not be liable  for the message if altered or falsified.
If you are not the intended addressee of this message, please cancel it immediately and inform the sender
Nota de Confidencialidade: Esta mensagem e seus eventuais anexos podem conter dados confidenciais ou privilegiados.
Se você os recebeu por engano ou não é um dos destinatários aos quais ela foi endereçada, por favor destrua-a e a todos os seus eventuais anexos ou copias realizadas, imediatamente.
É proibida a retenção, distribuição, divulgação ou utilização de quaisquer informações aqui contidas.
Por favor, informenos sobre o recebimento indevido desta mensagem, retornando-a para o autor.