The mailing list for listmasters using Sympa

["Chris Andrews" <address@concealed>]

Thanks for the quick responses.  We are a massive Oracle shop.  In fact I am
the lucky guy running our Oracle Calendar server.  If I can keep this as a
simple server running MySQL locally that would be awesome.  No need to
involve the Oracle DBAs if I do not have to :) Based on the feedback it
looks like I should be more then OK.

A related question that I forgot and left off the first post, how are you
guys handling archiving.  I am considering moving the archives to their own
SAN partition so they do not eat all the space on my server.  We do not
archive currently with Majordomo, thank god, but I was thinking of setting a
global archive limit of 10 - 50 MB and then change the lists on request.  I
am hoping to limit message size to 1 MB, but for some reason people throw
around 10 MB emails, even though we have a pretty good web based storage
system here  (Xythos).

Do you guys set limits on archive size?

What kind of growth in archive space usage do you see?

---
 Chris Andrews
 Boston College
 Collaboration Team


-----Original Message-----
From: Dale Ghent [mailto:address@concealed] 
Sent: Wednesday, March 21, 2007 8:53 AM
To: Chris Andrews
Cc: address@concealed; Adam Bernstein
Subject: [sympa-users] Re: Re: Re: database choice/ server sizing

On Mar 21, 2007, at 1:43 AM, Adam Bernstein wrote:

>>> 230,000 subscriptions
>>> 130,000 unique email addresses
>>> 2300 lists
>>>
>>> So based on what I know about Sympa's database needs that is
>>> close to
>>> 400,000 records.  I have setup Sympa to use MySQL, but now I am
>
> That's basically like our installation (more like 1000 lists, but
> still 450K subscriptions), and we're running it on an aging P4
> 1.8GHz with 1GB RAM with MySQL on FreeBSD, and are seeing only
> minor limitations from the processor.  We're about to upgrade the
> machine, but not primarily for CPU reasons.  You should have no
> problem.

250k subscribers, 2200 lists here. We run Sympa on a Sun V20z (dual
1.8G Opterons) with 2GB of RAM. Works quite fine.

System statistics:

http://stats.umbc.edu/syscore/cacti/graph_view.php?
action=tree&tree_id=4&leaf_id=40

Note the CPU graphs.

/dale
--
Dale Ghent
UNIX Systems Specialist
UMBC - Office of Information Technology
ECS 201 - x51705

Attachment: smime.p7s
Description: S/MIME cryptographic signature