cminfo not compatible with MariaDB 10.1?

Ah variables changed i think in MariaDB 10.1. Thanks for bug report !

on MariaDB 10.0.x

Code:

rpm -qa | grep -i MariaDB-server | head -n1 | cut -d '-' -f3
10.0.22

Code:

mysqladmin ext | awk '/Uptime|Uptime_since_flush_status/ { print $4 }' | head -n1
4271

Code:

mysqladmin ver | awk '/Uptime/ { print $2, $3, $4, $5, $6, $7, $8, $9 }'
1 hour 11 min 43 sec  

Code:

mysql -e "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() - variable_value) AS server_start FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name='Uptime';" | egrep -Ev '+--|server_start'
2015-12-01 16:07:08

 

let's see what MariaDB 10.1.9 shows for these commands

on MariaDB 10.1.9

Code:

rpm -qa | grep -i MariaDB-server | head -n1 | cut -d '-' -f3
10.1.9

why ? the full name without cut is

Code:

rpm -qa | grep -i MariaDB-server
MariaDB-server-10.1.9-1.el7.centos.x86_64

Code:

mysqladmin ext | awk '/Uptime|Uptime_since_flush_status/ { print $4 }' | head -n1
614

Code:

mysqladmin ver | awk '/Uptime/ { print $2, $3, $4, $5, $6, $7, $8, $9 }'
10 min 30 sec    

Code:

mysql -e "SELECT FROM_UNIXTIME(UNIX_TIMESTAMP() - variable_value) AS server_start FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name='Uptime';" | egrep -Ev '+--|server_start'
2015-12-01 17:23:14

all work fine.. so it's probably because you're using mysql remote database server ? There's no provisions in cminfo for remote mysql database servers right now, so it's normal to have what you see

 

strange then.. what do you get when you run those listed above commands manually on MariaDB 10.1 ?

 

Ah might be related to my code in cminfo and fact on CentOS7 only MariaDB service name changed from mysql to mariadb !

see code centminmod/cminfo.sh at master · centminmod/centminmod · GitHub

strangely MariaDB 10.1. has both service names in use

Code:

service mysql status
 ERROR! MySQL is running but PID file could not be found

Code:

service mariadb status
Redirecting to /bin/systemctl status  mariadb.service
mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: active (running) since Tue 2015-12-01 17:23:15 UTC; 24min ago
Main PID: 907 (mysqld)
   Status: "Taking your SQL requests now..."
   CGroup: /system.slice/mariadb.se

 

i just need to fix this line centminmod/cminfo.sh at master · centminmod/centminmod · GitHub so centos 7 uses mariadb service name instead of mysql heh

 

reported bug at [MDEV-9227] Both CentOS service names mysql and mariadb exist ? - JIRA

seems on CentOS 7

these 3 work

Code:

service mariadb status
systemctl status mysql
systemctl status mariadb

but this doesn't

Code:

service mysql status