Opened 8 years ago

Last modified 7 years ago

#154 new defect

can't back up databases with lots of tables

Reported by: geofft Owned by:
Priority: major Milestone:
Component: sql Keywords: starter, c
Cc:

Description

Per a a comment on ticket #148, apparently having a large number of tables causes mysqldump to error out because it has too many open file handles. I disbelieve mysqldump has any good reason for the number of simultaneous open file handles to be linear in the number of tables, but even if so, we can doubtless bump the rlimit on the servers a good bit.

We should investigate what's going on here and make it possible to back up databases with lots of tables, preferably unlimited (or limited by some other constraint such as quota or a MySQL internal limit or directory size).

Change History (3)

comment:1 Changed 8 years ago by aseering

One more detail with regard to said comment: Table growth was O(#classes) as noted, but the constant factor was just over 40, and ESP runs a little under ~1,000 classes/year. As I understand, file handles are 16-bit? So, bumping the rlimit wouldn't have solved this particular problem for very long.

(Claroline is basically a really clean GUI on top of various other well-known open-source webapps; each new class gets its own install of each webapp.)

comment:2 Changed 7 years ago by ezyang

  • Priority changed from normal to major

comment:3 Changed 7 years ago by ezyang

  • Keywords starter c added
Note: See TracTickets for help on using tickets.