• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

An alternative for mysqlmymonlite?

Moshe1010

Well-known member
#1
I'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?

Thanks
 

eva2000

Well-known member
#6
The 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/
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
----------------------------
 
Last edited:

Mouth

Well-known member
#7
I'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?
I use newrelic.com, with mysql plugin
 

Moshe1010

Well-known member
#8
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
----------------------------
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