# Innobackupex or xtrabackup, problem : not running **URL:** \ **Category:** Percona XtraBackup\ **Created:** [April 3, 2013, 2:52am UTC](https://forums.percona.com/t/innobackupex-or-xtrabackup-problem-not-running/2359 "2013-04-03T02:52:39Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![KoHead](https://avatars.discourse-cdn.com/v4/letter/k/e36b37/32.png) [@KoHead](https://forums.percona.com/u/KoHead)\ **Post date:** [April 3, 2013, 2:52am UTC](https://forums.percona.com/t/innobackupex-or-xtrabackup-problem-not-running/2359/1 "2013-04-03T02:52:39Z")
Hello everynody, I have a problem with xtrabackup on my mysql server. When i running xtrabackup, This tool stops before to start the backup. I run innobackup by : innobackupex --no-lock --user=root --password=MyPassword /home/backup/full/ And i have in return : [root@Myserver script\_xtrabackup]# innobackupex --no-lock --user=root --password=MyPass /home/backup/full/InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Ireland Ltd 2009-2012. All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.130403 09:30:36 innobackupex: Starting mysql with options: --password=xxxxxxxx --user=‘root’ --unbuffered --130403 09:30:36 innobackupex: Connected to database with mysql child process (pid=20391)130403 09:30:42 innobackupex: Connection to database server closedIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex prints “completed OK!”.innobackupex: Using mysql Ver 14.14 Distrib 5.5.30, for Linux (x86\_64) using EditLine wrapperinnobackupex: Using mysql server version Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.innobackupex: Created backup directory /home/backup/full/2013-04-03\_09-30-42130403 09:30:42 innobackupex: Starting mysql with options: --password=xxxxxxxx --user=‘root’ --unbuffered --130403 09:30:42 innobackupex: Connected to database with mysql child process (pid=20457)130403 09:30:45 innobackupex: Connection to database server closed130403 09:30:45 innobackupex: Starting ibbackup with command: xtrabackup\_55 --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/home/backup/full/2013-04-03\_09-30-42 --tmpdir=/home/tmp\_mysqlinnobackupex: Waiting for ibbackup (pid=20472) to suspendinnobackupex: Suspend file '/home/backup/full/2013-04-03\_09-30-42/xtrabackup\_suspended’xtrabackup\_55 version 2.0.6 for Percona Server 5.5.16 Linux (x86\_64) (revision id: 521)xtrabackup: uses posix\_fadvise().xtrabackup: cd to /home/mysqlxtrabackup: Target instance is assumed as followings.xtrabackup: innodb\_data\_home\_dir = ./xtrabackup: innodb\_data\_file\_path = ibdata1:10M:autoextendxtrabackup: innodb\_log\_group\_home\_dir = ./xtrabackup: innodb\_log\_files\_in\_group = 2xtrabackup: innodb\_log\_file\_size = 268435456130403 9:30:45 InnoDB: Warning: allocated tablespace 237, old maximum was 9 xtrabackup stops for hours (7 or 8 hours) before of to begin the backup. I think it is because of will flush all tables with READ LOCK. But why with the –no-lock option, xtrabackup don’t move ? why xtrabackup lasts as long as ? Complementary information : ibdata size : 7,3G innodb option : # Innodb innodb\_file\_per\_table #innodb\_data\_file\_path = ibdata1:10M:autoextend:max:2000M innodb\_data\_file\_path = ibdata1:10M:autoextend innodb\_buffer\_pool\_size= 30000M innodb\_log\_buffer\_size=16M innodb\_log\_file\_size=256M Thank you ---
**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\ **Post date:** [April 9, 2013, 3:43am UTC](https://forums.percona.com/t/innobackupex-or-xtrabackup-problem-not-running/2359/2 "2013-04-09T03:43:34Z")
Hi, I guess, It’s not because of “Flush tables with read lock” as that read lock will be acquired at the end of the process when copying MyISAM tables and other files. It can be due to initial process (aka, boot process) of xtrabackup which is similar to InnoDB boot process when MySQL server starts. What xtrabackup does in this process is, it opens and reads every .ibd files. You have enabled innodb\_file\_per\_table so If you have lots of tables and slow I/O then might be booting step can take more time. In this case, you can try with --parallel option to increase parallel threads for taking backup. [http://www.percona.com/doc/percona-xtrabackup/innobackupex/i](http://www.percona.com/doc/percona-xtrabackup/innobackupex/i) nnobackupex\_option\_reference.html#cmdoption-innobackupex–pa rallel Please check I/O subsystems and try to use --parallel=4 with xtrabackup if it helps. ---
**Author:** ![KoHead](https://avatars.discourse-cdn.com/v4/letter/k/e36b37/32.png) [@KoHead](https://forums.percona.com/u/KoHead)\ **Post date:** [April 9, 2013, 8:55am UTC](https://forums.percona.com/t/innobackupex-or-xtrabackup-problem-not-running/2359/3 "2013-04-09T08:55:32Z")
Hey, Thanks for your response. So, i running innobackupx with parallel option and indeed, it’s faster. But we have decrease the number of .ibd files. may be that this has an effect. Thanks again