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
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
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
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
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
|
+---+--+---+---++--+---+-+
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
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
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
101 - 108 of 108 matches
Mail list logo