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.
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.