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

An alternative for mysqlmymonlite?

Discussion in 'Server Configuration and Hosting' started by Moshe1010, Jun 14, 2015.

  1. Moshe1010

    Moshe1010 Well-Known Member

    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
     
  2. RoldanLT

    RoldanLT Well-Known Member

    eva2000 likes this.
  3. Moshe1010

    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: Jun 14, 2015
  4. eva2000

    eva2000 Well-Known Member

    Moshe1010 likes this.
  5. Moshe1010

    Moshe1010 Well-Known Member

  6. eva2000

    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 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: Jun 14, 2015
  7. Mouth

    Mouth Well-Known Member

    I use newrelic.com, with mysql plugin
     
  8. Moshe1010

    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
     

Share This Page