Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Message from discussion innobackupex is stuck on copying .frm, .MRG, .MYD, .MYI etc.
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Jervin R  
View profile  
 More options Jul 20 2011, 10:11 pm
From: Jervin R <jervin.r...@percona.com>
Date: Wed, 20 Jul 2011 19:11:28 -0700 (PDT)
Local: Wed, Jul 20 2011 10:11 pm
Subject: Re: innobackupex is stuck on copying .frm, .MRG, .MYD, .MYI etc.
Bar,

How big is the main tablespace? (ibdata*) Is the destination server
not getting filled during the backup?

How about using SSH instead of netcat i.e.

innobackupex --slave-info --stream=tar ./ | ssh user@backuphost -e
"(cd /var/backups/mysql && tar xivf -)"

On Jul 21, 4:04 am, Bar Ziony <bar...@gmail.com> wrote:

> Hi,

> I'm using MySQL server 5.1 with the newest xtrabackup debian package
> from Percona's repo.

> I'm trying to backup to a remote server by using this command:
> innobackupex-1.5.1 --password=mypass --stream=tar /tmp/mysql_backup/ --
> slave-info | nc mysql-02 9999

> And on the remote destination:
> nc -l -p 9999 | tar xfi - -C /var/backups/mysql

> I have a InnoDB big db (40GB), and a 200MB MyISAM db.

> At the first couple of minutes I get a lot of ">> log scanned up to
> (86835313840)" lines, and I can see the .ibd files created and getting
> larger on the destination. about 10MBps...
> After a couple of minutes, innobackupex locks all the tables and tries
> to copy FRM, MYD, MID files:

> 110720 19:48:47  innobackupex-1.5.1: Starting mysql with options:  --
> password='mypass' --unbuffered --
> 110720 19:48:47  innobackupex-1.5.1: Connected to database with mysql
> child process (pid=6165)>> log scanned up to (86835996968)

> 110720 19:48:51  innobackupex-1.5.1: Starting to lock all tables...>> log scanned up to (86836058050)
> >> log scanned up to (86836099692)
> >> log scanned up to (86836199676)

> 110720 19:49:04  innobackupex-1.5.1: All tables locked and flushed to
> disk
> 110720 19:49:04  innobackupex-1.5.1: Starting to
> backup .frm, .MRG, .MYD, .MYI,
> innobackupex-1.5.1: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files
> in
> innobackupex-1.5.1: subdirectories of '/var/lib/mysql'
> innobackupex-1.5.1: Backing up files '/var/lib/mysql/openx/*.
> {frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (172 files)

> but nothing happens! no FRM file is being copied, it's like it's
> stuck... but the .ibd files keep growing (a big one, 26GB is getting
> filled), and more and more "log scanned up to..." lines are shown.
> In all that time, the entire server is with a read lock, and my app is
> completely down with this long read lock.

> I can't backup to a local location because I don't have enough space
> on the local host.

> Appreciate the help,
> Thanks,
> Bar.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.