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
5278
June 02, 2009 12:00PM
Re: File descriptors
3157
June 03, 2009 10:34PM
2368
June 04, 2009 05:14AM
2775
June 04, 2009 08:23AM
2457
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.