[wtracy]

I learned the hard way that MySQL creates a file descriptor for every database partition you create. Someone had a script that created a new partition every week...

[pbhjpbhj]

So after 5000 years you were running out?

[wtracy]

I forget the details, but practically speaking the database keeled over after some 200 or 500 files were open at the same time.