Too Many Open Files - MySql 8.0.26

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

What is the Xtrabackup version used?

Xtrabackup should work with default open files limit. Pxb 8.0.31 fixed Jira

We have not seen any such reports about open files limit to be increased.

Xtrabackup closes file after it finishes copying.

1 Like

Hi!

We are using this version:
percona-xtrabackup-80-8.0.25-17.1.el7.x86_64.

More info:
Oracle Linux 7.9

PXB 8.0.31 would work on a 8.0.25 mysql with skip version?

Pxb 8.0.31 is backwards compatible with 8.0.26. U may infact use latest 8.0.35 release

1 Like