mysqlmymonlite.sh server stats gathering tool for cPanel Server

Binay Kumar

Registered
Aug 25, 2016
3
0
1
India
cPanel Access Level
Root Administrator
I tried to do this. I created a folder tool in root and I uploaded both files from centos_whm to tool. After that I run this command
chmod +x mysqlmymonlite.sh and after this
./mysqlmymonlite.sh run 2>/dev/null > mysqlmymonlite_stats.txt and finally run this command
./mysqlmymonlite.sh mysqltuner

It generates 0 byte file.

When I run only this command -
./mysqlmymonlite.sh

It gives below error message
awk: cmd. line:1: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
awk: cmd. line:1: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
awk: cmd. line:1: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)

Is there is something goes wrong. If it how can I fix this.

Thanks and waiting for your reply.
Any one who help me about the above issue.
 

Anthony Parsons

Active Member
Aug 4, 2016
26
4
8
Australia
cPanel Access Level
Root Administrator
What do these mean as recommendations, in relation to how my.cnf should be structured?
Code:
General recommendations:
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (10000) variable
    should be greater than table_open_cache ( 256)
Variables to adjust:
    query_cache_size (> 10M)
    table_open_cache (> 256)
    innodb_buffer_pool_size (>= 3G) if possible.
    innodb_buffer_pool_instances (=1)
 
Last edited by a moderator:

Inigo Montoya

Registered
May 16, 2018
3
0
1
USA
cPanel Access Level
Root Administrator
I have been trying to install mysqlmymonlite.sh on my server. When I get to the point of running the tool I get the following result:
Code:
[[email protected] tool]# cp centos/* /root/tool
cp: overwrite ‘/root/tool/config.ini’? y
cp: overwrite ‘/root/tool/mysqlmymonlite.sh’? y
[[email protected] tool]# ./mysqlmymonlite.sh
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
The server does have the Engintron nginx installed, but there is nothing in the location specified. After those error messages the script just hangs, and requires a ctrl-c to break out. I have tried both the centos and centos_whm versions of the script with the same result. Is this script incompatible with Engintron nginx?
 

ronaldst

Well-Known Member
Feb 22, 2016
85
16
8
Norway
cPanel Access Level
Root Administrator
I'm getting this error when running ./mysqlmymonlite for the first time.

Code:
The content of '/home/.cpan/build/DBD-mysql-4.047-4/META.json' is not a HASH reference. Cannot use it.
Configuring C/CA/CAPTTOFU/DBD-mysql-4.047.tar.gz with Makefile.PL
Can't locate Devel/CheckLib.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 12.
BEGIN failed--compilation aborted at Makefile.PL line 12.
No 'Makefile' created  CAPTTOFU/DBD-mysql-4.047.tar.gz
  /usr/bin/perl Makefile.PL OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again
Re-running the script gives the same error.

This is on a fresh installed server. What can I do to solve this?
 

eva2000

