1) It's on a RAID, the seq test (just using a perl script to write files
coninuously) reach >50MBytes/sec
2) Sorry I don't understand
3) I've no idea. I've tried on UFS (on FreeBSD 3.2 3.4 3.5 4.1.1 and 4.2)
and ext2 (on newest Debian release)
4) It's on Dual xeon P2 400 1MB Cache, with 1G ram on board
It's slow because it contains many files. i.e. Reading a big files is always
faster than reading many small files
----- Original Message -----
From: "Artem Koutchine" <[EMAIL PROTECTED]>
To: "Sam Wong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 9:58 PM
Subject: Re: Copying Database
> This is totally weird!
> Untar should be faster then tar on a any normal
> computer under normal os with normal hdds.
> So, your problem could be:
> 1) Your hdds are way too slow
> 2) Incorrect HDD interface setup
> 3) Your FS setup is terrible (like no write chaching at all)
> 4) The machine which you are untarring on has a very weak CPU
>
>
>
> ----- Original Message -----
> From: "Sam Wong" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 29, 2001 4:20 PM
> Subject: Re: Copying Database
>
>
> > It's quite fast for tar, just around 10-20 minutes. But it's
> unacceptable
> > slow when untar, more than 3 hours! I just want to know if there's
> any
> > efficient way to do that...
> >
> > ----- Original Message -----
> > From: "Lars Schioler" <[EMAIL PROTECTED]>
> > To: "Sam Wong" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Monday, January 29, 2001 9:13 PM
> > Subject: Re: Copying Database
> >
> >
> > > Try copying your databasefiles (mysqlhome/data), tar'ed or
> untar'ed,
> > > to the mysql/data location.
> > > According to specs this should do it
> > >
> > > regards
> > >
> > > ----- Original Message -----
> > > From: "Sam Wong" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Monday, January 29, 2001 1:47 PM
> > > Subject: Copying Database
> > >
> > >
> > > > I know this question may not be mysql related, sorry.
> > > >
> > > > I would like to know what's the faster way to duplicate all
> database to
> > > > another machine. I've over 100000 tables in each three database,
> it's
> > very
> > > > slow to use cp, and very slow to when untar (over 3 hours!)
> > > > Do you have any solution?
> > > >
> > > > Thx in advance
> > > >
> > > >
> > > >
> > >
> > --------------------------------------------------------------------
> -
> > > > 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
> <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> > > >
> > > >
> > >
> > >
> >
> > --------------------------------------------------------------------
> -
> > > 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 <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
> > >
> >
> >
> > --------------------------------------------------------------------
> -
> > 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 <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
