Hi list,
thank you to everyone who took the time to answer me. I have done some
further testing yesterday and today and this is what I found out resp.
what is important to know:
The last Maintenance and Optimization run was a few weeks ago. Doing it
spontaneously is a problem due to the limited diskspace on my mysql
partition, which is part of the reasons why I am switching to a new
hardware ,-)
Cristi gave me some important hints. First of all the variables mentioned
like key_reads etc. give a good impression on what MySQL actually does,
that is, it does anything at all, inspite of its 1 per cent CPU usage
maximum. Default key buffer size is 8 MB, whilst the mentioned BIG.cnf
gives a total of 700 MB buffer size, which I have now configured in
my-spectrum.cnf.
When I take my huge DB and import it into a DDM environment with a
database roughly the same size, ArchMgr starts in an instant - although
the database files are not the ones having been there when ArchMgr had
been stopped. MySQL nevertheless keeps running while ddm_load'ing, I
guess.
When I interrupt the ArchMgr startup sequence ("validating database") and
also stop MySQL (what I had to do to set the key_buffer size in
my-spectrum.cnf) all key_read-Counters are 0 (null) after MySQL restart
(via processd). As soon as ArchMgr runs again, the key_read variable runs
from where it had been left before the restart. (I am new to databases,
but this seems to show me that there is something going on that does not
re-run upon restart, but merely *continues* to run. That gives me hope
database validation will finish *some time*.
What I can see now is a growth in ca. 100 Key_reads a second. I have no
idea what this means for my start duration, but the system really *is*
doing something. So I guess I will simply give it some more time and see
what happens.
Another thought: Does anyone know how to relate the Key_reads value to an
actual count in the database to estimate the duration remaining?!
Freundliche Grüße / Best regards
Christian Fieres
Mainova AG
Planung und Betrieb Infrastruktur (M3-ON2)
Service Operation Center
Solmsstraße 38
60623 Frankfurt
Telefon / Phone (069) 2 13-2 36 17
Mobil / Mobile (0170) 5 60 15 63
Telefax / Facsimile (069) 2 13-9 62 36 17
E-Mail [email protected]
----- Weitergeleitet von Christian Fieres/M3-ON/MAINOVA/DE am 08.01.2013
13:37 -----
Von: Andrew Stein <[email protected]>
An: Christian Fieres <[email protected]>,
Datum: 07.01.2013 17:15
Betreff: RE: [spectrum] Long ArchMgr start with huge DDM DB
Do you think it?s simply ?too big??
Andy Stein
Duke Medicine
Infrastructure & Network Operations Technology Services
Office (919) 681-2739
Cell (919) 724-6519
From: Christian Fieres [mailto:[email protected]]
Sent: Monday, January 07, 2013 8:41 AM
To: spectrum
Subject: [spectrum] Long ArchMgr start with huge DDM DB
Hi all,
after importing (via ddm_load) a rather huge DDMdb (about 25 gig, make
with ddm_save under SPECTRUM 9.2.2H9) into a fresh 9.2.2H9 installation on
another hardware (same IP, same hostname, same LH, same landscape name),
first ArchMgr start hangs with "ArchMgr validating database" for at least
20 minutes without mysqld or ArchMgr consuming significant CPU resources.
Our SPECTRUM partner advises me to give it at least 30 minutes, just
wanted to check if anyone has experiences with moving DDM-Dbs that big
from one machine to another - and especially what happens when you start
ArchMgr for the first time. I mean, the database files are there, there is
nothing obvious ArchMgr has to do compared to an installation that had
this DDM DB already up - so what takes that long or do I have a problem?
Freundliche Grüße / Best regards
Christian Fieres
Mainova AG
Planung und Betrieb Infrastruktur (M3-ON2)
Service Operation Center
Solmsstraße 38
60623 Frankfurt
Telefon / Phone (069) 2 13-2 36 17
Mobil / Mobile (0170) 5 60 15 63
Telefax / Facsimile (069) 2 13-9 62 36 17
E-Mail [email protected]
Mainova Aktiengesellschaft Solmsstraße 38 D-60623 Frankfurt am Main
Vorsitzende des Aufsichtsrates: Dr. h. c. Petra Roth, Oberbürgermeisterin
a. D.
Vorstand: Dr. Constantin H. Alsheimer (Vorsitzender), Dr. Peter Birkner,
Lothar Herbst, Dr. Marie-Luise Wolff-Hertwig
Sitz der Aktiengesellschaft: Frankfurt am Main Amtsgericht Frankfurt HRB
7173 USt-ID-Nr. DE 114184034
Mainova steht für besten Service, faire Verträge und top Preise für Ihre
Energie - mit Auszeichnung!
Mehr Infos unter: http://www.mainova.de/auszeichnung
--To unsubscribe from spectrum, send email to [email protected] with the
body: unsubscribe spectrum [email protected]
Mainova Aktiengesellschaft Solmsstraße 38 D-60623 Frankfurt am Main
Vorsitzende des Aufsichtsrates: Dr. h. c. Petra Roth, Oberbürgermeisterin
a. D.
Vorstand: Dr. Constantin H. Alsheimer (Vorsitzender), Dr. Peter Birkner,
Lothar Herbst, Dr. Marie-Luise Wolff-Hertwig
Sitz der Aktiengesellschaft: Frankfurt am Main Amtsgericht Frankfurt HRB
7173 USt-ID-Nr. DE 114184034
Mainova steht für besten Service, faire Verträge und top Preise für Ihre
Energie - mit Auszeichnung!
Mehr Infos unter: http://www.mainova.de/auszeichnung
---
To unsubscribe from spectrum, send email to [email protected] with the body:
unsubscribe spectrum [email protected]
