The mailing list for listmasters using Sympa

[Youcef N Baouchi <address@concealed>]

Thanks Steve. I’m not sure that the db is the issue anymore. I manually queried the db and returned results almost immediately. I tracked the function, called “do_list()” that generates the lists of list in the file  wwsympa.fcgi and I think it’s pretty inefficient. I believe the problem is there, so that’s where I’m at now.

 

Youcef

 

From: address@concealed [mailto:address@concealed] On Behalf Of Steve Shipway
Sent: Monday, August 15, 2016 5:00 PM
To: address@concealed
Subject: Re: [sympa-users] Index of lists (sympa 6.2.16

 

On 16/08/16 08:21, Youcef N Baouchi (via sympa-users Mailing List) wrote:

 

Does anyone know in which file the lookup occurs for Index of Lists? The index of lists is very slow for us. It can take up to 40 seconds to display a list of 1700 lists. I’m assuming it’s a db call, but I can’t find it anywhere.

 

I'm a bit out of the loop on this, as I don't work with sympa these days, but in the past I had to improve performance with tens of thousands of lists; by examining mysql logs, I found performance massively increased by the following :
- I added a couple more indices to the lists table.  I can't remember which.  I just logged slow queries and then 'explained' them to find out what indices would help speed them up
- Tuned mysql to ensure the indices could be kept in memory and were cached which had a huge win
- Tweaked the sympa code with the riseup patch and similar to take advantage of the MySQL  RLIKE function for searches so that there are no sequential filters on the list of lists.  These may be in 6.2 now but I think that mysql-specific things may not have made the cut

Steve

--

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.