Featured mysqlmymonlite.sh Addon

eva2000 · May 26, 2014

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.

eva2000 · May 26, 2014

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

eva2000 · May 26, 2014

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

eva2000 · May 26, 2014

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
----------------------------

eva2000 · May 26, 2014

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 |
+-------------------------------------------+----------------+----------------+-----------+------------+--------+

eva2000 · May 26, 2014

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

eva2000 · May 26, 2014

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

eva2000 · May 26, 2014

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

rdan · Jun 13, 2014

Is it ok to use on mariadb 10.0.11?

rdan · Jun 13, 2014

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
----------------------------

rdan · Jun 13, 2014

Seems fine, I don't see any variable need to adjust
https://gist.github.com/anonymous/5579505b090e75e0f2d0

eva2000 · Jun 13, 2014

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
----------------------------

seopolis · Sep 10, 2014

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.

eva2000 · Sep 11, 2014

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 ?

seopolis · Sep 11, 2014

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.

eva2000 · Sep 11, 2014

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'

seopolis · Sep 11, 2014

ok, here is the results of "cat /proc/meminfo"
centmin-forum-111 - Pastebin.com

The MemTotal value, divided by 1023 is 31856

and these are the results of "free -m"
centmin-forum-112 - Pastebin.com

Now what should I put in these FORCEMEM value and edit FORCESWAP values??

Sorry, but I'm little lost about that.

eva2000 · Sep 11, 2014

Code:

FORCEMEM='31856'
FORCESWAP='2047'

seopolis · Sep 11, 2014

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.

eva2000 · Sep 11, 2014

seopolis said: ↑

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.
Click to expand...

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 ?

Log in / Register

Forums

Get the most out of your Centmin Mod LEMP stack

Featured mysqlmymonlite.sh Addon

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

eva2000 Administrator Staff Member

seopolis New Member

eva2000 Administrator Staff Member

seopolis New Member

eva2000 Administrator Staff Member

seopolis New Member

eva2000 Administrator Staff Member

seopolis New Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Get the most out of your Centmin Mod LEMP stack

Featured mysqlmymonlite.sh Addon

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

rdan Well-Known Member

rdan Well-Known Member

rdan Well-Known Member

eva2000 Administrator Staff Member

seopolis New Member

eva2000 Administrator Staff Member

seopolis New Member

eva2000 Administrator Staff Member

seopolis New Member

eva2000 Administrator Staff Member

seopolis New Member

eva2000 Administrator Staff Member

.