I'm running MySQL 3.23.21 on Windows98.
I initialized a MYISAM table as follows:
create table test1_i
(id char(10) not null primary key,pwd char(17)) raid_type = 1;
If a lot of data are inserted on it, the index file (MYI) cannot exceed
65536*1024-16 bytes,
and comes to return the error code 136 (HA_ERR_INDEX_FILE_FULL).
I think that it is the error code that the mi_write function of myisam/
mi_write.c has returned.
Are there any method or patch which change this maximum size by the safe
method?
I also think that I will shift to Windows2000 and MySQL4.0.
What max size of an index file in MySQL4.0?
If the max size of the index is less than 2G and an index size becomes
more than 2G, how should it be coped with?
Takahara
__________________________________________________
Do You Yahoo!?
Yahoo! BB is Broadband by Yahoo! http://bb.yahoo.co.jp/
---------------------------------------------------------------------
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
