An alternative for mysqlmymonlite?
- Thread starter Moshe1010
- Start date
Moshe1010
Well-known member
That's the one I used so far. It doesn't work as far as I could tell on latest MariaDB version (with WHM/cPanel).
Last edited:
eva2000
Well-known member
should work.. might want to pop on by at https://community.centminmod.com/threads/mysqlmymonlite-sh-addon.65/ or https://forums.cpanel.net/threads/m...tats-gathering-tool-for-cpanel-server.268011/
Moshe1010
Well-known member
The only info I can extract from mysqltuner.pl is: [OK] InnoDB buffer pool / data size: 3.0G/1.8Gshould work.. might want to pop on by at https://community.centminmod.com/threads/mysqlmymonlite-sh-addon.65/ or https://forums.cpanel.net/threads/m...tats-gathering-tool-for-cpanel-server.268011/
I'm looking for a report like this:
https://community.centminmod.com/posts/131/
eva2000
Well-known member
post command you trying to run
that linked output is not from mysqltuner option but the full command run
Code:
./mysqlmymonlite.sh runand not mysqltuner
Code:
./mysqlmymonlite.sh mysqltunermake sure you're using mysqlmymonlite.sh v0.5.3 as it had a few fixes (to be sure delete mysqltuner.pl file and let mysqlmymonlite.sh redownload the latest modified version)
Code:
rm -rf /root/mysqltuner.pl
./mysqlmymonlite.sh mysqltuner
-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.3 mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------
Report Generated:
Sun Jun 14 09:49:07 UTC 2015
-------------------------------------------------
mysqltuner output
-------------------------------------------------
>> MySQLTuner 1.4.0 mod - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Modified by George Liu (eva2000) at http://vbtechsupport.com/
>> Run with '--help' for additional options and output filtering
[!!] Currently running unsupported MySQL version 10.0.19-MariaDB
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -ARCHIVE +Aria +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MyISAM
[--] Data in MyISAM tables: 799K (Tables: 18)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[!!] InnoDB is enabled but isn't being used
[!!] Total fragmented tables: 4
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 4m 2s (144 q [0.595 qps], 63 conn, TX: 372K, RX: 16K)
[--] Reads / Writes: 100% / 0%
[--] Total buffers: 240.0M global + 1.3M per thread (350 max threads)
[OK] Maximum possible memory usage: 688.4M (34% of installed RAM)
[OK] Slow queries: 0% (0/144)
[OK] Highest usage of available connections: 0% (1/350)
[OK] Key buffer size / total MyISAM indexes: 32.0M/248.0K
[!!] Key buffer hit rate: 10.7% (28 cached / 25 reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4 sorts)
[OK] Temporary tables created on disk: 0% (0 on disk / 44 total)
[!!] Thread cache hit rate: -93% (122 created / 63 connections)
[OK] Table cache hit rate: 256% (100 open / 39 opened)
[OK] Open file limit used: 1% (94/8K)
[OK] Table locks acquired immediately: 100% (75 immediate / 75 locks)
-------- Recommendations -----------------------------------------------------
General recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Variables to adjust:
query_cache_size (>= 8M)
thread_cache_size (> 64)
Report Complete:
Sun Jun 14 09:49:08 UTC 2015
----------------------------
Code:
./mysqlmymonlite.sh mysqlreport
-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.3 mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------
Report Generated:
Sun Jun 14 09:51:18 UTC 2015
----------------------------
mysqlreport output
----------------------------
MariaDB 10.0.19-MariaDB uptime 0 0:6:12 Sun Jun 14 09:51:19 2015
__ Key _________________________________________________________________
Buffer used 23.00k of 32.00M %Used: 0.07
Current 5.84M %Usage: 18.26
Write hit 0.00%
Read hit 10.71%
__ Questions ___________________________________________________________
Total 213 0.6/s
COM_QUIT 85 0.2/s %Total: 39.91
DMS 79 0.2/s 37.09
Com_ 59 0.2/s 27.70
-Unknown 10 0.0/s 4.69
Slow 1 s 0 0/s 0.00 %DMS: 0.00 Log:
DMS 79 0.2/s 37.09
SELECT 79 0.2/s 37.09 100.00
REPLACE 0 0/s 0.00 0.00
DELETE 0 0/s 0.00 0.00
INSERT 0 0/s 0.00 0.00
UPDATE 0 0/s 0.00 0.00
Com_ 59 0.2/s 27.70
show_variab 24 0.1/s 11.27
show_status 13 0.0/s 6.10
show_databa 9 0.0/s 4.23
__ Rows ________________________________________________________________
Rows 16.16k 43.4/s
Using idx 210 0.6/s %Index: 1.30
Rows/question 75.88
__ SELECT and Sort _____________________________________________________
Scan 71 0.2/s %SELECT: 89.87
Range 0 0/s 0.00
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 6 0.0/s
Sort range 0 0/s
Sort mrg pass 0 0/s
__ Table Locks _________________________________________________________
Waited 0 0/s %Total: 0.00
Immediate 76 0.2/s
__ Tables ______________________________________________________________
Open 100 of 4096 %Cache: 2.44
Opened 39 0.1/s
__ Connections _________________________________________________________
Max used 1 of 350 %Max: 0.29
Total 87 0.2/s
__ Created Temp ________________________________________________________
Disk table 0 0/s %Disk: 0.00
Table 71 0.2/s Size: 64.0M
File 6 0.0/s
__ Threads _____________________________________________________________
Running 1 of 1
Created 170 0.5/s
Slow 0 0/s
Threadpool 192 of 500 %Used: 38.40
Running 97 of 500 %Running: 19.40
Idle 95 of 500 %Idle: 19
__ Aborted _____________________________________________________________
Clients 0 0/s
Connects 1 0.0/s
__ Bytes _______________________________________________________________
Sent 503.44k 1.4k/s
Received 23.34k 62.7/s
__ InnoDB Buffer Pool __________________________________________________
Usage 2.48M of 127.98M %Usage: 1.94
Read hit 73.29%
Pages
Free 8.03k %Total: 98.06
Data 159 1.94 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 599 1.6/s
From disk 160 0.4/s %Disk: 26.71
Ahead Rnd 0 0/s
Writes 1 0.0/s
Flushes 1 0.0/s
Wait Free 0 0/s %Wait: 0.00
__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms
__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 173 0.5/s
Writes 5 0.0/s
fsync 5 0.0/s
Pending
Reads 0
Writes 0
fsync 0
Pages
Created 0 0/s
Read 159 0.4/s
Written 1 0.0/s
Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s
__ Aria Pagecache ______________________________________________________
Buffer used 0 of 16.00M %Used: 0.00
Current 656.00k %Usage: 4.00
Write hit 0.00%
Read hit 0.00%
Report Complete:
Sun Jun 14 09:51:19 UTC 2015
----------------------------
Last edited:
Mouth
Well-known member
I use newrelic.com, with mysql plugin
Moshe1010
Well-known member
Can I send you somehow my ouput (you disabled PMs here)? It looks different for some reason from here. I try to run:
root@lbs [~/mysqlmonlite053/centos_whm]# ./mysqlmymonlite.sh mysqltuner
Similar threads
- Question
- Question