Re: ot: MySQL config/tuning advice

2018-01-06 Thread Phil Stracchino
On 01/06/18 11:20, Postfix User wrote: > I have never used that application. I have been using "mysqlbackup" > for my MySQL databases. It > seems to work fine for me. mysqlbackup is a wrapper script around mysqldump. -- Phil Stracchino Babylo

Re: ot: MySQL config/tuning advice

2018-01-06 Thread Postfix User
On Fri, 5 Jan 2018 21:13:36 -0500, Phil Stracchino stated: >On 01/05/18 20:55, @lbutlr wrote: >> On 4 Jan 2018, at 14:40, Phil Stracchino ph...@caerllewys.net> wrote: >>> The principal shortcoming of mysqldump is that it is a benightedly stupid >>> tool that cannot walk and chew gum at the same

Re: ot: MySQL config/tuning advice

2018-01-05 Thread Phil Stracchino
On 01/05/18 20:55, @lbutlr wrote: > On 4 Jan 2018, at 14:40, Phil Stracchino ph...@caerllewys.net> wrote: >> The principal shortcoming of mysqldump is that it is a benightedly stupid >> tool that cannot walk and chew gum at the same time, or *correctly* dump >> both MyISAM and InnoDB tables in th

Re: ot: MySQL config/tuning advice

2018-01-05 Thread @lbutlr
On 4 Jan 2018, at 14:40, Phil Stracchino ph...@caerllewys.net> wrote: > The principal shortcoming of mysqldump is that it is a benightedly stupid > tool that cannot walk and chew gum at the same time, or *correctly* dump both > MyISAM and InnoDB tables in the same operation. OK, I'll bite. I'v

Re: ot: MySQL config/tuning advice

2018-01-05 Thread Alex JOST
Am 04.01.2018 um 13:58 schrieb Phil Stracchino: On 01/04/18 00:52, Voytek wrote: Phil, thanks, as it was, the my.cnf that this server uses turned to be in /etc/opt/rh/rh-mariadb102 I have to say, that location is pretty whacked. I wonder who came up with that? Who built the MariaDB package

Re: ot: MySQL config/tuning advice

2018-01-04 Thread Phil Stracchino
On 01/04/18 16:08, Voytek wrote: > On Thu, January 4, 2018 11:58 pm, Phil Stracchino wrote: >> On 01/04/18 00:52, Voytek wrote: > >> I have to say, that location is pretty whacked. I wonder who came up >> with that? Who built the MariaDB packages? > > Phil, > > and: systemctl status rh-mariadb

Re: ot: MySQL config/tuning advice

2018-01-04 Thread Voytek
On Thu, January 4, 2018 11:58 pm, Phil Stracchino wrote: > On 01/04/18 00:52, Voytek wrote: > I have to say, that location is pretty whacked. I wonder who came up > with that? Who built the MariaDB packages? Phil, and: systemctl status rh-mariadb102-mariadb that's what happens when you blindl

Re: ot: MySQL config/tuning advice

2018-01-04 Thread Phil Stracchino
On 01/04/18 00:52, Voytek wrote: > Phil, > > thanks, as it was, the my.cnf that this server uses turned to be in > /etc/opt/rh/rh-mariadb102 I have to say, that location is pretty whacked. I wonder who came up with that? Who built the MariaDB packages? -- Phil Stracchino Babylon Communi

Re: ot: MySQL config/tuning advice

2018-01-03 Thread Voytek
On Thu, January 4, 2018 2:57 pm, John Stoffel wrote: > So what is the advantage of using mysql here? Ease of adding/removing > users? John, thanks yes, ease of use, and, ability of having others able to add/edit if or as needed > In any case, just bumping up the mysql defaults to higher numbe

Re: ot: MySQL config/tuning advice

2018-01-03 Thread Voytek
On Thu, January 4, 2018 4:17 pm, Voytek wrote: > On Thu, January 4, 2018 3:17 pm, Bill Shirley wrote: Bill, big big thanks!!! I think it worked, i think the [Service] line ? made it work!! still checking, I'll post later V

Re: ot: MySQL config/tuning advice

2018-01-03 Thread Phil Stracchino
On 01/04/18 00:17, Voytek wrote: > On Thu, January 4, 2018 3:17 pm, Bill Shirley wrote: > >> Also, if you running with systemd as init, you need to override >> the limits in the service file: [0:root@elmo SPECS 130]$ cat >> /etc/systemd/system/mariadb.service >> .include /usr/lib/systemd/system/ma

Re: ot: MySQL config/tuning advice

2018-01-03 Thread Voytek
On Thu, January 4, 2018 3:17 pm, Bill Shirley wrote: > Also, if you running with systemd as init, you need to override > the limits in the service file: [0:root@elmo SPECS 130]$ cat > /etc/systemd/system/mariadb.service > .include /usr/lib/systemd/system/mariadb.service > > > [Service] > #LimitNOF

Re: ot: MySQL config/tuning advice

2018-01-03 Thread Bill Shirley
Make sure all .cnf files have permissions 644 to that all users (apache, postfix, etc) can read them: [0:root@elmo filter.d]$ ls -l /etc/my.cnf /etc/my.cnf.d/ -rw-r--r--. 1 root root  345 Feb 14  2016 /etc/my.cnf /etc/my.cnf.d/: total 24 -rw-r--r--. 1 root root 4128 Jul 27  2015 99-mystuff.cnf -r

Re: ot: MySQL config/tuning advice

2018-01-03 Thread John Stoffel
> "Voytek" == Voytek writes: Voytek> I have old server Postfix 2.x with MySQL, migrating to Postfix Voytek> 3.x on a new Centos 7 MariaDB 10.2, virtual user/domain, maybe Voytek> 20 domain/100 users, see abbreviated usage summary [1] So what is the advantage of using mysql here? Ease of ad

Re: ot: MySQL config/tuning advice

2018-01-03 Thread Phil Stracchino
On 01/03/18 20:39, Voytek wrote: > On Thu, January 4, 2018 12:00 pm, Voytek wrote: > >> on startup it says: Jan 04 07:48:24 mysqld-scl-helper[6908]: 2018-01-04 >> 7:48:24 >> 139791312545920 [Warning] Changed limits: max_open_files: 1024 >> max_connections: 151 table_cache: 431 >> Jan 04 07:48:24

Re: ot: MySQL config/tuning advice

2018-01-03 Thread Voytek
On Thu, January 4, 2018 12:00 pm, Voytek wrote: > on startup it says: Jan 04 07:48:24 mysqld-scl-helper[6908]: 2018-01-04 > 7:48:24 > 139791312545920 [Warning] Changed limits: max_open_files: 1024 > max_connections: 151 table_cache: 431 > Jan 04 07:48:24 systemd[1]: Started MariaDB 10.2 database

ot: MySQL config/tuning advice

2018-01-03 Thread Voytek
I have old server Postfix 2.x with MySQL, migrating to Postfix 3.x on a new Centos 7 MariaDB 10.2, virtual user/domain, maybe 20 domain/100 users, see abbreviated usage summary [1] new server has been up and running few weeks with just a handful users, just now, transferred another domain/25 users