Developers of Sympa

[Petr Prazak <address@concealed>]

Hello,

I have filled a list with some 320 thousand subscribers (converting
from Majordomo).

The conversion was rather quick.

$time /home/sympa/bin/load_subscribers.pl thelist
####thelist####
324650
134.27user 23.36system 7:02.23elapsed 37%CPU (0avgtext+0avgdata 0maxresident)k
0inputs+0outputs (422major+408minor)pagefaults 0swaps

But:

I when I log to the WWSympa (as the listmaster), and want to see a
list of lists, the page timeouts and the load of the machine goes to "2.66, 
3.83, 2.69"

Most of the time is spent in wwsympa, from ps output:

USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME COMMAND
sympa     4132 91.2 30.4 159704 157484 ?     R    11:48   3:10 perl -U 
/home/sympa/bin/wwsympa.fcgi

There must be inherited problem with database queries, because before
I had only about 500 items in the tables, now there is about 325 thousand
records!

I'm using MySQL 3.23.32-1.7, and I've done resorting of indexes with
the myisamchk, as suggested.

Please advice what should I do.

I was looking forward to Sympa, now I'm depressed :(


Best regards,
  Petr Prazak