You state that the temporary files are on a separate partition.
Does the filesystem on this partition support large files?
Chris Black wrote:
>
> I am running MySQL 3.23.32 on Linux 2.2.16 with large file support. Large
> tables (tens of GB) work fine. mysqladmin variables shows large file support
> is enabled.
> The problem I am having showed up when I loaded a bunch of data into a simple
> non-indexed table and then tried to do the following to build the indexes:
> (NOTE: the reason I do it this way is to hopefully increase speed since I know
> ALTER TABLE makes a complete copy of the table and this table is over 8GB)
>
> mysqladmin flush-tables
> cd ~mysql/Database/
> mv table.MYD table.MYD.saved
> SQL> truncate table;
> SQL> ALTER TABLE table ADD PRIMARY KEY (field1, field2);
> SQL> ALTER TABLE table ADD INDEX indexname (field2);
> mysqladmin flush-tables
> mv table.MYD.saved table.MYD
> myisamchk -t /db/ -r -q -O sort_buffer_size=512M table.MYI
>
> The output/error I get is:
> - check key delete-chain
> - check record delete-chain
> - recovering (with sort) MyISAM-table 'RawMatch.MYI'
> Data records: 201326371
> - Fixing index 1
> myisamchk: Error writing file '/db/STAHOIjf' (Errcode: 27)
> myisamchk: error: 27 when fixing table
> MyISAM-table 'RawMatch.MYI' is not fixed because of errors
> Try fixing it by using the --safe-recover (-o) option
>
> I looked up error 27 using the perror tool and got:
> Error code 27: File too large
>
> Now, this filesystem definately has large file support since there are already
> files over 2GB on it that work. It also has plenty of free space. I made sure
> to direct the temporary files to a partition with space.
>
> So my question is, why is this happening? How can I fix it? I haven't tried
> safe-recover yet as I get the impression it would take a LONG time to complete,
> and although the documentation says it uses less disk space, I don't know if
> it would help.
>
> I am now just going to do the alter table on the full database, which will
> mean it makes a full copy, inefficient, but hopefully it will work.
>
> But I would like to know what causes this error and what I can do to fix it.
> Are there other good ways of importing lots of data into a table and then
> building the index later?
>
> Thanks,
> Chris
>
> ------------------------------------------------------------------------
> Part 1.2Type: application/pgp-signature
---------------------------------------------------------------------
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