Well-Known Member
Aug 14, 2001
338
15
318
Brisbane, Australia
vbtechsupport.com
cPanel Access Level
Root Administrator
Twitter
I have been trying to install mysqlmymonlite.sh on my server. When I get to the point of running the tool I get the following result:
Code:
[[email protected] tool]# cp centos/* /root/tool
cp: overwrite ‘/root/tool/config.ini’? y
cp: overwrite ‘/root/tool/mysqlmymonlite.sh’? y
[[email protected] tool]# ./mysqlmymonlite.sh
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
awk: fatal: cannot open file `/etc/init.d/nginx' for reading (No such file or directory)
The server does have the Engintron nginx installed, but there is nothing in the location specified. After those error messages the script just hangs, and requires a ctrl-c to break out. I have tried both the centos and centos_whm versions of the script with the same result. Is this script incompatible with Engintron nginx?
haven't tested with Engintron nginx so definitely not compatible

I'm getting this error when running ./mysqlmymonlite for the first time.

Code:
The content of '/home/.cpan/build/DBD-mysql-4.047-4/META.json' is not a HASH reference. Cannot use it.
Configuring C/CA/CAPTTOFU/DBD-mysql-4.047.tar.gz with Makefile.PL
Can't locate Devel/CheckLib.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 12.
BEGIN failed--compilation aborted at Makefile.PL line 12.
No 'Makefile' created  CAPTTOFU/DBD-mysql-4.047.tar.gz
  /usr/bin/perl Makefile.PL OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again
Re-running the script gives the same error.

This is on a fresh installed server. What can I do to solve this?
will have to check myself as it has been a while and alot of cpanel updates have occurred

are you using centos 6 or 7 ?
 
Last edited:

eva2000

Well-Known Member
Aug 14, 2001
338
15
318
Brisbane, Australia
vbtechsupport.com
cPanel Access Level
Root Administrator
Twitter
I'm getting this error when running ./mysqlmymonlite for the first time.

Code:
The content of '/home/.cpan/build/DBD-mysql-4.047-4/META.json' is not a HASH reference. Cannot use it.
Configuring C/CA/CAPTTOFU/DBD-mysql-4.047.tar.gz with Makefile.PL
Can't locate Devel/CheckLib.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 12.
BEGIN failed--compilation aborted at Makefile.PL line 12.
No 'Makefile' created  CAPTTOFU/DBD-mysql-4.047.tar.gz
  /usr/bin/perl Makefile.PL OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again
Re-running the script gives the same error.

This is on a fresh installed server. What can I do to solve this?
if you run this first
Code:
perl -MCPAN -e 'install Devel::CheckLib'
then re-run mysqlmymonlite.sh does it help ?
 

eva2000

Well-Known Member
Aug 14, 2001
338
15
318
Brisbane, Australia
vbtechsupport.com
cPanel Access Level
Root Administrator
Twitter
The server does have the Engintron nginx installed, but there is nothing in the location specified. After those error messages the script just hangs, and requires a ctrl-c to break out. I have tried both the centos and centos_whm versions of the script with the same result. Is this script incompatible with Engintron nginx?
know a bit late but what's output for these 2 commands
Code:
which nginx
nginx -t
 
  • Like
Reactions: Infopro

ronaldst

Well-Known Member
Feb 22, 2016
85
16
8
Norway
cPanel Access Level
Root Administrator
I am no longer on the server I previously had issues on.

However, on a freshly installed server with CentOS 7 I'm again facing issues using the script.

I've downloaded the latest version, and copied centos_whm from within the ZIP file to a directory called /root/mysqlmymonlite.

First attempted run of mysqlmymonlite.sh shows errors at the end of the process.

Code:
Running make for M/MI/MICHIELB/DBD-mysql-4.048.tar.gz

cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
Running Mkbootstrap for mysql ()
chmod 644 "mysql.bs"
"/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- mysql.bs blib/arch/auto/DBD/mysql/mysql.bs 644
gcc -c  -I/usr/lib64/perl5/vendor_perl/auto/DBI -I/usr/include/mysql -I/usr/include/mysql/mysql -DDBD_MYSQL_WITH_SSL -g  -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic   -DVERSION=\"4.048\" -DXS_VERSION=\"4.048\" -fPIC "-I/usr/lib64/perl5/CORE"   dbdimp.c
In file included from /usr/include/mysql/mysql.h:60:0,
                 from dbdimp.h:21,
                 from dbdimp.c:15:
dbdimp.c: In function ‘mysql_dr_connect’:
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1910:56: note: in expansion of macro ‘MARIADB_BASE_VERSION’
 #if (MYSQL_VERSION_ID >= 50723) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1917:56: note: in expansion of macro ‘MARIADB_BASE_VERSION’
 #if (MYSQL_VERSION_ID >= 50600) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
dbdimp.c:1936:19: warning: unused variable ‘ssl_mode’ [-Wunused-variable]
      unsigned int ssl_mode;
                   ^
dbdimp.c: In function ‘mysql_st_prepare’:
dbdimp.c:3200:24: warning: assignment from incompatible pointer type [enabled by default]
           bind->is_null=      (_Bool*) &(fbind->is_null);
                        ^
gmake: *** [dbdimp.o] Error 1
  MICHIELB/DBD-mysql-4.048.tar.gz
  /usr/bin/gmake OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again
Trying to run mysqlmymonlite.sh again, I get the following errors.

Code:
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1910:56: note: in expansion of macro ‘MARIADB_BASE_VERSION’
 #if (MYSQL_VERSION_ID >= 50723) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1917:56: note: in expansion of macro ‘MARIADB_BASE_VERSION’
 #if (MYSQL_VERSION_ID >= 50600) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
dbdimp.c:1936:19: warning: unused variable ‘ssl_mode’ [-Wunused-variable]
      unsigned int ssl_mode;
                   ^
dbdimp.c: In function ‘mysql_st_prepare’:
dbdimp.c:3200:24: warning: assignment from incompatible pointer type [enabled by default]
           bind->is_null=      (_Bool*) &(fbind->is_null);
                        ^
gmake: *** [dbdimp.o] Error 1
  MICHIELB/DBD-mysql-4.048.tar.gz
  /usr/bin/gmake OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 OTHERLDFLAGS=-L/usr/lib64 LDFLAGS=-L/usr/lib64 EXTRALIBDIR=/usr/lib64 -- NOT OK
----------------------------------------------------------
Installation complete. Exiting script...
Please re-run ./mysqlmymonlite.sh again
I am running MariaDB 10.2.18.

Are you able to point me in the right direction to what might be wrong here?

Thank you.
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,862
2,216
363
cPanel Access Level
DataCenter Provider
Twitter
  • Like
Reactions: ronaldst

ronaldst

Well-Known Member
Feb 22, 2016
85
16
8
Norway
cPanel Access Level
Root Administrator
Thank you.

Mysqltuner is missing a lot of the great features in mysqlmymonlite.

I was hoping @eva2000 or someone knew how to fix this, I would like to get the script going again.

I dont know why it fails a fresh Centos 7/WHM with MariaDB.

Anyone else experiencing issues with this?

Does it require certain perl modules that I might be missing?

Any guidance would be appreciated.
 

eva2000

Well-Known Member
Aug 14, 2001
338
15
318
Brisbane, Australia
vbtechsupport.com
cPanel Access Level
Root Administrator
Twitter
@ronaldst Unfortunately, i can't reproduce this issue on my existing cpanel/whm server and don't have access to any other cpanel/whm licenses to be able to test this on a fresh centos 7 install.

are you just running mysqlmymonlite.sh without any options ? or running specific flag i.e.

mysqlmymonlite.sh mysqlreport command

Code:
./mysqlmymonlite.sh mysqlreport              

-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.7 WHM mysqlmymon.com
compiled by George Liu (eva2000) centminmod.com
-------------------------------------------------------------

Report Generated:
Mon Oct 29 01:53:17 UTC 2018

----------------------------
mysqlreport output
----------------------------

MariaDB 10.1.35-MariaDB     uptime 82 2:45:3    Mon Oct 29 01:53:17 2018

__ Key _________________________________________________________________
Buffer used    33.48M of    1.17G   %Used:   2.79
  Current     249.80M              %Usage:  20.82
Write hit       1.71%
Read hit      100.00%

__ Questions ___________________________________________________________
Total           4.37G     616.6/s
  -Unknown     14.39G      2.0k/s  %Total: 328.94
  Com_         11.21G      1.6k/s          256.12
  DMS           3.91G     551.6/s           89.46
  QC Hits       3.53G     497.4/s           80.66
  COM_QUIT    118.23M      16.7/s            2.70
Slow 1 s            0         0/s            0.00  %DMS:   0.00 Log:
DMS             3.91G     551.6/s           89.46
  SELECT        3.78G     532.6/s           86.38         96.56
  INSERT      114.18M      16.1/s            2.61          2.92
  UPDATE       17.87M       2.5/s            0.41          0.46
  DELETE        2.61M       0.4/s            0.06          0.07
  REPLACE           6       0.0/s            0.00          0.00
Com_           11.21G      1.6k/s          256.12
  stmt_prepar   3.58G     504.5/s           81.81
  stmt_execut   3.58G     504.5/s           81.81
  stmt_close    3.52G     496.0/s           80.43

__ Rows ________________________________________________________________
Rows            1.68T    237.1k/s
  Using idx   497.16G     70.1k/s  %Index:  29.56
Rows/question  384.43

__ SELECT and Sort _____________________________________________________
Scan           35.92M       5.1/s %SELECT:   0.95
Range          45.48M       6.4/s            1.20
Full join       5.24k       0.0/s            0.00
Range check       543       0.0/s            0.00
Full rng join   5.87k       0.0/s            0.00
Sort scan      12.93M       1.8/s
Sort range     34.66M       4.9/s
Sort mrg pass  21.32k       0.0/s

__ Query Cache _________________________________________________________
Memory usage  202.38M of  256.00M  %Usage:  79.05
Block Fragmnt  16.59%
Hits            3.53G     497.4/s
Inserts       209.76M      29.6/s
Insrt:Prune   50.66:1      29.0/s
Hit:Insert    16.82:1

__ Table Locks _________________________________________________________
Waited          2.24M       0.3/s  %Total:   0.30
Immediate     734.47M     103.5/s

__ Tables ______________________________________________________________
Open             2766 of  10000    %Cache:  27.66
Opened         16.57k       0.0/s

__ Connections _________________________________________________________
Max used           99 of   1000      %Max:   9.90
Total         118.24M      16.7/s

__ Created Temp ________________________________________________________
Disk table      1.44M       0.2/s   %Disk:   5.74
Table          25.09M       3.5/s    Size:   2.0G
File           41.20k       0.0/s

__ Threads _____________________________________________________________
Running             7 of     17
Created            99       0.0/s
Slow                0         0/s
Cached             82 of   1000      %Hit:    100

__ Aborted _____________________________________________________________
Clients        31.05k       0.0/s
Connects        1.13k       0.0/s

__ Bytes _______________________________________________________________
Sent           70.74T     10.0M/s
Received        1.03T    145.1k/s

__ InnoDB Buffer Pool __________________________________________________
Usage          15.75G of   16.00G  %Usage:  98.44
Read hit      100.00%
Pages
  Free         16.39k              %Total:   1.56
  Data          1.01M                       96.03  %Drty:   3.70
  Misc          25278                        2.41
  Latched           0                        0.00
Reads           1.71T    240.7k/s
  From disk    30.62M       4.3/s   %Disk:   0.00
  Ahead Rnd         0         0/s
Writes          1.05G     147.5/s
Wait Free        7589       0.0/s   %Wait:   0.00
Flushes        83.81M      11.8/s
  LRU               0         0/s  %Flush:   0.00

__ InnoDB Lock _________________________________________________________
Waits          503117       0.1/s
Current             4
Time acquiring
  Total     356867821 ms
  Average         709 ms
  Max           43715 ms
Trx history      6.00M

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        45.82M       6.5/s
  Writes      143.75M      20.3/s
  fsync        21.77M       3.1/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created       4.92M       0.7/s
  Read         45.82M       6.5/s
  Written      83.81M      11.8/s

Rows
  Deleted      18.74M       2.6/s
  Inserted     22.05M       3.1/s
  Read          1.33T    187.0k/s
  Updated      76.49M      10.8/s

__ Aria Pagecache ______________________________________________________
Buffer used    68.84M of    1.00G   %Used:   6.72
  Current      42.30M              %Usage:   4.13
Write hit      99.47%
Read hit       85.81%

__ Subquery Cache ______________________________________________________
Hit ratio      12.55%
Hits            6.45M      0.9/s
Miss           44.97M      6.3/s

Report Complete:
Mon Oct 29 01:53:17 UTC 2018
----------------------------
might be DBD-mysql issue token ""mariadb-10.1"" is not valid in preprocessor expressions · Issue #262 · perl5-dbi/DBD-mysql

issue apparently fixed in DBD-mysql 4.0.49

tried installing perl DBD-mysql from whm logged in modules installer ?
 
Last edited:

ronaldst

Well-Known Member
Feb 22, 2016
85
16
8
Norway
cPanel Access Level
Root Administrator
I'm getting the error running mysqlmymonlite.sh without any options.

Instaling DBD::mysql (4.048) returns errors and fails.

Code:
In file included from /usr/include/mysql/mysql.h:60:0,
                 from dbdimp.h:21,
                 from dbdimp.c:15:
dbdimp.c: In function 'mysql_dr_connect':
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1910:56: note: in expansion of macro 'MARIADB_BASE_VERSION'
 #if (MYSQL_VERSION_ID >= 50723) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
/usr/include/mysql/mariadb_version.h:14:31: error: token ""mariadb-10.2"" is not valid in preprocessor expressions
 #define MARIADB_BASE_VERSION  "mariadb-10.2"
                               ^
dbdimp.c:1917:56: note: in expansion of macro 'MARIADB_BASE_VERSION'
 #if (MYSQL_VERSION_ID >= 50600) && (MYSQL_VERSION_ID < MARIADB_BASE_VERSION)
                                                        ^
dbdimp.c:1936:19: warning: unused variable 'ssl_mode' [-Wunused-variable]
      unsigned int ssl_mode;
                   ^
dbdimp.c: In function 'mysql_st_prepare':
dbdimp.c:3200:24: warning: assignment from incompatible pointer type [enabled by default]
           bind->is_null=      (_Bool*) &(fbind->is_null);
                        ^
make: *** [dbdimp.o] Error 1

FAIL
! Installing DBD::mysql failed. See /home/.cpanm/work/1540804090.13018/build.log for details. Retry with --force to force install it.
Expiring 14 work directories.
System Expect failed with non-zero exit status: 1
I can't find an option to install DBD::mysql (4.049), not sure if it's released yet.

Due to your suggestion of installing this module, is it correct to say this module is required to run mysqlmymonlite.sh?

Thank you.
 
Last edited:

ronaldst

Well-Known Member
Feb 22, 2016
85
16
8
Norway
cPanel Access Level
Root Administrator
Yes it is required and usually does work for my cpanel installs and that of of my clients.
Over the weekend I did a test to put this to rest.

1. I installed CentOS 7 and release tier of cPanel on a new VPS. After a very basic configuration of WHM/cPanel, I then proceeded to install mysqlmymonlite. Everything works fine.

2. I wiped the VPS and reinstalled CentOS and cPanel. I did the exact same configuration once again, but this around I installed/upgraded to MariaDB 10.2. I then installed mysqlmymonlite, and it fails.

I don't understand what the exact reason of why bits and pieces are failing, but to me mysqlmymonlite does not seem compatible with MariaDB 10.2 in a CentOS/cPanel enviroment.

Thats my conclusion.
 

eva2000

Well-Known Member
Aug 14, 2001
338
15
318
Brisbane, Australia
vbtechsupport.com
cPanel Access Level
Root Administrator
Twitter
could be DBD-mysql 4.0.48 doesn't support MariaDB 10.2 as yet compilation erro when using with MariaDB 10.2 · Issue #250 · perl5-dbi/DBD-mysql

seems there's a commit fix in master branch which is for DBD-mysql 4.0.49 planned release Fix compiling against MariaDB · perl5-dbi/[email protected]
 
Last edited:

eva2000

Well-Known Member
Aug 14, 2001
338
15
318
Brisbane, Australia
vbtechsupport.com
cPanel Access Level
Root Administrator
Twitter
@ronaldst I tested the DBD-mysql master branch commit patch for fixing MariaDB 10.2+ compatibility and it works for compilation at least on non-cpanel CentOS 7.5 server at dbd-mysql for mariadb 10.2+ but whether that is only fix needed not sure. As you're testing on test VPS maybe worth trying to see if that works for you.

Test was done on MariaDB 10.3 based non-cpanel server
Code:
mysqladmin ver
mysqladmin  Ver 9.1 Distrib 10.3.10-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.3.10-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 14 days 12 hours 10 min 16 sec

Threads: 7  Questions: 2380407  Slow queries: 0  Opens: 267  Flush tables: 1  Open tables: 222  Queries per second avg: 1.899
 
Last edited: