Does it stop once it hits the 4GB limit or is it a performance hit? Did I miss the new more accurate numbers?
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Michael Mraka Sent: Wednesday, April 13, 2011 12:44 AM To: [email protected] Subject: Re: [Spacewalk-list] Database user data [email protected] wrote: % On Tue, 12 Apr 2011, Michael Mraka wrote: % >William S. wrote: % >% % >% On average, do folks exceed the 4GB limitation with Oracle Xe? I'm trying to gauge on what sort of real data is stored in the DB, and how quickly I would run out of space. % > % >Some time ago I did estimates for Spacewalk 1.1 and came to formula % >* 250 KiB per client system, % >* 500 KiB per channel + 230 KiB per package in channel (i.e. 1.1GiB for channel % >with 5000 packages). % > % >It might be slightly lower number nowadays because we optimized % >changelog data storage which was quite hoggish :). % % I found the following in the Satellite 5.4 install docs: % % A single 6 GB tablespace is recommended as more than sufficient for % most installations. % * 192 KB per client system % * 64 MB per channel % % For instance, an RHN Satellite containing 10 channels serving 10,000 % systems would require 1.92 GB for its clients and 640 MB for its % channels. % % Database storage needs may grow rapidly, depending upon the variance % of the following factors: % * The number of public Red Hat packages imported (typical: 5000) % * The number of private packages to be managed (typical: 500) % * The number of systems to be managed (typical: 1000) % * The number of packages installed on the average system (typical: 500) Yes, these were old estimates which are no more accurate so I went ahead and created new, more appropriate, one. Regards, -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
