Hi again, as soon as the events table had been checked, everything went pretty fast and voilà, rounabout an hour and a half after first ArchMgr start, everything was up and running and my locally stored records were written to the DDB database.
Thanks to everyone inspiring me to have some deeper look into what I thought I understood very well in the first place! 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 16:10 ----- Von: Christian Fieres/M3-ON/MAINOVA/DE An: [email protected], Datum: 08.01.2013 15:14 Betreff: WG: Re: WG: Re: [spectrum] Another thought: Long ArchMgr start with huge DDM DB I now have kind of an overview what is happening. SHOW PROCESSLIST tells me that there is a CHECK TABLE on the event table running: mysql> show full processlist; +----+----------+-----------------+-------+---------+------+----------------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+----------+-----------------+-------+---------+------+----------------+-----------------------+ | 2 | spectrum | localhost:32835 | ddmdb | Query | 2576 | Checking table | CHECK TABLE event | | 3 | spectrum | localhost | ddmdb | Query | 0 | NULL | show full processlist | +----+----------+-----------------+-------+---------+------+----------------+-----------------------+ SHOW TABLE STATUS on the other hand tells me that the attribute and db_descriptor tables have been checked on January 8, 2013 whilst the event table had been checked on December 1, 2012, aswell as the other tables. So apparently ArchMgr simply does a CHECK TABLE on all tables (which IMHO db_optimize or db_maintenance also does, so I have a slight idea on how long this will be taking!). Considering the index_lengths of my tables, as soon as the event table is finished, the rest is chocolate cake. (Which in fact is not surprising giving my event table's extreme size.) Too bad I do not get any information as to how far the DBMS has come to grips with the CHECK TABLE command. This would in fact be very nice to know. As soon as this is finished, I hope I get my (as of 3 p.m.) ca. 1.2 million locally stored events written to the DDM db in time so that I can start my primary SS *before* a huge number of CLI scripts (run by cron from 10 p.m. on) try to connect to the Ssdb on my primary SS and run into errors. :-( Great what's still left to learn after 15 years of SPECTRUM administration! ;-) 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 15:04 ----- Von: Cristi Mitrana <[email protected]> An: Christian Fieres <[email protected]>, Kopie: spectrum <[email protected]> Datum: 08.01.2013 15:01 Betreff: Re: WG: Re: [spectrum] Another thought: Long ArchMgr start with huge DDM DB Cristi, sadly you're right. The value I've had in mind has now reduced to zero and still no end to the validation process. Is there really no indicator in regards to how many entities have to be validated and have already been validated - on a MySQL basis? My event table has 88 million records, is this the number the key_reads status' value will have to reach until this mess comes to an end since ArchMgr possibly checks every single entry in every table? I think the key_reads is a better indicator of the progress for the check. Let us know when/if this finishes. regards, -- Cristi Mitrana SolvIT Networks - Technical Consultant 20 Siriului St, Bulding A, 4th Floor 1st District 014354, Bucharest, Romania Mobile +40 727 840 862 Phone +40 31 405 95 71 Fax +40 31 405 95 72 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 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]
