MySQL Forums
Forum List  »  Partitioning

Re: File descriptors
Posted by: Rick James
Date: June 03, 2009 10:34PM

You're in trouble.
PARTITION opens all the partitions before doing the pruning. (Oops!)
1M file descriptors could cause the OS and/or MySQL to have trouble.
30K tables, even without partitions, is a pretty big number.
Why are the tables PARTITIONed?

Options: ReplyQuote


Subject
Views
Written By
Posted
5253
June 02, 2009 12:00PM
Re: File descriptors
3151
June 03, 2009 10:34PM
2366
June 04, 2009 05:14AM
2768
June 04, 2009 08:23AM
2448
June 04, 2009 09:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.