I am getting some problem while taking backup of mysql database. My database size is near about 20 GB. While taking backup the Opened_files and Open_files limit get increased suddendly.
There is any other method so that the limit will not be cross.
I am taking the backup with command.
mysqldump --all-databases --lock-all-tables > /mnt/db.sql
According to me , while taking backup nobody access my DB then how it can be possible that the Open_files limit gets increase. It means while mysqldump runs it opens the files also.
Kindly help me out of the situation.