Subject: The mailing list for listmasters using Sympa
List archive
RE: [sympa-users] Mysql select returns max 300 list members
- From: "McLaren, Terrence M" <address@concealed>
- To: "address@concealed" <address@concealed>
- Cc: "address@concealed" <address@concealed>, "Gerard Ranke" <address@concealed>
- Subject: RE: [sympa-users] Mysql select returns max 300 list members
- Date: Tue, 18 Jul 2017 13:32:11 +0000
PS> if the pdf gets stripped, you can find it under the listmaster references
at: https://wiki.illinois.edu/wiki/display/maillists/List+Owner+Docs
-Terry
-----Original Message-----
From: McLaren, Terrence M
Sent: Tuesday, July 18, 2017 8:28 AM
To: address@concealed
Cc: 'address@concealed' <address@concealed>; 'Gerard
Ranke' <address@concealed>
Subject: RE: [sympa-users] Mysql select returns max 300 list members
A couple years ago I needed to tune our mySQL for Sympa. With input and
feedback from Steve Shipway I created this doc that outlines the relevant
my.cnf parameters.
Hope it helps,
-Terry McLaren
University of Illinois
-----Original Message-----
From: address@concealed
[mailto:address@concealed] On Behalf Of Gerard Ranke
Sent: Tuesday, July 18, 2017 7:51 AM
To: address@concealed
Subject: Re: [sympa-users] Mysql select returns max 300 list members
Hello Harald,
On 17-07-17 17:20, address@concealed wrote:
> Hello,
> I'd like to get members of a sympa list with a mysql data source.
> It returns max 300 list members, but it should be more.
> A Select with mysql-cli at the shell prompt returns the correct count.
> Where can I configure the appropriate parameter?
> Sympa version is 6.2.16.
>
Check your logfiles. If you see 'ER_NET_PACKET_TOO_LARGE' errors, then
try increasing max_allowed_packet in your my.cnf file.
Best regards,
gerard
-
[sympa-users] Mysql select returns max 300 list members,
harald.wanke, 08/16/2022
-
Re: [sympa-users] Mysql select returns max 300 list members,
Gerard Ranke, 07/18/2017
- RE: [sympa-users] Mysql select returns max 300 list members, McLaren, Terrence M, 07/18/2017
-
RE: [sympa-users] Mysql select returns max 300 list members,
McLaren, Terrence M, 07/18/2017
- Re: [sympa-users] Mysql select returns max 300 list members, harald.wanke, 08/16/2022
-
Re: [sympa-users] Mysql select returns max 300 list members,
Gerard Ranke, 07/18/2017
Archive powered by MHonArc 2.6.19+.