MySQL Forums
Forum List  »  Partitioning

Re: File descriptors
Posted by: Chris Slominski
Date: June 04, 2009 05:14AM

Partitioning was implemented to address an older topic to this forum;
"MySQL Forums :: MyISAM :: Recover disk blocks.",229564,229564#msg-229564

The 30K tables have never been a problem (2.5 years of operation) without partitioning, although I know the number of files will now increase by a factor of roughly 25. I'm running on Red Hat Enterprise Linux and the JFS file system. Why do you suggest the number of file descriptors may be a problem? I believe the limit on Linux is huge and I run on dedicated systems, not having to worry about other applications.

Not much pruning happens as inserts dominate over selects in this system. I average about one or two selects per minute, as opposed to 3,000 inserts per second. Insert are always made to the most recent partition since they are range partitioned by date and inserts are real-time collected data.

Options: ReplyQuote

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