Is there a way to change the directory used when mySQL
copies the table for creating indexes on large tables?
My tmp directory is partitioned for 509 megs and
adding an index via ATLER TABLE or CREATE TABLE yields
this:
ERROR 3: Error writing file '/tmp/STFgNG04' (Errcode:
28)
the .MYI file
On Wed, Oct 03, 2001 at 05:39:09PM +, Mike Lucente wrote:
I'm also unable to create files 2GB with mysqldump, even after a
recompile with gcc 2.96, RH 7.1 w/2.4.2 kernel, glibc 2.2.2.
AFIAK, it is limitation of ext2 file sistem.
You can't create any file lager then 2GB on ext2.
[skip]
Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
limit on 2.2.x kernels?
Or, if you have moved the tables with symlinks, MySQL will put the new file
(most of the time?) in the configured data directory and not where the
symlink points.
--Bill
Mike Lucente wrote:
I'm
If this is the case. What are the steps necessary for index rebuilds? Can
I specify where the index file is rebuilt? Any idea when we can specify
the location of datafiles and indexfiles?
Thanks, Dave
On Wed, Oct 03, 2001 at 07:57:35AM -0700, Adams, Bill TQO wrote:
Perhaps your index file
David Turner wrote:
If this is the case. What are the steps necessary for index rebuilds? Can
I specify where the index file is rebuilt? Any idea when we can specify
the location of datafiles and indexfiles?
For the kernel: You either need to upgrade to a later 2.4.x series kernel which,
I
I'm running 2.4.2 and I'm not using symlinks.
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
limit on 2.2.x kernels?
Or, if you have moved the tables with symlinks, MySQL will put the new file
(most of the time?) in the
I'm also unable to create files 2GB with mysqldump, even after a
recompile with gcc 2.96, RH 7.1 w/2.4.2 kernel, glibc 2.2.2.
hmmm ...
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
limit on 2.2.x kernels?
Or, if you
-
From: Mike Lucente [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 1:25 PM
To: Adams, Bill TQO
Cc: [EMAIL PROTECTED]
Subject: Re: Creating indexes on large tables
I'm running 2.4.2 and I'm not using symlinks.
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
Perhaps your index file
Hi!
On Oct 03, Mike Lucente wrote:
I'm running out of space while creating indexes on some fairly large (1.8
GB) tables, even though I have quite a bit of space available in the
partition (utilization is at 30%).
I know that the create process works as follows (from the manual):
Create
Apparently you have to compile for large file support and have glibc 2.1.3.
http://www.suse.de/~aj/linux_lfs.html
I have not used it so I do not know the real-world limitations.
Or (for 100MB files):
mysqldump db table |split -b 1 - table
--Bill
Mike Lucente wrote:
I'm also
This worked once I recompiled the distribution. Thanks.
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
Apparently you have to compile for large file support and have glibc 2.1.3.
http://www.suse.de/~aj/linux_lfs.html
I have not used it so I do not know the real-world limitations.
Or (for
11 matches
Mail list logo
