Add an option to disable opening all tablespaces on backup start
Bug #1222062 reported by
Alexey Kopytov
This bug affects 6 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Sergei Glushchenko | ||
| 2.0 |
Won't Fix
|
High
|
Unassigned | ||
| 2.1 |
Fix Released
|
High
|
Sergei Glushchenko | ||
| 2.2 |
Fix Released
|
High
|
Sergei Glushchenko | ||
Bug Description
As the discussion in #1183322 has shown, the fix for bug #1079700 introduces a problem for users with huge numbers of InnoDB tablespaces, and the workaround of raising the open files limits doesn't work in all cases due to a limitation in the Linux kernel.
So the only possible solution for that problem is to introduce another option to innobackupex/
Related branches
lp://staging/~sergei.glushchenko/percona-xtrabackup/2.1-xb-bug1222062
- Alexey Kopytov (community): Approve
-
Diff: 631 lines (+109/-41)13 files modifieddoc/source/innobackupex/innobackupex_option_reference.rst (+4/-0)
doc/source/xtrabackup_bin/xbk_option_reference.rst (+4/-0)
innobackupex.pl (+11/-1)
patches/innodb51.patch (+10/-8)
patches/innodb55.patch (+9/-7)
patches/innodb56.patch (+7/-5)
patches/xtradb51.patch (+9/-7)
patches/xtradb55.patch (+10/-8)
src/fil_cur.cc (+1/-1)
src/xtrabackup.cc (+14/-1)
test/inc/common.sh (+4/-1)
test/run.sh (+15/-2)
test/t/bug1222062.sh (+11/-0)
Revision history for this message
| Jan Ingvoldstad (jan-launchpad-xud) wrote | #1 |
| tags: | added: i44337 |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
To post a comment you must log in.
Although opening millions of files is just BAD BAD BAD, Linux doesn't really prevent you.
If you want to shoot that foot and permit 10 million open file descriptors, the following commands run as root may "help" you.
nfiles=10000000
sysctl fs.nr_open=$nfiles
ulimit -n $nfiles