The mailing list for listmasters using Sympa

[Steve Shipway <address@concealed>]

Under 6.1, in order to improve performance I did the following things.  We had tens of thousands of lists defined, which caused huge performance problems, since much of the Sympa code then would simply retrieve ALL the lists and selection-sort them in memory.

- Added the Riseup patch (this is mostly incorporated in 6.2 already) which  uses SQL 'where' clauses rather than retrieving all lists  and selecting in memory;
- Did a slow query analysis on the database, and added a new index as a result (sorry, cant remember what it was);
- Heavily tuned the mysql instance, so that there was a lot of memory assigned to index caching so that most SQL queries were in-memory;
- Edited the search code to use RLIKE for matching, which is not normally done by Sympa as it is a mysql-specific function

Steve

On 18/11/16 01:31, Gonzalo Palacios Goicolea (via sympa-users Mailing List) wrote:

Hi All,

We have just mooved to sympa 6.2.16 and the web interface is too slow on certain views. I've fixed list search using "db_list_cache on" at sympa.conf, but when listing the hole index of lists it goes too slow. Is there any trick to improve it?

If you need further info (config files, etc) please let me know

Thanks and best regards

Gonzalo

--

Steve Shipway | Senior Email Systems Administrator
Phone: +64 9 302 0515 Fax: +64 9 302 0518
Freephone: 0800 SMX SMX (769 769)
SMX Limited: Level 15, 19 Victoria Street West, Auckland, New Zealand
Web: http://smxemail.com

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