Antwort: Re: Antwort: Re: increasing memory usage after restart of datanodes

[Hendrik Woltersdorf]

Here you are:

before all restarts:

2011-02-23 00:43:31 [MgmtSrvr] INFO     -- Node 11: Data usage is 7%(24341
32K pages of total 327680)
2011-02-23 00:43:31 [MgmtSrvr] INFO     -- Node 11: Index usage is 8%(11364
8K pages of total 131104)
2011-02-23 00:44:03 [MgmtSrvr] INFO     -- Node 10: Data usage is 7%(24346
32K pages of total 327680)
2011-02-23 00:44:03 [MgmtSrvr] INFO     -- Node 10: Index usage is 8%(11364
8K pages of total 131104)

after restart of node 11:

2011-02-23 23:46:39 [MgmtSrvr] INFO     -- Node 10: Data usage is 6%(19912
32K pages of total 327680)
2011-02-23 23:46:39 [MgmtSrvr] INFO     -- Node 10: Index usage is 6%(9055
8K pages of total 131104)
2011-02-24 00:02:16 [MgmtSrvr] INFO     -- Node 11: Data usage is 20%(66268
32K pages of total 327680)
2011-02-24 00:02:16 [MgmtSrvr] INFO     -- Node 11: Index usage is 6%(8609
8K pages of total 131104)

after restart of node 10:

2011-02-24 09:57:49 [MgmtSrvr] INFO     -- Node 10: Data usage is 20%(67835
32K pages of total 327680)
2011-02-24 09:57:49 [MgmtSrvr] INFO     -- Node 10: Index usage is 6%(8461
8K pages of total 131104)
2011-02-24 10:03:27 [MgmtSrvr] INFO     -- Node 11: Data usage is 20%(66153
32K pages of total 327680)
2011-02-24 10:03:27 [MgmtSrvr] INFO     -- Node 11: Index usage is 6%(8654
8K pages of total 131104)

regards

Hendrik Woltersdorf
XCOM AG
Tel.: [phone]
Tel. mobil: 0178/5710078
Email: Hendrik.Woltersdorf@stripped




*** XCOM AG Legal Disclaimer ***

Diese E-Mail einschliesslich ihrer Anhaenge ist vertraulich und ist allein
für den Gebrauch durch den vorgesehenen Empfaenger bestimmt. Dritten ist
das Lesen, Verteilen oder Weiterleiten dieser E-Mail untersagt. Wir bitten,
eine fehlgeleitete E-Mail unverzueglich vollstaendig zu loeschen und uns
eine Nachricht zukommen zu lassen.

This email may contain material that is confidential and for the sole use
of the intended recipient. Any review, distribution by others or forwarding
without express permission is strictly prohibited. If you are not the
intended recipient, please contact the sender and delete all copies.

Hauptsitz: Bahnstrasse 37, D-47877 Willich, USt-IdNr.: DE 812 885 664
Kommunikation: Telefon [phone], Telefax [phone],
www.xcom.de
Handelsregister: Amtsgericht Krefeld, HRB 10340
Vorstand: Matthias Albrecht, Dirk Franzmeyer, Dr. Rainer Fuchs, Marco
Marty, Dirk Werner
Vorsitzender des Aufsichtsrates: Stefan H. Tarach
                                                                           
             Matthew                                                       
             Montgomery                                                    
             <Matthew.E.Montgo                                          An 
             mery@stripped>           Hendrik Woltersdorf                
                                        <hendrik.woltersdorf@stripped>      
             24.02.2011 18:35                                        Kopie 
                                        cluster@stripped            
                                                                     Thema 
                                        Re: Antwort: Re: increasing memory 
                                        usage after restart of datanodes   
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




On Thu, 2011-02-24 at 09:36 +0100, Hendrik Woltersdorf wrote:
> Hi,
>
> we do monitor memory usage of cause; management server log atm., soon
> with the ndbinfo database. But that's pointless if the numbers
> reported from the cluster are wrong.
>

I'd also like to see the complete output for the Index/Data usage lines
before and after the restart:

Node 5: Data usage is 3%(X 32K pages of total Y)
Node 5: Index usage is 1%(M 8K pages of total N)


--
Matthew Montgomery
Principal Technical Support Engineer
Oracle USA, Inc., MySQL Support AMER
San Antonio, Texas, USA

Attachment: [text/html]

Attachment: [text/html]

Attachment: [text/html]