Hi all,
I think I may have come up against a slight niggling omission concerning
Merge tables. How does one find out what physical tables are mapped, other
than by looking at the contents of the .MRG file?
Surely this information should be displayed either when you do SHOW TABLE
STATUS or by some other means?
For example, I am currently using a Merge table to map 68 stats logging
tables into one giant table (3.5 million rows!) so that overall averages,
etc. can be calculated. As the mapping for this Merge table changes often,
it would be handy for me to be able to check the current state of the
mapping without leaving the MySQL client.
I think a list of the mapped tables (or perhaps rather the UNION()
statement) could be shown in the Create_options field of the SHOW TABLE
STATUS output, as I would assume this is the appropriate place, yes?
Maybe someone can tell me if there is any particular reason why this can't
be shown, or is it just an oversight?
Regards,
------------------------------------------------
Basil Hussain ([EMAIL PROTECTED])
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
