MariaDB MariaDB 10.1 is stable GA

Looks like from Systemd - MariaDB Knowledge Base MariaDB 10.1.8 onwards on CentOS 7.x only, it uses systemd more extensively so mysqld_safe isn't used so /etc/my.cnf [mysqld_safe] section options are ignored.
i.e.

Code:

[mysqld_safe]
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
#nice = -5
open-files-limit = 8192

Which means max open file descriptor limits are no longer controlled below system wide limits via /etc/my.cnf. This is especially the case for MariaDB 5.5/10.0 uprgades to MariaDB 10.1 as 10.1 upgrade process creates a new custom config file at /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf which migrates open files limit from pre 10.1 my.cnf mysqld_safe section to this custom config file.

Code:

cat /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
# converted using /usr/bin/mariadb-service-convert
#

[Service]

LimitNOFILE=8192

which means if you try to raise open files limit in /etc/my.cnf above 8192 value via open-files-limit = 8192, it will not register and result in fixed 8192 value as set in /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf.

---

So I need to update Centmin Mod's MariaDB 10.1 upgrade routine in Centmin Mod 123.09beta01 to detect CentOS 7 and to remove this file /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf and setup my own at /etc/systemd/system/mariadb.service.d/mdb101.conf with the following starter settings

Code:

[Service]
OOMScoreAdjust=-600
LimitNOFILE=262144
LimitNPROC=16384
Nice=-5

before /etc/systemd/system/mariadb.service.d/mdb101.conf with /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf in place

Code:

cat /proc/`pidof mysqld`/limits
Limit                     Soft Limit           Hard Limit           Units
Max cpu time              unlimited            unlimited            seconds
Max file size             unlimited            unlimited            bytes
Max data size             unlimited            unlimited            bytes
Max stack size            8388608              unlimited            bytes
Max core file size        0                    unlimited            bytes
Max resident set          unlimited            unlimited            bytes
Max processes             7289                 7289                 processes
Max open files            8192                 8192                 files
Max locked memory         65536                65536                bytes
Max address space         unlimited            unlimited            bytes
Max file locks            unlimited            unlimited            locks
Max pending signals       7289                 7289                 signals
Max msgqueue size         819200               819200               bytes
Max nice priority         0                    0          
Max realtime priority     0                    0          
Max realtime timeout      unlimited            unlimited            us  

after /etc/systemd/system/mariadb.service.d/mdb101.conf with removal of /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf

Code:

cat /proc/`pidof mysqld`/limits
Limit                     Soft Limit           Hard Limit           Units
Max cpu time              unlimited            unlimited            seconds
Max file size             unlimited            unlimited            bytes
Max data size             unlimited            unlimited            bytes
Max stack size            8388608              unlimited            bytes
Max core file size        0                    unlimited            bytes
Max resident set          unlimited            unlimited            bytes
Max processes             16384                16384                processes
Max open files            262144               262144               files
Max locked memory         65536                65536                bytes
Max address space         unlimited            unlimited            bytes
Max file locks            unlimited            unlimited            locks
Max pending signals       7289                 7289                 signals
Max msgqueue size         819200               819200               bytes
Max nice priority         0                    0          
Max realtime priority     0                    0          
Max realtime timeout      unlimited            unlimited            us 

Code:

top - 15:51:56 up  1:15,  2 users,  load average: 0.00, 0.01, 0.05
Tasks: 128 total,   1 running, 127 sleeping,   0 stopped,   0 zombie
%Cpu(s):  0.1 us,  0.1 sy,  0.0 ni, 99.8 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem :  1884472 total,   312756 free,   354864 used,  1216852 buff/cache
KiB Swap:  1572860 total,  1572336 free,      524 used.  1195516 avail Mem

  PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND                                                                                                                                                                           
2138 nginx     10 -10  180424  29432   2844 S   0.3  1.6   0:06.28 nginx: worker process                                                                                                                                                             
2139 nginx     10 -10  180424  29444   2856 S   0.3  1.6   0:06.77 nginx: worker process                                                                                                                                                             
20034 mysql     15  -5  462220 142436   9448 S   0.3  7.6   0:04.65 /usr/sbin/mysqld 

Committed change for CentOS 7 only at update inc/mariadb_upgrade101.inc · centminmod/centminmod@d7afca6 · GitHub

CentOS 6 doesn't have this issue as Centmin Mod out of box raises system wide open file limits to 262144, so /etc/my.cnf is free to adjust open files limit in [mysqld_safe] section from default 8192 set out of box Centmin Mod installs all the way up to 262144.

 

yup for CentOS 7 only

 

oh remove + plus signs though

Code:

[Service]
OOMScoreAdjust=-600
LimitNOFILE=262144
LimitNPROC=16384
Nice=-5

 

Glad to hear @Matt Williams @negative

 

You can check your mysql error log which is listed along with all other log file locations as per How to troubleshoot Centmin Mod initial install issues (/var/log/mysqld.log) for clues.

 

check the /var/lib/mysql/yourhostname.err error log too

it's why i don't intend to touch MariaDB 10.1 until at least 10.1.13

 

that may occur if the /etc/my.cnf centmin mod set is wiped so the custom error log directory in /etc/my.cnf doesn't exist so start up uses error log at it's default location. But that should be /var/lib/mysql/yourhostname.err or something