Re: Merge Tables Oversight

2001-04-20 Thread Fred van Engen
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

Re: Merge Tables Oversight

2001-04-20 Thread Basil Hussain
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

Re: Merge Tables Oversight

2001-04-20 Thread Fred van Engen
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

merge tables

2001-04-04 Thread daveclark
I frequently get a error 127 on merged tables. The query is a join of two merged table with each merge table have 4 base tables. If I flush tables the query works. I notice that when have about 190 tables in memory this situation is more likely to happen. I am using 3.23.32. Using

merge tables - rename

2001-04-04 Thread daveclark
I got into trouble the other day trying to delete gobs of rows. Actually I was selecting 90% of the rows from table1 and inserting them into a table2, then deleting from table1. It was way too slow! So I stopped all activity (inserts) from table1 and flipped table1 with table2 using rename

Deadlock found with MERGE tables

2001-03-28 Thread root
| +---+--+---+---++--+---+-+ 4 rows in set (0.00 sec) Fix: Unknown Submitter-Id: submitter ID Originator:root Organization: NetCentral, Inc. MySQL support: extended email support Synopsis: Deadlock possible when working with MERGE tables Severity: serious Priority: medium Category: mysql

Re: request - insert into merge tables

2001-03-18 Thread Benjamin Pflugmann
Hello. On Mon, Mar 12, 2001 at 05:16:59PM -0600, [EMAIL PROTECTED] wrote: Seems like it would be relatively easy to implement inserting into merge tables. I'd like to be able to at an absolute minimum round-robin insert, but even better would be something like you can do with partitioning

request - insert into merge tables

2001-03-12 Thread Nathan Neulinger
Seems like it would be relatively easy to implement inserting into merge tables. I'd like to be able to at an absolute minimum round-robin insert, but even better would be something like you can do with partitioning in oracle. Baically, something like this: create table x (...) type=merge union

<    1   2