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
---
To unsubscribe from spectrum, send email to [email protected] with the body:
unsubscribe spectrum [email protected]
