The mailing list for listmasters using Sympa

["McLaren, Terry" <address@concealed>]

Greetings all - Attached is the pdf for the sympa-mysql optimizations we 
implemented on a Sympa 6.1 server running MySQL 5.x.   This old server hosted 
 +20 virtual servers (aka robots), and thousands of lists.   When I migrated 
to Sympa 6.2.x I also upgraded to the latest version of MariaDB (v10.5.x) .  
This new server is running just fine without the SQL optimizations and has a 
similar robot/list load.  

Hope this helps,

Terry McLaren
PS> Our doc locations have changed with the upgrade:
Main User Guide:   
https://wiki.illinois.edu/wiki/display/Sympa62/Campus+Mailing+Lists+Users+Guide
The my.cnf PDF file:   
https://wiki.illinois.edu/wiki/display/Sympa62/List+Owner+Docs?preview=%2F765773488%2F765773489%2F.my.cnf-MySQL+config+optimized+for+Sympa.pdf
 

-----Original Message-----
From: address@concealed <address@concealed> On Behalf Of 
Matt Taggart
Sent: Wednesday, November 30, 2022 5:05 PM
To: address@concealed
Subject: Re: [en@sympa] Adding subscribers via file inclusion taking a very 
long time

On 11/30/22 14:32, Phil Stracchino wrote:
> On 11/30/22 16:51, Ayhan Turgut (via en Mailing List) wrote:
>>   Our my.conf file doesn’t have any customizations and am wondering 
>> if this is causing the slow down.
> 
> If I read this right, what you're saying is, you have never tuned 
> MySQL and it is running on pure unmodified out-of-the-box configuration.

[snip]

In addition to those suggestions, here's an old guide by Terry McLaren that 
might help

https://urldefense.com/v3/__https://lists.sympa.community/arc/en/2017-07/msg00005.html__;!!DZ3fjg!9VNNFuX1i38ywX7-HVB8Ga6gEaVfyV_4l1yAss-K4li1-4xIzrB-IzIPZgkWCJb3KATozrEjVycU-Vo$
 

It is from 2017, so some things might have changed. Terry still posts to the 
list regularly, maybe there's a newer version somewhere?

--
Matt Taggart
address@concealed

Attachment: my.cnf-MySQL config optimized for Sympa.pdf
Description: my.cnf-MySQL config optimized for Sympa.pdf