Hi Everyone!
I have a database with over 2M files, tried to backup with xtrabackup, and even using the parameter close-files, i have the error of too many files, my open_file_limits is set to 300k and i checked in realtime the process of xtrabackup, that it reachs this number and fails.
Xtrabackup will always try to open all files of the database at same time? So if i wish to backup that Mysql, i should use open_file_limits beyond 2M or there is some other parameter that can help?
You guys have been through something like it? I do not want to increase even more the open files because i’m affraid that the server could freeze, being a important production database is quite risk