Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-24 Thread Wietse Venema
Correction for the parameter name: debug-peer-list should be debug_peer_list. Wietse Venema: > deoren: > > On 8/24/2018 6:51 AM, Wietse Venema wrote: > > > deoren: > > >>> 'mail=0/1' means that Postfix rejected the MAIL FROM command (the > > >>> client sent 1 MAIL FROM command, and Postfix

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-24 Thread Wietse Venema
deoren: > On 8/24/2018 6:51 AM, Wietse Venema wrote: > > deoren: > >>> 'mail=0/1' means that Postfix rejected the MAIL FROM command (the > >>> client sent 1 MAIL FROM command, and Postfix accepted 0 MAIL FROM > >>> commands). > >> > >> Thank you for the response and for going into detail. > >> >

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-24 Thread deoren
On 8/24/2018 6:51 AM, Wietse Venema wrote: deoren: 'mail=0/1' means that Postfix rejected the MAIL FROM command (the client sent 1 MAIL FROM command, and Postfix accepted 0 MAIL FROM commands). Thank you for the response and for going into detail. I suspect I completely overlooked it, but do

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-24 Thread Wietse Venema
deoren: > > 'mail=0/1' means that Postfix rejected the MAIL FROM command (the > > client sent 1 MAIL FROM command, and Postfix accepted 0 MAIL FROM > > commands). > > Thank you for the response and for going into detail. > > I suspect I completely overlooked it, but do you recall offhand where

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread deoren
On 8/23/2018 9:28 PM, Phil Stracchino wrote: On 8/23/18 7:43 PM, deoren wrote: Here is a direct link to the config file with comments: https://github.com/deoren/postfix-examples/blob/master/database-server/mysql/my.cnf OK. Pretty much everything up to skip-name-resolve is compiled-in

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread deoren
On 8/23/2018 7:23 PM, Viktor Dukhovni wrote: On Aug 23, 2018, at 8:04 PM, Wietse Venema wrote: 'mail=0/1' means that Postfix rejected the MAIL FROM command (the client sent 1 MAIL FROM command, and Postfix accepted 0 MAIL FROM commands). You may want to examine the logs a little closer

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread deoren
On 8/23/2018 7:04 PM, Wietse Venema wrote: deoren: On 8/21/2018 6:25 PM, Wietse Venema wrote: Have you looked in Postfix LOGs? For example, if there is a delay from the start of the probe to the first Postfix logfile record, then that would indicate a delay with looking up the client

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread Phil Stracchino
On 8/23/18 7:43 PM, deoren wrote: > > Here is a direct link to the config file with comments: > https://github.com/deoren/postfix-examples/blob/master/database-server/mysql/my.cnf OK. Pretty much everything up to skip-name-resolve is compiled-in default values. (And so are most of the ones

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread Viktor Dukhovni
> On Aug 23, 2018, at 8:04 PM, Wietse Venema wrote: > > 'mail=0/1' means that Postfix rejected the MAIL FROM command (the > client sent 1 MAIL FROM command, and Postfix accepted 0 MAIL FROM > commands). > > You may want to examine the logs a little closer than looking for > 'connect'. What

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread Wietse Venema
deoren: > On 8/21/2018 6:25 PM, Wietse Venema wrote: > > > Have you looked in Postfix LOGs? For example, if there is a delay > > from the start of the probe to the first Postfix logfile record, > > then that would indicate a delay with looking up the client hostname, > > and then the address for

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread deoren
On 8/22/2018 10:29 AM, Noel Jones wrote: On 8/21/2018 3:17 PM, deoren wrote: Hi all, We've been using Postfix for years with good results, but in recent years have moved to a load-balanced HAProxy front-end with multiple backend relay nodes. I've consulted various sources during that time to

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread deoren
On 8/21/2018 7:48 PM, Phil Stracchino wrote: On 8/21/18 4:17 PM, deoren wrote: Hi all, We've been using Postfix for years with good results, but in recent years have moved to a load-balanced HAProxy front-end with multiple backend relay nodes. I've consulted various sources during that time to

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-23 Thread deoren
On 8/21/2018 6:25 PM, Wietse Venema wrote: Have you looked in Postfix LOGs? For example, if there is a delay from the start of the probe to the first Postfix logfile record, then that would indicate a delay with looking up the client hostname, and then the address for that hostname. Thank you

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-22 Thread Noel Jones
On 8/21/2018 3:17 PM, deoren wrote: > Hi all, > > We've been using Postfix for years with good results, but in recent > years have moved to a load-balanced HAProxy front-end with multiple > backend relay nodes. I've consulted various sources during that time > to perform the initial setup and

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-21 Thread Phil Stracchino
On 8/21/18 4:17 PM, deoren wrote: > Hi all, > > We've been using Postfix for years with good results, but in recent > years have moved to a load-balanced HAProxy front-end with multiple > backend relay nodes. I've consulted various sources during that time to > perform the initial setup and

Re: Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-21 Thread Wietse Venema
deoren: > Hi all, > > We've been using Postfix for years with good results, but in recent > years have moved to a load-balanced HAProxy front-end with multiple > backend relay nodes. I've consulted various sources during that time to > perform the initial setup and light tuning since then. >

Does anyone have any good tips/tricks/guides for tuning MySQL/MariaDB for use with Postfix?

2018-08-21 Thread deoren
Hi all, We've been using Postfix for years with good results, but in recent years have moved to a load-balanced HAProxy front-end with multiple backend relay nodes. I've consulted various sources during that time to perform the initial setup and light tuning since then. The health checks