Hi @ all again, one final thought while my ArchMgr still validates its database: I have compared my MySQL Status output with a running SPECTRUM installation with DDM up and doing what it should. I have seen that on my new machine there is a "key_blocks_unused" counter constantly decreasing while the "key_rad" parameter is growing:
mysql> show STATUS LIKE "%key%"; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | Com_assign_to_keycache | 0 | | Com_preload_keys | 0 | | Com_show_keys | 0 | | Handler_read_key | 0 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 220989 | <--- | Key_blocks_used | 8565 | | Key_read_requests | 8565 | | Key_reads | 8565 | | Key_write_requests | 0 | | Key_writes | 0 | +------------------------+--------+ 11 rows in set (0,00 sec) In my running DDM environment, this counter is zero: mysql> show STATUS LIKE "%key%"; +------------------------+------------+ | Variable_name | Value | +------------------------+------------+ | Com_assign_to_keycache | 0 | | Com_preload_keys | 0 | | Com_show_keys | 0 | | Handler_read_key | 0 | | Key_blocks_not_flushed | 222 | | Key_blocks_unused | 0 | <----- | Key_blocks_used | 7170 | | Key_read_requests | 2465816151 | | Key_reads | 18893015 | | Key_write_requests | 412673691 | | Key_writes | 79520576 | +------------------------+------------+ 11 rows in set (0,00 sec) Could it be that this is my indicator when to expect an end to this mess? 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 14:22 ----- Von: Christian Fieres <[email protected]> An: "spectrum" <[email protected]>, Datum: 08.01.2013 13:52 Betreff: WG: RE: [spectrum] Long ArchMgr start with huge DDM DB 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] 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]
