环境描述及结果展示:
MySQL版本:5.1.43
xtrabackup版本:xtrabackup version2.0.8
主机内存:64G
CPUs:24
Innodb buffer pool:200M
数据量:9083M
数据文件总大小:9947M
结果对比:
| xtrabackup | xtrabackup压缩备份 | mysqldump | mysqldump压缩备份 |
CPU | 62.9% | 105% | 200% | 260% |
Disk IO | iostat tps 2550 nmon busy 41% | iostat tps 1038->138 nmon busy 6%->2% | iostat tps 450 nmon busy 5% | iostat tps 46->495 nmon busy 1-99% |
Memory | 0.0% (64M以内) | 0.00% (64M以内) | 0.05% (322M) | 0.05% (322M) |
Main processes | xtrabackup | xtrabackup&gzip&tar | mysqldump & mysqld | mysqldump& mysqld & gzip |
Backup file size | 9936M | 1137M | 6706M | 694M |
Time | 131s | 470s | 208s | 342s |
结论:xtrabackup占用的CPU与内存较少,消耗的IO相对较大,备份后的文件较大。