MySQL Forums
Forum List  »  Merge Storage Engine

Merge table data size limit?
Posted by: Pavel Vasek
Date: February 20, 2005 07:18AM

I have a strange problem with Merge table.
Actaually I have lot of big tables (cca 8630899200/261542400 Bytes/Rows each) with the same data structure and I try to create Merge table on top of them, but I get the error message:
050220 13:06:00 [ERROR] C:\MySQL\bin\mysqld-nt: Can't open file: 'cl1nm3d30m.MRG' (errno: 143)
when I try to access this Merge table.
perror says:
MySQL error: 143 = Conflicting table definitions in sub-tables of MERGE table

I am 100% sure that all tables have the same definition because if I use any subset of my data tables, it works well. I have the problem when I try to merge all of them only.

I noticed that my data tables show Max_data_length=141733920767
The largest succesfully created Merge table shows Data_length=139173249600

I thought, that summ of data tables data size should be no problem for Merge table.
Can anybody tell me what I do wrong?

I played with
set global myisam_data_pointer_size=8;
and
MAX_ROWS = 125540352000; (while creating Merge table)
but it does not help

Tested on Windows2003 MySQL 4.1.10-nt and MySQL 4.1.9-nt

Thanks anybody for any hint.

Options: ReplyQuote


Subject
Views
Written By
Posted
Merge table data size limit?
8491
February 20, 2005 07:18AM
4496
March 02, 2005 01:29PM
4399
March 08, 2005 10:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.