Ah, the symbolic links.. Forgot about them... Thanks.
----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
To: "Lou Olsten" <lou.olsten@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, June 08, 2004 3:49 PM
Subject: Re: Moving tables to different disks (High Performance MySQL)
> In the last episode (Jun 08), Lou Olsten said:
> > In the High Performance MySQL book, on page 124, the author suggests:
> >
> > "If you have all your MySQL data on a single disk, you can try moving
> > pieces to another disk. If the majority of activity is focused on a
> > small group of tables, consider moving them to a separate disk."
> >
> > How do you accomplish that? I know InnoDB now allows you to specify
> > a tablespace per table, but what about MyISAM table types?
>
> With MyISAM tables, you can move just about anything: entire
> databases, tables, even just the indexes. Just move the files, and
> create symlinks in their place pointing to the new locations.
>
> --
> Dan Nelson
> dnelson@stripped
