Hi,
we use application-level partitioning (but no real partitioning in mysqld),
where new tables are created daily with the same structure, but different
name (suffix).
- mysqld is shared for these components:
- daemon written in C++
- creates new tables every day and fills them with records
- other daemon written in Python:
- periodically scans *information_schema.tables* for new tables and
creates Table objects, which haven't been initialized before
- the same daemon then processes records from all tables and computes
some statistics on top of them
- daily cronjob drops tables older than *n* days
*The problem:*
Pythonic daemon has to somehow notice that some tables were dropped and
unload them from Metadata object. Otherwise, it will fail on
ProgrammingError: table does not exit
We don't want to establish any messaging between daemons, just to keep the
setup as it is.
Daemon should compare what's in *information_schema* and what's in Metadata
and remove Table objects. How to do that?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
