Aha! Many files you say. Well, the try:
-noatime, -async options for filesystem
(it quadrupled perfomance for me) or
use SoftUpdates (when on FreeBSD 4.2-stable only,
before than SoftUpdates were unstable).
----- Original Message -----
From: "Sam Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 5:05 PM
Subject: Re: Copying Database
> 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
>
>
---------------------------------------------------------------------
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
