Re: Merge Tables Oversight
Hi, On Fri, Apr 20, 2001 at 01:41:15PM +0100, Basil Hussain wrote: > >> 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? > > > > I never use SHOW TABLE STATUS, but you can use SHOW CREATE TABLE which > > will give you the complete CREATE TABLE statement for the MERGE table. > > This doesn't include the UNION part in MySQL 3.23.33, but I believe > > this was fixed in MySQL 3.23.36 and later. > Actually it was implemented in 3.23.34, but 3.23.34 and 3.23.35 were retracted because of some serious bugs. > I did think of SHOW CREATE TABLE, but it didn't turn up anything when I > tried it - now I know why. I'm using only version 3.23.32. > > Do you know if this fix in 3.23.36 is only concerning the client utilities, > or would I have to upgrade my server too? > It's in the server. I don't use 3.23.36 (or 37) yet because this is not important enough for me to warrant an update. My work-around is to list all tables and assume that all names with a certain prefix are part of the UNION (this should always be the case in my implementation). > I still think the mapped tables should be shown in SHOW TABLE STATUS, > though... > I didn't test it (I still use 3.23.33 with a patch) but the change list says nothing about SHOW TABLE STATUS, so this probably hasn't changed. FWIW, I agree with you. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
Re: Merge Tables Oversight
Hi, >> 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? > > I never use SHOW TABLE STATUS, but you can use SHOW CREATE TABLE which > will give you the complete CREATE TABLE statement for the MERGE table. > This doesn't include the UNION part in MySQL 3.23.33, but I believe > this was fixed in MySQL 3.23.36 and later. I did think of SHOW CREATE TABLE, but it didn't turn up anything when I tried it - now I know why. I'm using only version 3.23.32. Do you know if this fix in 3.23.36 is only concerning the client utilities, or would I have to upgrade my server too? I still think the mapped tables should be shown in SHOW TABLE STATUS, though... 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
Re: Merge Tables Oversight
Hi, On Fri, Apr 20, 2001 at 10:47:57AM +0100, Basil Hussain wrote: > 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? > I never use SHOW TABLE STATUS, but you can use SHOW CREATE TABLE which will give you the complete CREATE TABLE statement for the MERGE table. This doesn't include the UNION part in MySQL 3.23.33, but I believe this was fixed in MySQL 3.23.36 and later. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
Merge Tables Oversight
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