user/pass is ok, all others mysqlmymonlite switch working fine.
Just i have problem with ./mysqlmymonlite.sh mysqltuner
Im confused!
Just i have problem with ./mysqlmymonlite.sh mysqltuner
Im confused!
I think mysqltuner will be download on server after "./mysqlmymonlite.sh mysqltuner"
Its not good idea for local and intranet servers.
Its not good idea for local and intranet servers.
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:
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:
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?
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)
I'm getting this error when running ./mysqlmymonlite for the first time.
Re-running the script gives the same error.
This is on a fresh installed server. What can I do to solve this?
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 againThis is on a fresh installed server. What can I do to solve this?
haven't tested with Engintron nginx so definitely not compatible
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:
if you run this first
Code:
perl -MCPAN -e 'install Devel::CheckLib'know a bit late but what's output for these 2 commands
Code:
which nginx
nginx -tI 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.
Trying to run mysqlmymonlite.sh again, I get the following errors.
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.
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
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 againAre you able to point me in the right direction to what might be wrong here?
Thank you.
Hello @ronaldst,
You could try using a different tuning script such as the one at:
major/MySQLTuner-perl
Thank you.
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.
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.
@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
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 ?
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
----------------------------issue apparently fixed in DBD-mysql 4.0.49
tried installing perl DBD-mysql from whm logged in modules installer ?
Last edited:
I'm getting the error running mysqlmymonlite.sh without any options.
Instaling DBD::mysql (4.048) returns errors and fails.
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.
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: 1Due to your suggestion of installing this module, is it correct to say this module is required to run mysqlmymonlite.sh?
Thank you.
Last edited:
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.
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:
@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
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:
