>>>>> "Voytek" == Voytek <li...@sbt.net.au> 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 adding/removing users? I think the penatly is quite high actually and that flat files (hashed) will give you all the performance and ease of management that you need here. I went this route before when setting up my personal domain and it just didn't make sense and I dropped all the mysql stuff. If you need/want SQL access, sqlite3 seems to be a good comprosmise in terms of use. In any case, just bumping up the mysql defaults to higher numbers, using the mysltuner script, might be all you need to do. Google for the script. Voytek> new server has been up and running few weeks with just a Voytek> handful users, just now, transferred another domain/25 users Voytek> across to new server, and, within few hours started getting Voytek> mysql 'issues', it looks like I don't have enough mysql Voytek> resources How big a server did you get in terms of memory? Voytek> Jan 4 00:12:39 postfix/proxymap[28038]: warning: connect to mysql server Voytek> 127.0.0.1: Lost connection to MySQL server at 'reading initial Voytek> communication packet', system error: 104 Voytek> MariaDB is used for Postfix/Dovecot/Postfixadmin as well as Apache/PHP. Voytek> looking for suggestions, tips and advice how to determine 'optimal' mysql Voytek> and/or related settings Voytek> on startup it says: Voytek> Jan 04 07:48:24 mysqld-scl-helper[6908]: 2018-01-04 7:48:24 Voytek> 139791312545920 [Warning] Changed limits: max_open_files: 1024 Voytek> max_connections: 151 table_cache: 431 Voytek> Jan 04 07:48:24 systemd[1]: Started MariaDB 10.2 database server. Voytek> thanks, V Voytek> [1] Voytek> Grand Totals Voytek> ------------ Voytek> messages Voytek> 1596 received Voytek> 1977 delivered Voytek> 9 forwarded Voytek> 8 deferred (19 deferrals) Voytek> 2 bounced Voytek> 4621 rejected (69%) Voytek> 0 reject warnings Voytek> 0 held Voytek> 4 discarded (0%) Voytek> 312364k bytes received Voytek> 419827k bytes delivered Voytek> 862 senders Voytek> 611 sending hosts/domains Voytek> 211 recipients Voytek> 81 recipient hosts/domains Voytek> Per-Day Traffic Summary Voytek> ----------------------- Voytek> date received delivered deferred bounced rejected Voytek> -------------------------------------------------------------------- Voytek> Jan 1 2018 215 211 8 0 472 Voytek> Jan 2 2018 201 221 1 0 2649 Voytek> Jan 3 2018 908 1251 10 0 1159 Voytek> Jan 4 2018 272 294 0 2 345