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).
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/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).
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/
post command you trying to runThe only info I can extract from mysqltuner.pl is: [OK] InnoDB buffer pool / data size: 3.0G/1.8G
I'm looking for a report like this:
https://community.centminmod.com/posts/131/
./mysqlmymonlite.sh run
./mysqlmymonlite.sh mysqltuner
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
----------------------------
./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
----------------------------
I use newrelic.com, with mysql pluginI'm trying to find a tool that shows me how much Innodb tables were cached on my server without calculating it manually. It looks like mysqlmymonlite doesn't work with MariaDB - does anybody have an alternative?
Can I send you somehow my ouput (you disabled PMs here)? It looks different for some reason from here. I try to run:post command you trying to run
that linked output is not from mysqltuner option but the full command run
Code:./mysqlmymonlite.sh run
and not mysqltuner
Code:./mysqlmymonlite.sh mysqltuner
make 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 ----------------------------
We use essential cookies to make this site work, and optional cookies to enhance your experience.