List:General Discussion« Previous MessageNext Message »
From:Lou Olsten Date:June 8 2004 8:12pm
Subject:Re: Moving tables to different disks (High Performance MySQL)
View as plain text  
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
Thread
Moving tables to different disks (High Performance MySQL)Lou Olsten8 Jun
  • Re: Moving tables to different disks (High Performance MySQL)Dan Nelson8 Jun
  • Re: Moving tables to different disks (High Performance MySQL)Lou Olsten8 Jun