The mailing list for listmasters using Sympa

[Steve Shipway <address@concealed>]

We plan to upgrade our Sympa version from 6.1.20 to 6.2.44. New Sympa version installed on Centos 7 server and there is no low memory or IO problem with our server.. When opening list index sympa web interface works very slow very slow in our case. It was same in old version. We have about 800 Sympa list.  How can we increase load speed of web interface?

This is almost certainly due to a missing index in your database causing the sort to be done at query time.  If you can check to see which queries are running the slowest (how to do this depends on your database) then you should be able to identify which index/indices would improve the performance.

Back when I managed a 6.1 system of comparable size, I added an index on the list name, tuned mysql to allocate more memory to in-memory indices, and also modified the code slightly to make it use RLIKE rather than selection when searching for lists (this is mysql-specific and the code then did not use it)

Steve

--
Steve Shipway | Senior Email Administrator
Mobile: +64 21 753 189 Freephone: 0800 SMX SMX (769 769)
SMX Limited: Level 10, 19 Victoria Street West, Auckland, New Zealand
Web: http://smxemail.com

This email has been filtered by SMX. For more information visit smxemail.com.

This email has been filtered by SMX. For more information visit smxemail.com