mysql - Why is percona xtrabackup so slow and big -

mysql - Why is percona xtrabackup so slow and big -

when phone call innobackupex no arguments, produces backup of databases. takes 3 minutes, , produces 8gb output. when run mysqldump --all-databases, takes 1 minutes, , produces 1.5gb output. since both of these outputs can used recreate same database, why xtrabackup much slower , larger?

is ibdata1 file 8gb? xtrabackup hot re-create of entire file. hot re-create process doesn't need lock tables (which allows database available during backup process). disadvantage unused space in file backed up.

mysql percona mysql-backup