Re: Moving tables to different disks (High Performance MySQL)
Ah, the symbolic links.. Forgot about them... Thanks. - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Lou Olsten" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Moving tables to different disks (High Performance MySQL)
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? Thanks, Lou