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...