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
