Comment 2 for bug 713267

Revision history for this message
Peter Zaitsev (pz-percona) wrote : Re: Xtrabackup fails if there are many open files allowed

Alexey,

I see the bug as follows - as Xtrabackup and MySQL Server operate using same my.cnf should work
in both configuration

if I have innodb_open_files_limit=30000 (or similar high number) in my.cnf and open_files_limit=50000

when we'll have as follows

- MySQL Server works fine as it increases number of files allowed based on open_files_limit setting

- Xtrabackup does not work with large number of tables as it does not respect open_files_limit option as I understand.

The solutions could be either:

- support open_files_limit as MySQL server does

- more simple one, do not allow innodb_open_files_limit to be set to more than 512 or so (it should be enough)

- close the table once it is copied closing file descriptor indpendent of open_files_limit setting.