List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 16 1999 6:03pm
Subject:Re: Can databases be stored in multiple directories?
View as plain text  
At 10:18 AM -0700 7/16/99, David Wall wrote:
>----- Original Message -----
>From: Paul DuBois <paul@stripped>
>To: Andy Frankford <andy@stripped>; MYSQL List
><mysql@stripped>
>Cc: _Forkner, Bob, _ACI <bob@stripped>; _CEO
><CEO@stripped>
>Sent: Friday, July 16, 1999 8:02 AM
>Subject: RE: Can databases be stored in multiple directories?
>
>
>> That's correct.  Don't use symlinks for tables, though.  ALTER TABLE and
>> OPTIMIZE TABLE will surprise you.
>
>What's the surprise?  It seems odd that this just doesn't work, provided you
>move the table and its associated files (tablename.*) all with symlinks.  I
>thought on Unix/Linux, symlinks were in the OS and therefore would be
>completely transparent to an application using them.

ALTER TABLE and OPTIMIZE work by making a temporary table in the 
database directory,
then deleting the original and renaming the temporary table to the original
name.

But deleting the original only deletes the symlinks.  The files the symlinks
pointed to are still where they were, only now they're orphaned.  And 
the modified
table is in the database directory.


>Obviously, something else is going on, but moving a table seems more likely
>a necessity than moving an entire DB, since there's bound to be a table that
>grows so big it needs to move, and moving the entire DB doesn't help solve
>the problem all that well.

But moving individual tables around is more of an administrative headache
than moving the entire directory.

-- 
Paul DuBois, paul@stripped
Thread
Can databases be stored in multiple directories?Anna Winkler15 Jul
  • transfer from MS SQL to MySQL?Hawke Robinson15 Jul
    • RE: transfer from MS SQL to MySQL?Tupshin Harper16 Jul
  • Can databases be stored in multiple directories?sinisa16 Jul
  • Re: Can databases be stored in multiple directories?Chris Cleveland16 Jul
    • Re: Can databases be stored in multiple directories?sinisa16 Jul
  • Re: Can databases be stored in multiple directories?Sasha Pachev16 Jul
Re: Can databases be stored in multiple directories?Paul DuBois16 Jul
  • RE: Can databases be stored in multiple directories?Andy Frankford16 Jul
    • RE: Can databases be stored in multiple directories?Fraser MacKenzie16 Jul
    • RE: Can databases be stored in multiple directories?Paul DuBois16 Jul
    • Re: Can databases be stored in multiple directories?David Wall16 Jul
      • Re: Can databases be stored in multiple directories?Paul DuBois16 Jul
Re: Can databases be stored in multiple directories?J. Kochevar16 Jul
  • Re: Can databases be stored in multiple directories?Paul DuBois16 Jul
Re: Can databases be stored in multiple directories?Derick H Siddoway16 Jul