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