List:General Discussion« Previous MessageNext Message »
From:Markwalder Philip Date:June 18 2001 12:40pm
Subject:Re: raid tables
View as plain text  
Hi Samuel

I would do this in sql. I thinks this would be much more convenient to administrate. It
would be great if you would see these informations also in with the command eg:

show database storage 

and you can see as return, where the files are located.


Thanks

Philip

On Mon, 18 Jun 2001 12:13:50 +0200 (CEST)
Tonu Samuel <tonu@stripped> wrote:

> On Mon, 18 Jun 2001, Jamie Krasnoo wrote:
> 
> > Yes. It definitely would. I didn't know Yahoo uses MySQL.
> > 
> > What would be great for an interim is if a script could determine the space
> > available and suggest the settings to create the table. I see that by
> > setting RAID_CHUNKS you could tell how many directories MySQL should make.
> > The script could evenly distribute those directories and make the links and
> > directories for MySQL.
> > Sent: Sunday, June 17, 2001 11:53 PM
> > To: Jamie Krasnoo
> > Cc: MySQL
> > Subject: Re: raid tables
> > 
> > 
> > On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote:
> > >
> > > Is there a way to tell MySQL to automatically spread its tables over
> > > a number of disks without going through the trouble of symbolic
> > > linking the chunks to the different disks?
> > 
> > There isn't yet, no. It'd certainly be a nice addition, though,
> > wouldn't it?
> 
> As author of this RAID code I would like to know, how did you see this in
> your mind:
> 
> - As MySQL command "DISTRIBUTE TABLES ...."?
> - As some kind of external script?
> - Other way?
> 
> I would like to implement this feature but currently I do not see an
> smooth way to do it. Maybe something like "LINK RAID DIR 1 to
> /mnt/bigdisk" ?
> 
> 
> -- 
> For technical support contracts, goto https://order.mysql.com/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Mr. Tonu Samuel <tonu@stripped>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
> /_/  /_/\_, /___/\___\_\___/   Hong Kong, China
>        <___/   www.mysql.com
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread76901@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-pm=ibp.ch@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


-- 
Besten Dank

Philip Markwalder

==============================
Markwalder Philip
Consultant
Philip.Markwalder@stripped

Trivadis AG
Kanalstrasse 5
CH-8152 Glattbrugg
Tel.:   +41- 1-808 70 20
Fax :   +41- 1-808 70 21
Mobile: +41-79-445 77 87
http://www.trivadis.com
==============================
Thread
raid tablesJamie Krasnoo18 Jun
  • Re: raid tablesJeremy Zawodny18 Jun
    • RE: raid tablesJamie Krasnoo18 Jun
      • RE: raid tablesTonu Samuel18 Jun
        • RE: raid tablesJamie Krasnoo18 Jun
          • Re: raid tablesJeremy Zawodny18 Jun
            • Re: raid tablesTonu Samuel19 Jun
              • Re: raid tablesJeremy Zawodny19 Jun
        • Re: raid tablesMarkwalder Philip18 Jun
          • RE: raid tablesSander Pilon18 Jun
    • Re: raid tablesAnthony W . Marino18 Jun