Can you help me with my problem.
I use this command line to backup my 500Gb database (INNODB).
innobackupex --user=$BDD_LOGIN --password=$BDD_PASSWORD --compress $LATEST_DIR --compress-threads=4 --parallel=2 --no-lock
My problem is everyday after each backup I noticed an increase of 5Gb on my databasesize. Can you explain why?
I did not have this problem with regular mysqldump.
I assumed it may have something to do with fragmentation because I did not start my database with innodb_file_per_table options but I am not sure.