The mailing list for listmasters using Sympa

[Dan Pritts <address@concealed>]

Not sure why it's so slow for you.  I have 666 lists (oh my goodness!) and it takes just a couple seconds. 

IIRC for each list it has to read & parse the list configuration (the entry into list_data you're seeing).  There's a config.bin file in each list's directory.  This is a cached perl data structure of the list config.  If that's missing or out of date, sympa has to read & parse the text config. 

try running sympa.pl --reload_list_config to regenerate them all, maybe that will help. 

Gordon Chung

February 8, 2012 6:42 AM

Hi,

I have a Sunfire X4150 running Solaris 10 5/08 with Sympa-6.0, mysql-5.1.4 and httpd-2.0.63 installed.

Currently there are 921 lists and when I click on "List of lists" it takes on average about 27 seconds for the lists to come up on the web page.

I've had a quick look at what's happening in the background and it seems to be doing about 7 mysql queries on each list and at the same time it goes into each directory under /home/sympa/list_data to do some locking and unlocking.

I have just over 2000 majordomo lists to migrate over to sympa and I'm concerned that the more lists I add, the longer it will take to run "List of lists" etc. Does anyone have any suggestions on what tweaks I can make to make things run faster? Maybe I could add more indexes to the mysql table(s) or put /home/sympa/list_data on a tmpfs file system or could be a step I missed whilst building sympa.

Regards
Gordon

Gordon Chung
Unix Systems Support
IS Infrastructure
University of Edinburgh
Tel: 0131 650 5005
E-Mail: address@concealed

--
Dan Pritts, Sr. Systems Engineer
Internet2
office: +1-734-352-4953 | mobile: +1-734-834-7224