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 systemd[1]: Started MariaDB 10.2 database server.
> 
> tried editing /etc/my.cnf with, BUT, I don't think my MariaDB is reading
> /etc/my.cnf, do I need my.cnf somewhere in /var/run/rh-mariadb102-mariadb/ ??

MariaDB does indeed read /etc/my.cnf, and should also read
/etc/my.cnf.d/*.cnf.  Make sure that nothing in /etc/my.cnf.d/ is
overriding what you changed.  Also, remember that changes in the config
files will not take effect until you restart mysqld.  But many MySQL
configuration variables are dynamic and can be applied from the
MySQL/MariaDB command-line shell without restarting.


> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> 
> max_connections = 250
> open_files_limit = 10240
> 
> [mysqld_safe]
> log-error=/var/log/mariadb/mariadb.log
> pid-file=/var/run/rh-mariadb102-mariadb/mariadb.pid
> 
> open_files_limit = 10240




-- 
  Phil Stracchino
  Babylon Communications
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958

Reply via email to