Hi I’ve been testing XtraBackup 1.6.4-314 with MariaDB 5.2.10 for a single MyISAM database and the parallel option with 12 threads on Core i7 3930K 6C/12T based CentOS 6.2 64bit server was only 2 seconds faster than with single thread for innobackupex-1.5.1 ?
From the output, am I correct to assume parallel is only applicable to InnoDB tables and MyISAM table back up is still single threaded ?
18,935MB sized sbtest database
[CENTER]single thread[/CENTER]
/usr/bin/innobackupex-1.5.1 --databases=sbtest /backupInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2011. All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.120107 18:36:32 innobackupex-1.5.1: Starting mysql with options: --unbuffered --120107 18:36:32 innobackupex-1.5.1: Connected to database with mysql child process (pid=5950)120107 18:36:38 innobackupex-1.5.1: Connection to database server closedIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex-1.5.1 prints “completed OK!”.innobackupex-1.5.1: Using mysql Ver 14.16 Distrib 5.2.10-MariaDB, for unknown-linux-gnu (x86_64) using readline 5.1innobackupex-1.5.1: Using mysql server version This software comes with ABSOLUTELY NO WARRANTY. This is free software,innobackupex-1.5.1: Created backup directory /backup/2012-01-07_18-36-38120107 18:36:38 innobackupex-1.5.1: Starting mysql with options: --unbuffered --120107 18:36:38 innobackupex-1.5.1: Connected to database with mysql child process (pid=5974)120107 18:36:40 innobackupex-1.5.1: Connection to database server closed120107 18:36:40 innobackupex-1.5.1: Starting ibbackup with command: xtrabackup --backup --suspend-at-end --target-dir=/backup/2012-01-07_18-36-38innobackupex-1.5.1: Waiting for ibbackup (pid=5980) to suspendinnobackupex-1.5.1: Suspend file '/backup/2012-01-07_18-36-38/xtrabackup_suspended’xtrabackup version 1.6.4 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 314)xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlInnoDB: Warning: innodb_log_block_size has been changed from its default value. (###EXPERIMENTAL### operation)InnoDB: The log block size is set to 4096.xtrabackup: Target instance is assumed as followings.xtrabackup: innodb_data_home_dir = ./xtrabackup: innodb_data_file_path = ibdata1:2G:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 2xtrabackup: innodb_log_file_size = 536870912xtrabackup: use O_DIRECT>> log scanned up to (262181863)[01] Copying ./ibdata1 to /backup/2012-01-07_18-36-38/ibdata1>> log scanned up to (262181863)[01] …done>> log scanned up to (262181863)120107 18:36:52 innobackupex-1.5.1: Continuing after ibbackup has suspended120107 18:36:52 innobackupex-1.5.1: Starting mysql with options: --unbuffered --120107 18:36:52 innobackupex-1.5.1: Connected to database with mysql child process (pid=5994)120107 18:36:54 innobackupex-1.5.1: Starting to lock all tables…>> log scanned up to (262181863)>> log scanned up to (262181863)120107 18:37:04 innobackupex-1.5.1: All tables locked and flushed to disk120107 18:37: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 ininnobackupex-1.5.1: subdirectories of '/var/lib/mysql’innobackupex-1.5.1: Backing up files ‘/var/lib/mysql/sbtest/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (145 files)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)120107 18:38:21 innobackupex-1.5.1: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt filesinnobackupex-1.5.1: Resuming ibbackupxtrabackup: The latest check point (for incremental): ‘262181863’>> log scanned up to (262181863)xtrabackup: Stopping log copying thread.xtrabackup: Transaction log of lsn (262181863) to (262181863) was copied.120107 18:38:23 innobackupex-1.5.1: All tables unlocked120107 18:38:23 innobackupex-1.5.1: Connection to database server closedinnobackupex-1.5.1: Backup created in directory '/backup/2012-01-07_18-36-38’innobackupex-1.5.1: MySQL binlog position: filename ‘’, position 120107 18:38:23 innobackupex-1.5.1: completed OK!
vs
[CENTER]parallel=12[/CENTER]
/usr/bin/innobackupex-1.5.1 --parallel=12 --databases=sbtest /backupInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2011. All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.120107 18:48:42 innobackupex-1.5.1: Starting mysql with options: --unbuffered --120107 18:48:42 innobackupex-1.5.1: Connected to database with mysql child process (pid=6598)120107 18:48:48 innobackupex-1.5.1: Connection to database server closedIMPORTANT: Please check that the backup run completes successfully. At the end of a successful backup run innobackupex-1.5.1 prints “completed OK!”.innobackupex-1.5.1: Using mysql Ver 14.16 Distrib 5.2.10-MariaDB, for unknown-linux-gnu (x86_64) using readline 5.1innobackupex-1.5.1: Using mysql server version This software comes with ABSOLUTELY NO WARRANTY. This is free software,innobackupex-1.5.1: Created backup directory /backup/2012-01-07_18-48-48120107 18:48:48 innobackupex-1.5.1: Starting mysql with options: --unbuffered --120107 18:48:48 innobackupex-1.5.1: Connected to database with mysql child process (pid=6622)120107 18:48:50 innobackupex-1.5.1: Connection to database server closed120107 18:48:50 innobackupex-1.5.1: Starting ibbackup with command: xtrabackup --backup --suspend-at-end --target-dir=/backup/2012-01-07_18-48-48 --parallel=12innobackupex-1.5.1: Waiting for ibbackup (pid=6628) to suspendinnobackupex-1.5.1: Suspend file '/backup/2012-01-07_18-48-48/xtrabackup_suspended’xtrabackup version 1.6.4 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 314)xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlInnoDB: Warning: innodb_log_block_size has been changed from its default value. (###EXPERIMENTAL### operation)InnoDB: The log block size is set to 4096.xtrabackup: Target instance is assumed as followings.xtrabackup: innodb_data_home_dir = ./xtrabackup: innodb_data_file_path = ibdata1:2G:autoextendxtrabackup: innodb_log_group_home_dir = ./xtrabackup: innodb_log_files_in_group = 2xtrabackup: innodb_log_file_size = 536870912xtrabackup: use O_DIRECT>> log scanned up to (262181863)xtrabackup: Starting 12 threads for parallel data files transfer[03] Copying ./ibdata1 to /backup/2012-01-07_18-48-48/ibdata1>> log scanned up to (262181863)[03] …done>> log scanned up to (262181863)120107 18:49:02 innobackupex-1.5.1: Continuing after ibbackup has suspended120107 18:49:02 innobackupex-1.5.1: Starting mysql with options: --unbuffered --120107 18:49:02 innobackupex-1.5.1: Connected to database with mysql child process (pid=6653)120107 18:49:04 innobackupex-1.5.1: Starting to lock all tables…>> log scanned up to (262181863)>> log scanned up to (262181863)120107 18:49:14 innobackupex-1.5.1: All tables locked and flushed to disk120107 18:49:14 innobackupex-1.5.1: Starting to backup .frm, .MRG, .MYD, .MYI,innobackupex-1.5.1: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files ininnobackupex-1.5.1: subdirectories of '/var/lib/mysql’innobackupex-1.5.1: Backing up files ‘/var/lib/mysql/sbtest/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}’ (145 files)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)>> log scanned up to (262181863)120107 18:50:28 innobackupex-1.5.1: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt filesinnobackupex-1.5.1: Resuming ibbackupxtrabackup: The latest check point (for incremental): ‘262181863’>> log scanned up to (262181863)xtrabackup: Stopping log copying thread.xtrabackup: Transaction log of lsn (262181863) to (262181863) was copied.120107 18:50:30 innobackupex-1.5.1: All tables unlocked120107 18:50:30 innobackupex-1.5.1: Connection to database server closedinnobackupex-1.5.1: Backup created in directory '/backup/2012-01-07_18-48-48’innobackupex-1.5.1: MySQL binlog position: filename ‘’, position 120107 18:50:30 innobackupex-1.5.1: completed OK!