Someone wrote:: << 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.>>
Really? The Index file wont be in the same directory as the database itself if I am using symlinks to the database? I didnt know this. Is there a way around this? Thanks. Mark A. LoPresti Senior Quantitative Analyst Thomson Financial Research and Analytics First Call/IBES 1455 Research Blvd. Rockville, MD 20850 Email: [EMAIL PROTECTED] Phone: 301.545.4630 Fax: 301.545.6650 -----Original Message----- 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 (.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 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 a new table named `A-xxx' with the requested changes. > > All rows from the old table are copied to `A-xxx'. > > The old table is renamed `B-xxx'. > > `A-xxx' is renamed to your old table name. > > `B-xxx' is deleted. > > > > Given that, I should have plenty of room. Disk utilization doesn't appear > > to exceed 60% during the process. > > > > Any idea what could be causing this? > > > > ** Running RH 7.1 on a Dell 2450. MySQL version 3.23.29a-gamma-log. > > > > --------------------------------------------------------------------- > > 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 > > -- > Bill Adams > TriQuint Semiconductor > > > --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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