xelabs / tokudb-xtrabackup

Hot backup tool for InnoDB&TokuDB databases based on Percona Xtrabackup 2.4
https://github.com/XeLabs/tokudb-xtrabackup/wiki
GNU General Public License v2.0
41 stars 14 forks source link

--compress参数对tokudb表有作用吗? #2

Closed Fanduzi closed 6 years ago

Fanduzi commented 6 years ago

innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=root --password="x'x" --parallel=10 --compress --compress-threads=10 \ --stream=xbstream ./ > /data3/backup/full.xbstream

数据文件399G 备份完了居然389G, 完全没压缩一样

BohuTANG commented 6 years ago

'--compress' flag has almost no effect here, since TokuDB data files are already compressed, it just waste your CPU and slowing down the backup.

On Mon, 26 Mar 2018 at 16:42 Fan() notifications@github.com wrote:

innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=root --password="x'x" --parallel=10 --compress --compress-threads=10 --stream=xbstream ./ > /data3/backup/full.xbstream

数据文件399G 别分完了居然389G, 完全没压缩一样

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/xelabs/tokudb-xtrabackup/issues/2, or mute the thread https://github.com/notifications/unsubscribe-auth/AAKgrLpgdSdudzvXLgwks7MAnzBC8fj4ks5tiKoNgaJpZM4S6uhm .

-- BohuTANG

"The great artist is the simplifier."--- Vincent Van Gogh

Fanduzi commented 6 years ago

Thank you!