Re: File descriptors
Partitioning was implemented to address an older topic to this forum;
"MySQL Forums :: MyISAM :: Recover disk blocks."
http://forums.mysql.com/read.php?21,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.
Subject
Views
Written By
Posted
5425
June 02, 2009 12:00PM
3209
June 03, 2009 10:34PM
Re: File descriptors
2420
June 04, 2009 05:14AM
2835
June 04, 2009 08:23AM
2516
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.