Discover Centmin Mod today
Register Now

Featured mysqlmymonlite.sh Addon

Discussion in 'Add Ons' started by eva2000, May 26, 2014.

  1. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    My mysqlmymonlite.sh Addon http://centminmod.com/addons.html#mysqlmymonlite has been used by 100s of vBulletin and WHM/Cpanel customers for gathering their server environment and usage statistics. However, outside of vBulletin and WHM/Cpanel circles it hasn't been that well known.

    Official site
    Official site page is at http://mysqlmymon.com and the web site lists an example output of what type of server info and stats the script gathers.

    How to install video

    Located at http://mysqlmymon.com/#video



    Modified mysqltuner.pl

    For folks more use to mysqltuner.pl output for MySQL optimizations, the script includes a slightly modified version of mysqltuner.pl which you can call via the command option below. You can see example output for mysqltuner.pl here.

    Code:
    ./mysqlmymonlite.sh mysqltuner
    Extend mysqlmymonlite.sh with custom command

    v0.3.8 added the ability to customise and extend mysqlmymonlite.sh with end user custom SSH telnet command line support. A new menu option called 'custom' which can be called via ./mysqlmymonlite.sh custom. This option allows you to create a separate includes file name it incopt.inc and place it in same directory mysqlmymonlite.sh is located in. You can add your own custom SSH bash shell commands to this incopt.inc file to further extend mysqlmymonlite.sh's functionality and usefulness. Invoke and run these custom commands via:

    Code:
    ./mysqlmymonlite.sh custom
    For instance you could add iostats, php-fpm status and memcached stats commands to incopt.inc file as follows:

    Code:
        echo ""
        echo "iostat -x 5 2"
        iostat -x 5 2
    
        echo ""
        echo "lynx --dump  http://127.0.0.1/phpstatus"
        lynx --dump  http://127.0.0.1/phpstatus
    
        echo ""
        echo "memcached-tool 127.0.0.1:11211 stats"
        memcached-tool 127.0.0.1:11211 stats
    Full details are explained in readme.txt file included in download zip file. If you're familiar with bash shell scripting and normal SSH telnet environment commands, you can get pretty creative with what you add to incopt.inc file.

    Setup mysqlmymonlite.sh scheduled cron jobs

    The download zip file has a readme.txt file which has more detailed explanations and example usage commands - including how to setup a scheduled cron job to save output stats to timestamped text file or email the stats to a specified email address at specified intervals i.e. every 1 hour etc.

    Sharing stats publicly

    Sole purpose for mysqlmymonlite.sh is to allow server owners to quickly gather stats for their own use or to provide these stats publicly on forums etc, so that other users and readers can use these stats to provide server recommendations, optimisation advice or troubleshooting advice. If you're using forums as medium for sharing these stats, it's best to use the forum's custom BBCODE tags for code format to wrap the output stats for easier reading.
     
    Last edited: May 26, 2014
  2. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    mysqlmymonlite.sh options

    Code:
    /root/tools/mysqlmymonlite.sh
    please see help for all options available
    ./mysqlmymonlite.sh --help
    
    install mysqlmymonlite.sh at /root
    chmod +x mysqlmymonlite.sh
    
    ./mysqlmymonlite.sh --help
    ./mysqlmymonlite.sh check
    ./mysqlmymonlite.sh run
    ./mysqlmymonlite.sh mysql
    ./mysqlmymonlite.sh vmstat
    ./mysqlmymonlite.sh showcreate
    ./mysqlmymonlite.sh showindex
    ./mysqlmymonlite.sh vbshowtables
    ./mysqlmymonlite.sh dblist
    ./mysqlmymonlite.sh mysqlreport
    ./mysqlmymonlite.sh mysqlfullreport
    ./mysqlmymonlite.sh mysqltuner
    ./mysqlmymonlite.sh psmem
    ./mysqlmymonlite.sh pschema
     
  3. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    run output partial sample

    Code:
    /root/tools/mysqlmymonlite.sh run
    
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Mon May 26 20:56:44 EST 2014
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started 2014-05-26 20:54:09
    Uptime: 2 min 35 sec  
    Uptime 155
    Uptime_since_flush_status 155
    
    Max Used Connections:      1/350 (0.29%)
    Key Buffer Used:           52.00k/16.00M (0.32%)
    Key Buffer Used:           16.00k/8.00M (0.20%)
    Current Key Buffer Usage:  2.97M (18.55%)
    Current Key Buffer Usage:  328.00k (4.00%)
    InnoDB Buffer Pool:        11.47M/255.98M (4.48%)
    Table Locks Waited:        0 Rate: 0/s (0.00%)
    --------------------
    Query Cache Limit (bytes): 0
    Query Cache Min Unit (bytes): 2048
    Query Cache Size (bytes): 0
    Query Cache Free Mem (bytes): 0
    Query Cache Used Mem (bytes): 0
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 0
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 1, cores = 1, virtual = 2, hyperthreading = yes
          2  2800.062
          2  Intel(R) Xeon(R) CPU E5-2680 v2 @ 2.80GHz
          2  25600 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 3.14.4-x86_64-linode40 ((yourserverhostname))     05/26/2014      _x86_64_        (2 CPU)
    
    08:56:44 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    08:56:46 PM  all    0.25    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.75
    08:56:46 PM    0    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    08:56:46 PM    1    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
    
    08:56:46 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    08:56:48 PM  all    1.01    0.00    1.26    0.00    0.00    0.00    0.00    0.00   97.74
    08:56:48 PM    0    1.51    0.00    1.51    0.00    0.00    0.00    0.00    0.00   96.98
    08:56:48 PM    1    0.50    0.00    1.00    0.50    0.00    0.00    0.00    0.00   98.01
    
    Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
    Average:     all    0.63    0.00    0.63    0.00    0.00    0.00    0.00    0.00   98.75
    Average:       0    0.75    0.00    0.75    0.00    0.00    0.00    0.00    0.00   98.49
    Average:       1    0.25    0.00    0.50    0.25    0.00    0.00    0.00    0.00   99.00
    
    top - 20:56:49 up 2 days, 21:10,  1 user,  load average: 0.03, 0.03, 0.05
    Tasks:  96 total,   1 running,  95 sleeping,   0 stopped,   0 zombie
    Cpu0  :  0.6%us,  0.3%sy,  0.0%ni, 99.1%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
    Cpu1  :  0.6%us,  0.3%sy,  0.0%ni, 99.1%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
    Mem:   2040896k total,  1623176k used,   417720k free,   102720k buffers
    Swap:   524284k total,     1140k used,   523144k free,  1064668k cached
     
  4. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    mysqlreport

    Code:
    /root/tools/mysqlmymonlite.sh mysqlreport
    
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Mon May 26 20:59:04 EST 2014
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MariaDB 5.5.37-MariaDB      uptime 0 0:4:55     Mon May 26 20:59:04 2014
    
    __ Key _________________________________________________________________
    Buffer used   137.00k of   16.00M   %Used:   0.84
      Current       3.05M              %Usage:  19.07
    Write hit      39.96%
    Read hit       88.48%
    
    __ Questions ___________________________________________________________
    Total           1.42k       4.8/s
      Com_          3.60k      12.2/s  %Total: 254.23
      -Unknown      3.33k      11.3/s          234.84
      DMS           1.05k       3.6/s           74.05
      COM_QUIT         93       0.3/s            6.56
    Slow 1 s            0         0/s            0.00  %DMS:   0.00 Log: OFF
    DMS             1.05k       3.6/s           74.05
      SELECT          771       2.6/s           54.37         73.43
      INSERT          127       0.4/s            8.96         12.10
      UPDATE          125       0.4/s            8.82         11.90
      REPLACE          14       0.0/s            0.99          1.33
      DELETE           13       0.0/s            0.92          1.24
    Com_            3.60k      12.2/s          254.23
      stmt_prepar   1.01k       3.4/s           71.58
      stmt_execut   1.01k       3.4/s           71.58
      stmt_close      956       3.2/s           67.42
    
    __ Rows ________________________________________________________________
    Rows           26.62k      90.2/s
      Using idx    13.44k      45.6/s  %Index:  50.51
    Rows/question   18.77
    
    __ SELECT and Sort _____________________________________________________
    Scan              158       0.5/s %SELECT:  20.49
    Range              88       0.3/s           11.41
    Full join           0         0/s            0.00
    Range check         0         0/s            0.00
    Full rng join       0         0/s            0.00
    Sort scan          48       0.2/s
    Sort range         32       0.1/s
    Sort mrg pass       0         0/s
    
    __ Table Locks _________________________________________________________
    Waited              0         0/s  %Total:   0.00
    Immediate       1.88k       6.4/s
    
    __ Tables ______________________________________________________________
    Open              227 of  10240    %Cache:   2.22
    Opened            201       0.7/s
    
    __ Connections _________________________________________________________
    Max used            1 of    350      %Max:   0.29
    Total              95       0.3/s
    
    __ Created Temp ________________________________________________________
    Disk table         17       0.1/s   %Disk:  13.60
    Table             125       0.4/s    Size: 256.0M
    File                6       0.0/s
    
    __ Threads _____________________________________________________________
    Running             1 of      1
    Created             1       0.0/s
    Slow                0         0/s
    Cached              0 of    384      %Hit:  98.95
    
    __ Aborted _____________________________________________________________
    Clients             0         0/s
    Connects            1       0.0/s
    
    __ Bytes _______________________________________________________________
    Sent            7.16M     24.3k/s
    Received      405.65k      1.4k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage          24.33M of  255.98M  %Usage:   9.50
    Read hit       98.03%
    Pages
      Free         14.83k              %Total:  90.50
      Data          1.55k                        9.48  %Drty:   0.00
      Misc              4                        0.02
      Latched           0                        0.00
    Reads          78.71k     266.8/s
      From disk     1.55k       5.3/s   %Disk:   1.97
      Ahead Rnd         0         0/s
    Writes          1.15k       3.9/s
    Flushes           544       1.8/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         1.74k       5.9/s
      Writes          700       2.4/s
      fsync           197       0.7/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created           3       0.0/s
      Read          1.55k       5.3/s
      Written         544       1.8/s
    
    Rows
      Deleted           8       0.0/s
      Inserted         57       0.2/s
      Read         11.31k      38.3/s
      Updated          91       0.3/s
    
    __ Aria Pagecache ______________________________________________________
    Buffer used    16.00k of    8.00M   %Used:   0.20
      Current     328.00k              %Usage:   4.00
    Write hit     100.00%
    Read hit       95.63%
    
    Report Complete:
    Mon May 26 20:59:04 EST 2014
    ----------------------------
     
  5. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    vbshowtables option (yeah from vB usage) but works for any MySQL database tables

    Code:
    /root/tools/mysqlmymonlite.sh vbshowtables
    
    What is your mysql database name ? xenforodbname
    
    Do you want to continue with display all xenforodbname tables info ? [y/n]y
    
    Do you want save output to text file ? Answering no will output only to screen. [y/n]n
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 713544 kilobytes of disk space
    
    ------------------------------
    xenforodbname Index Size = 7.91 MB
    ------------------------------
    ------------------------------
    xenforodbname Data Size = 45.54 MB
    ------------------------------
    ----------------------
    xenforodbname per Table Size
    ----------------------
    +-------------------------------------------+----------------+----------------+-----------+------------+--------+
    | Table Name                                | Number of Rows | Storage Engine | Data Size | Index Size | Total  |
    +-------------------------------------------+----------------+----------------+-----------+------------+--------+
    | xenforodbname.xf_addon                             | 31 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_admin                             | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_admin_log                         | 521 Rows       | InnoDB         | 1.52MB    | 0.03MB     | 1.55MB |
    | xenforodbname.xf_admin_navigation                  | 140 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_admin_permission                  | 25 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_admin_permission_entry            | 24 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_admin_search_type                 | 19 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_admin_template                    | 667 Rows       | InnoDB         | 6.50MB    | 0.05MB     | 6.55MB |
    | xenforodbname.xf_admin_template_compiled           | 516 Rows       | InnoDB         | 3.48MB    | 0.00MB     | 3.48MB |
    | xenforodbname.xf_admin_template_include            | 255 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_admin_template_modification       | 46 Rows        | InnoDB         | 0.06MB    | 0.05MB     | 0.11MB |
    | xenforodbname.xf_admin_template_modification_log   | 20 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_admin_template_phrase             | 5767 Rows      | InnoDB         | 0.31MB    | 0.22MB     | 0.53MB |
    | xenforodbname.xf_attachment                        | 19 Rows        | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_attachment_data                   | 19 Rows        | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_attachment_view                   | 1 Rows         | MEMORY         | 0.25MB    | 0.25MB     | 0.49MB |
    | xenforodbname.xf_ban_email                         | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_bb_code                           | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_bb_code_media_site                | 6 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_bb_code_parse_cache               | 108 Rows       | InnoDB         | 0.52MB    | 0.05MB     | 0.56MB |
    | xenforodbname.xf_captcha_log                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_captcha_question                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_code_event                        | 45 Rows        | InnoDB         | 0.06MB    | 0.00MB     | 0.06MB |
    | xenforodbname.xf_code_event_listener               | 120 Rows       | InnoDB         | 0.06MB    | 0.03MB     | 0.09MB |
    | xenforodbname.xf_content_spam_cache                | 19 Rows        | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_content_type                      | 19 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_content_type_field                | 69 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_conversation_master               | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_conversation_message              | 5 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_conversation_recipient            | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_conversation_user                 | 2 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_cron_entry                        | 18 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_data_registry                     | 44 Rows        | InnoDB         | 1.06MB    | 0.00MB     | 1.06MB |
    | xenforodbname.xf_deferred                          | 1 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_deletion_log                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_draft                             | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_edit_history                      | 113 Rows       | InnoDB         | 0.20MB    | 0.03MB     | 0.23MB |
    | xenforodbname.xf_email_template                    | 33 Rows        | InnoDB         | 1.52MB    | 0.02MB     | 1.53MB |
    | xenforodbname.xf_email_template_compiled           | 43 Rows        | InnoDB         | 1.52MB    | 0.00MB     | 1.52MB |
    | xenforodbname.xf_email_template_modification       | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_email_template_modification_log   | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_email_template_phrase             | 186 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_error_log                         | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_feed                              | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_feed_log                          | 20 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_flood_check                       | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_forum                             | 16 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_forum_prefix                      | 23 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_forum_read                        | 54 Rows        | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_forum_watch                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_image_proxy                       | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_import_log                        | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_install_upgrade_login             | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_ip                                | 226 Rows       | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB |
    | xenforodbname.xf_ip_match                          | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_keywordalert_keyword              | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_keywordalert_queue                | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_language                          | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_liked_content                     | 22 Rows        | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB |
    | xenforodbname.xf_link_forum                        | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_link_proxy                        | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_login_attempt                     | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_mail_queue                        | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_moderation_queue                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_moderator                         | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_moderator_content                 | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_moderator_log                     | 34 Rows        | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB |
    | xenforodbname.xf_news                              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_news_feed                         | 158 Rows       | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_node                              | 22 Rows        | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB |
    | xenforodbname.xf_node_type                         | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_notice                            | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_notice_dismissed                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_option                            | 395 Rows       | InnoDB         | 0.19MB    | 0.00MB     | 0.19MB |
    | xenforodbname.xf_option_group                      | 46 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_option_group_relation             | 345 Rows       | InnoDB         | 0.05MB    | 0.02MB     | 0.06MB |
    | xenforodbname.xf_page                              | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_permission                        | 119 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_permission_cache_content          | 202 Rows       | InnoDB         | 0.17MB    | 0.00MB     | 0.17MB |
    | xenforodbname.xf_permission_combination            | 5 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_permission_combination_user_group | 10 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_permission_entry                  | 202 Rows       | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_permission_entry_content          | 2 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_permission_group                  | 9 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_permission_interface_group        | 14 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_phrase                            | 6244 Rows      | InnoDB         | 1.52MB    | 0.63MB     | 2.14MB |
    | xenforodbname.xf_phrase_compiled                   | 19753 Rows     | InnoDB         | 3.48MB    | 0.00MB     | 3.48MB |
    | xenforodbname.xf_phrase_map                        | 12299 Rows     | InnoDB         | 1.52MB    | 1.77MB     | 3.28MB |
    | xenforodbname.xf_poll                              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_poll_response                     | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_poll_vote                         | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_post                              | 87 Rows        | InnoDB         | 0.34MB    | 0.08MB     | 0.42MB |
    | xenforodbname.xf_profile_post                      | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_profile_post_comment              | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_registration_spam_cache           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_report                            | 0 Rows         | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB |
    | xenforodbname.xf_report_comment                    | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_resource                          | 0 Rows         | InnoDB         | 0.02MB    | 0.11MB     | 0.13MB |
    | xenforodbname.xf_resource_category                 | 11 Rows        | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_resource_category_prefix          | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_category_watch           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_download                 | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_resource_feature                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_field                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_field_category           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_field_value              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_prefix                   | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_prefix_group             | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_resource_rating                   | 0 Rows         | InnoDB         | 0.02MB    | 0.06MB     | 0.08MB |
    | xenforodbname.xf_resource_update                   | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_version                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_resource_watch                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_route_filter                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_route_prefix                      | 112 Rows       | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_search                            | 164 Rows       | InnoDB         | 0.11MB    | 0.03MB     | 0.14MB |
    | xenforodbname.xf_search_index                      | 204 Rows       | MyISAM         | 0.24MB    | 0.25MB     | 0.49MB |
    | xenforodbname.xf_session                           | 5 Rows         | MyISAM         | 0.03MB    | 0.01MB     | 0.04MB |
    | xenforodbname.xf_session_activity                  | 2 Rows         | MEMORY         | 0.25MB    | 0.25MB     | 0.49MB |
    | xenforodbname.xf_session_admin                     | 1 Rows         | MyISAM         | 0.00MB    | 0.00MB     | 0.00MB |
    | xenforodbname.xf_smilie                            | 12 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_smilie_category                   | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_spam_cleaner_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_spam_trigger_log                  | 8 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_statistics                        | 6 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_stats_daily                       | 23 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_style                             | 1 Rows         | InnoDB         | 0.06MB    | 0.00MB     | 0.06MB |
    | xenforodbname.xf_style_property                    | 398 Rows       | InnoDB         | 0.11MB    | 0.02MB     | 0.13MB |
    | xenforodbname.xf_style_property_definition         | 263 Rows       | InnoDB         | 0.11MB    | 0.02MB     | 0.13MB |
    | xenforodbname.xf_style_property_group              | 28 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_template                          | 685 Rows       | InnoDB         | 6.47MB    | 0.05MB     | 6.52MB |
    | xenforodbname.xf_template_compiled                 | 1398 Rows      | InnoDB         | 9.41MB    | 0.00MB     | 9.41MB |
    | xenforodbname.xf_template_history                  | 17 Rows        | InnoDB         | 0.09MB    | 0.05MB     | 0.14MB |
    | xenforodbname.xf_template_include                  | 733 Rows       | InnoDB         | 0.08MB    | 0.02MB     | 0.09MB |
    | xenforodbname.xf_template_map                      | 1800 Rows      | InnoDB         | 0.13MB    | 0.17MB     | 0.30MB |
    | xenforodbname.xf_template_modification             | 73 Rows        | InnoDB         | 0.08MB    | 0.05MB     | 0.13MB |
    | xenforodbname.xf_template_modification_log         | 63 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_template_phrase                   | 8792 Rows      | InnoDB         | 1.52MB    | 0.41MB     | 1.92MB |
    | xenforodbname.xf_thread                            | 64 Rows        | InnoDB         | 0.02MB    | 0.08MB     | 0.09MB |
    | xenforodbname.xf_thread_prefix                     | 10 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_thread_prefix_group               | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_thread_read                       | 153 Rows       | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_thread_redirect                   | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_thread_user_post                  | 79 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_thread_view                       | 9 Rows         | MEMORY         | 0.25MB    | 0.25MB     | 0.49MB |
    | xenforodbname.xf_thread_watch                      | 59 Rows        | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_tinhte_xentag_tag                 | 19 Rows        | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_tinhte_xentag_tag_watch           | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_tinhte_xentag_tagged_content      | 26 Rows        | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_trophy                            | 9 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_trophy_user_title                 | 4 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_upgrade_log                       | 1 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_user                              | 6 Rows         | InnoDB         | 0.02MB    | 0.16MB     | 0.17MB |
    | xenforodbname.xf_user_alert                        | 89 Rows        | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_user_alert_optout                 | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_user_authenticate                 | 6 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_user_ban                          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_user_change_log                   | 16 Rows        | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_user_change_temp                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_user_confirmation                 | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_external_auth                | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_field                        | 7 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_field_value                  | 7 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_follow                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_group                        | 5 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_group_change                 | 2 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_group_promotion              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_group_promotion_log          | 0 Rows         | InnoDB         | 0.02MB    | 0.03MB     | 0.05MB |
    | xenforodbname.xf_user_group_relation               | 8 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_ignored                      | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_news_feed_cache              | 0 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_user_option                       | 6 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_user_privacy                      | 6 Rows         | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB |
    | xenforodbname.xf_user_profile                      | 6 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_status                       | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_trophy                       | 9 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_upgrade                      | 1 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_upgrade_active               | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_user_upgrade_expired              | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_user_upgrade_log                  | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_warning                           | 0 Rows         | InnoDB         | 0.02MB    | 0.05MB     | 0.06MB |
    | xenforodbname.xf_warning_action                    | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_warning_action_trigger            | 0 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    | xenforodbname.xf_warning_definition                | 4 Rows         | InnoDB         | 0.02MB    | 0.02MB     | 0.03MB |
    +-------------------------------------------+----------------+----------------+-----------+------------+--------+
     
  6. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    showcreate option - want to find out the MySQL database table's structure without loading phpmyadmin ?

    easy !

    Code:
    /root/tools/mysqlmymonlite.sh showcreate
    
    What is your mysql database name ? xenforodbname
    
    Do you want to display all xenforodbname tables schema (how table was created) ? [y/n]y
    
    Do you want save output to text file ? Answering no will output only to screen. [y/n]n
    *************************** 1. row ***************************
           Table: xf_addon
    Create Table: CREATE TABLE `xf_addon` (
      `addon_id` varbinary(25) NOT NULL,
      `title` varchar(75) NOT NULL,
      `version_string` varchar(30) NOT NULL DEFAULT '',
      `version_id` int(10) unsigned NOT NULL DEFAULT '0',
      `url` varchar(100) NOT NULL,
      `install_callback_class` varchar(75) NOT NULL DEFAULT '',
      `install_callback_method` varchar(75) NOT NULL DEFAULT '',
      `uninstall_callback_class` varchar(75) NOT NULL DEFAULT '',
      `uninstall_callback_method` varchar(75) NOT NULL DEFAULT '',
      `active` tinyint(3) unsigned NOT NULL,
      `install_upgrade_filename` varchar(255) NOT NULL DEFAULT '',
      `install_upgrade_updated` tinyint(3) NOT NULL DEFAULT '0',
      `install_upgrade_headers` mediumblob,
      PRIMARY KEY (`addon_id`),
      KEY `title` (`title`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    *************************** 1. row ***************************
           Table: xf_admin
    Create Table: CREATE TABLE `xf_admin` (
      `user_id` int(10) unsigned NOT NULL,
      `extra_user_group_ids` varbinary(255) NOT NULL,
      `last_login` int(10) unsigned NOT NULL DEFAULT '0',
      `permission_cache` mediumblob,
      PRIMARY KEY (`user_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    *************************** 1. row ***************************
    
    snipped the long list of all database tables
     
  7. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    showindex option. Want to check if your database table's indexes are intact ?

    easy !

    Code:
    /root/tools/mysqlmymonlite.sh showindex
    
    What is your mysql database name ? xenforodbname
    
    Do you want to display all xenforodbname tables indexes ? [y/n] y
    
    Do you want save output to text file ? Answering no will output only to screen. [y/n] n
    +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    | Table    | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
    +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    | xf_addon |          0 | PRIMARY  |            1 | addon_id    | A         |          31 |     NULL | NULL   |      | BTREE      |         |               |
    | xf_addon |          1 | title    |            1 | title       | A         |          31 |     NULL | NULL   |      | BTREE      |         |               |
    +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    | Table    | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
    +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    | xf_admin |          0 | PRIMARY  |            1 | user_id     | A         |           1 |     NULL | NULL   |      | BTREE      |         |               |
    +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    +--------------+------------+----------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    | Table        | Non_unique | Key_name             | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
    +--------------+------------+----------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    | xf_admin_log |          0 | PRIMARY              |            1 | admin_log_id | A         |        1450 |     NULL | NULL   |      | BTREE      |         |               |
    | xf_admin_log |          1 | request_date         |            1 | request_date | A         |        1450 |     NULL | NULL   |      | BTREE      |         |               |
    | xf_admin_log |          1 | user_id_request_date |            1 | user_id      | A         |           7 |     NULL | NULL   |      | BTREE      |         |               |
    | xf_admin_log |          1 | user_id_request_date |            2 | request_date | A         |        1450 |     NULL | NULL   |      | BTREE      |         |               |
    +--------------+------------+----------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    output to text files instead of display will allow you to use diff and compare tools to compare 2 or more databases and their tables to ensure indexes are not missing etc :)
     
  8. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    want to simply list all MySQL databases on your server ?

    dblist option does that

    Code:
    /root/tools/mysqlmymonlite.sh dblist
    
    mysql performance_schema test xenforodbname
     
  9. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:03 PM
    1.11
    10.2
    Is it ok to use on mariadb 10.0.11?
     
  10. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:03 PM
    1.11
    10.2
    mysqltuner doesn't work?
    Code:
    # ./mysqlmymonlite.sh mysqltuner
    
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Fri Jun 13 04:08:19 PHT 2014
    
    -------------------------------------------------
    mysqltuner output
    -------------------------------------------------
    mysqltuner.pl [found]
    
    >>  MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net>
    >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
    >>  Run with '--help' for additional options and output filtering
    [!!] The --forcemem option is required for remote connections
    
    Report Complete:
    Fri Jun 13 04:08:19 PHT 2014
    ----------------------------
    
     
  11. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:03 PM
    1.11
    10.2
  12. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah main run should be fine. Just mysqltuner.pl in Centmin Mod is older than one used in mysqlmymonlite.sh but mysqlmymonlite.sh doesn't download the new one if /root/mysqltuner.pl already exists.

    So remove /root/mysqltuner.pl and then re-run mysqlmymonlite.sh and it will download updated modified mysqltuner.pl which works with MariaDB 10.x

    on my test VPS with MariaDB 10.0.11

    Code:
    /root/tools/mysqlmymonlite.sh mysqltuner
    
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Fri Jun 13 06:50:24 EST 2014
    
    -------------------------------------------------
    mysqltuner output
    -------------------------------------------------
    mysqltuner.pl [found]
    
    >>  MySQLTuner 1.3.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.11-MariaDB
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: -ARCHIVE +Aria +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MyISAM
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
    [!!] InnoDB is enabled but isn't being used
    [OK] Total fragmented tables: 0
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 28m 58s (279 q [0.161 qps], 121 conn, TX: 751K, RX: 33K)
    [--] Reads / Writes: 100% / 0%
    [--] Total buffers: 152.0M global + 800.0K per thread (300 max threads)
    [OK] Maximum possible memory usage: 386.4M (18% of installed RAM)
    [OK] Slow queries: 0% (0/279)
    [OK] Highest usage of available connections: 0% (1/300)
    [OK] Key buffer size / total MyISAM indexes: 32.0M/124.0K
    [!!] Query cache efficiency: 0.0% (0 cached / 99 selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 6 sorts)
    [OK] Temporary tables created on disk: 6% (11 on disk / 183 total)
    [OK] Thread cache hit rate: 99% (1 created / 121 connections)
    [OK] Table cache hit rate: 415% (83 open / 20 opened)
    [OK] Open file limit used: 0% (62/8K)
    [OK] Table locks acquired immediately: 100% (77 immediate / 77 locks)
    [!!] Connections aborted: 10%
    [OK] InnoDB log waits: 0
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Add skip-innodb to MySQL configuration to disable InnoDB
        MySQL started within last 24 hours - recommendations may be inaccurate
        Your applications are not closing MySQL connections properly
    
    Variables to adjust:
        query_cache_limit (> 512K, or use smaller result sets)
    
    
    Report Complete:
    Fri Jun 13 06:50:24 EST 2014
    ----------------------------
     
    • Like Like x 1
  13. seopolis

    seopolis New Member

    9
    0
    1
    Aug 23, 2014
    Ratings:
    +0
    Local Time:
    2:03 PM
    5.5
    Mysqltuner gives the same error to me:

    Code:
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.2 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Wed Sep 10 21:23:55 EST 2014
    
    -------------------------------------------------
    mysqltuner output
    -------------------------------------------------
    mysqltuner.pl [found]
    
     >>  MySQLTuner 1.3.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
    [!!] The --forcemem option is required for remote connections
    
    Report Complete:
    Wed Sep 10 21:23:55 EST 2014
    ----------------------------
    
    I removed the original /root/mysqltuner.pl as suggested.
    Also I use 'localhost' at config.ini.
    I don't know what cause this error. All other commands of mysqlmymonlite.sh script are running fine.

    Thanks for any help.
     
  14. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    yeah not sure if that is related to MariaDB 10.0.13 or something, mysqltuner works on MariaDB 10.0.11 i tested as well as MariaDB 5.5.39. How old is your Centmin Mod install ? what version are you using for Centmin Mod ? Is MariaDB on same local server or is it a remote server for dedicated MariaDB MySQL server ?
     
  15. seopolis

    seopolis New Member

    9
    0
    1
    Aug 23, 2014
    Ratings:
    +0
    Local Time:
    2:03 PM
    5.5
    I have the latest stable version Centmin Mod 1.2.3-eva2000.07
    I upgraded Ngingx to 1.7.1
    and MySQL version is 5.5.36-MariaDB
    And yes, MariaDB runs on same local server as Nginx etc.
     
  16. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    what does command in SSH below return

    Code:
    cat /proc/meminfo
    then take MemTotal value, divide by 1023 and get the megabytes value round up to nearest whole number

    find swap value via

    Code:
    free -m
    and edit mysqlmymonlite.sh FORCEMEM value and edit FORCESWAP value

    Code:
    # change from localhost if your have a remote
    # mysql server with dedicated ip address
    # if you set MYSQLHOST to remote server ip please set
    # FORCEMEM and FORCESWAP values below in megabytes
    # which relate to how much memory and swap space your
    # remote MySQL server has i.e. 512MB & 512MB
    MYSQLHOST='localhost'
    FORCEMEM='512'
    FORCESWAP='512'
     
  17. seopolis

    seopolis New Member

    9
    0
    1
    Aug 23, 2014
    Ratings:
    +0
    Local Time:
    2:03 PM
    5.5
  18. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    Code:
    FORCEMEM='31856'
    FORCESWAP='2047'
     
  19. seopolis

    seopolis New Member

    9
    0
    1
    Aug 23, 2014
    Ratings:
    +0
    Local Time:
    2:03 PM
    5.5
    I did that, and still the problem remains, giving the same exact error. Very strange indeed.
    I have to forget running mysqltuner I guess...
    Is there any other way to check if my.cnf it's ok for my server's use? Thanks.
     
  20. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:03 PM
    Nginx 1.13.x
    MariaDB 5.5
    the default set /etc/my.cnf is fine for initial use but tuning for better performance is let to end user :)

    yeah strange problem you're having - have you edited your /etc/my.cnf at all ?