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!
Problem resolved after firewall disabled! so strange and why?!@Masimo make sure you have correct mysql root user/pass details and if they're same in /root/.my.cnf
ah i see so you on an intranet ! explains the problem.I think mysqltuner will be download on server after "./mysqlmymonlite.sh mysqltuner"
Its not good idea for local and intranet servers.
Any one who help me about the above issue.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.
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)
[[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 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
haven't tested with Engintron nginx so definitely not compatibleI 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)
will have to check myself as it has been a while and alot of cpanel updates have occurredI'm getting this error when running ./mysqlmymonlite for the first time.
Re-running the script gives the same error.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
This is on a fresh installed server. What can I do to solve this?
if you run this firstI'm getting this error when running ./mysqlmymonlite for the first time.
Re-running the script gives the same error.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
This is on a fresh installed server. What can I do to solve this?
perl -MCPAN -e 'install Devel::CheckLib'
know a bit late but what's output for these 2 commandsThe 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?
which nginx
nginx -t
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
/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
Hello @ronaldst,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.
./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
----------------------------
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
Yes it is required and usually does work for my cpanel installs and that of of my clients.Due to your suggestion of installing this module, is it correct to say this module is required to run mysqlmymonlite.sh?
Over the weekend I did a test to put this to rest.Yes it is required and usually does work for my cpanel installs and that of of my clients.
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-mysqlmight 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
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