The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi Tom,

Le 25/09/2015 00:14, Fillmore, Tom a écrit :

Hi, all -

I am at present running a server with about 50 lists and 10,000 users.  Until I got to about 30 lists the web interface loaded quickly, but it has slowed down to a crawl as more lists have been added.  Now its takes no less than 20 seconds to reply, and ultimately causes 500 errors about one-half the time.  During that time CPU usage always goes over 95%. 

I am using Apache2, fcgid and have the value for that set to '1' in sympa.conf.  I've reviewed my Apache configs and they seem to be OK.

Machine specs:  Dual core mac mini, Debian 8.1, MySQL, 6GB RAM.  It's on a virtualbox VM, which some might say is the problem, but in the past I've run on VirtualBox vm's with the same basic configuration and triple the number of lists, users and traffic.
You should not have any trouble.
I'm running a server with 8 GB, 8 CPU cores (but mainly one is actually used) on an old RHEL5. It is enough for 2,400 lists, 16 virtual hosts, 225,000 users and 360,000 subscriptions. It's on a VMware VM.

Based on what I've read online in posts + the docs it seems that the problem lies in one or more of these areas:
1) The new web interface is massively slower
I don't think so. Everything funky in the web interface is actually run in _javascript_, thus impacting the web client only. So it has no impact on cpu / memory usage on the server.
2) There is something wrong with my Apache configs
It's a possibility. Could you show us the part regarding fcgi?
3) There is a problem with the cgi code that generates the web interface
Also a possibility. But I should investigate what'w wrong and why I can't reproduce it.
4) fcgid is a dog, speed-wise
:-)
I never noticed it before.

Out of these three items I really can only control 2 & 4

I'm open to all ideas, but can a few folks send me their Apache config files that work?  Please be sure to indicate the location where they are installed (eg /etc/apache2/... , /home/sympa/..., etc)
OK. Here is what I have:

in /etc/httpd/conf/httpd.conf

## FastCGI
LoadModule fcgid_module modules/mod_fcgid.so

Alias /static-sympa /home/sympa/static_content

<IfModule mod_fcgid.c>
    IPCCommTimeout 120
    MaxProcessCount 30
    SocketPath /var/run/fcgid/sock
  </IfModule>

ScriptAlias /sympa /home/sympa/bin/wwsympa-wrapper.fcgi


And we have separate files for each virtual host:

/etc/httpd/conf.d/domain.tld:80

<VirtualHost <IP>:80>

RedirectMatch (/wws.*)$ https://domain.tld$1
Alias /static-sympa/css/domain.tld /home/sympa/static_content/css/domain.tld

## Redirecting all towards HTTPS
RedirectMatch ^(.*)$ https://domain.tld$1

DocumentRoot "/var/www/domain.tld"
ServerName domain.tld:80
ServerAdmin email@ddress

CustomLog logs/domain.tld/access_log combined
ErrorLog logs/domain.tld/error_log
CustomLog logs/access_log combined-with-vhost

RedirectMatch ^/$ http://domain.tld/sympa

</VirtualHost>                                 

/etc/httpd/conf.d/domain.tld:443

<VirtualHost <IP>:443>
DocumentRoot "/var/www/secure"
ServerName domain.tld:443
ServerAdmin email@ddress

LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-agent}i\" **%T/%D**" combined_timed

CustomLog logs/domain.tld/access_log combined_timed
ErrorLog logs/domain.tld/error_log
CustomLog logs/access_log combined-with-vhost

<Location /sympa>
   SSLOptions +StdEnvVars
</Location>

Alias /static-sympa/css/domain.tld /home/sympa/static_content/css/domain.tld

RedirectMatch /wws/(.*) https://domain.tld/sympa/$1
RedirectMatch ^/$ https://domain.tld/sympa
Redirect /wws https://domain.tld/sympa

SSLEngine on

SSLCertificateFile /path/to/cert
SSLCertificateKeyFile /path/to/key
SSLCertificateChainFile /path/to/chain
<Directory "/var/www/cgi-bin">
    SSLOptions +StdEnvVars
</Directory>

</VirtualHost>                                 


Hope this helps.

Regards,

David

Other than this problem everything is working just fine.

Thanks!

Tom Fillmore

--
A bug in Sympa? Quick! To the bug tracker!

David Verdin Études et projets applicatifs
Tél : +33 2 23 23 69 71 Fax : +33 2 23 23 71 21   www.renater.fr	RENATER 263 Avenue du Gal Leclerc 35042 Rennes Cedex

Attachment: smime.p7s
Description: Signature cryptographique S/MIME