Latest Version: 0.5.7

What is mysqlmymonlite.sh ? [download zip]

mysqlmymonlite.sh is a MySQL optimization tool - a lite version of more extensive featured mysqlmymon.sh - a MySQL and system monitoring script written by George Liu (eva2000) for quick stats check for apache, nginx, litespeed web server and mysql stats for the following operating systems:

CentOS WHM/Cpanel
CentOS
Debian 6.x systems

mysqlmymon.sh is the big brother script to mysqlmymonlite.sh which is much more feature extensive and used for my private paid consults - it produces alot more detailed info for stats analysis and server & MySQL optimization but alot of the info is not suited to sharing in public. So I stripped down mysqlmymon.sh to create mysqlmymonlite.sh with aim of providing as much stats output as possible without revealing any private server sensitive information.

Thus mysqlmymonlite.sh was born and is used mainly for vBulletin server optimisation requests on public forums providing nginx, apache, litespeed web server, openlitespeed web server, mysql, cpu, memory, disk usage stats and general overview of server status in order to understand a vB client's server environment and loads. All this info takes less than <12 seconds to gather once the script is run.

Changes of note:

mysqlmymonlite.sh 0.4.2 adds MySQL 5.5+ Performance Schema output support.
mysqlmymonlite.sh 0.4.8 updated to support OpenLiteSpeed web server. Sample output stats.
mysqlmymonlite.sh 0.5.2 add WEBONLY option
mysqlmymonlite.sh 0.5.3 fix mysqltuner --forcemem prompt when root password set & update mysqltuner.pl to 1.4.0 modified version
mysqlmymonlite.sh 0.5.4 update for defaults-extra-file support for mysql 5.6 & mysqltuner.pl 1.5.1 with MariaDB 10 and Aria Engine support
mysqlmymonlite.sh 0.5.5 May 3, 2017: update mysqltuner.pl 1.7.1 & nginx.conf settings inspection/display
mysqlmymonlite.sh 0.5.6 September 19, 2018: improve nginx.conf detection & fix WHM/cPanel compatibility
mysqlmymonlite.sh 0.5.7 October 25, 2018: fix cpanel/WHM incorrect detection for Apache existence when LiteSpeed running

How to use mysqlmymonlite.sh ?

You'll need ssh telnet and root user access. Read the included zip file's readme.txt file carefully. From v0.4.0 onwards, there's 2 ways to configure your settings. Either by editing mysqlmymonlite.sh itself or the included config.ini to enter MySQL server's my.cnf location, root username and password details:


    MYCNF='/etc/my.cnf'
    USER='yourmysqlrootusername'
    PASS='yourmysqlrootpassword'

Upload mysqlmymonlite.sh (and if needed the optional config.ini) to server i.e. /root/mysqlmymonlite.sh (and /root/config.ini if needed)

Type the following in SSH2 telnet as root user:


    cd /root
    chmod +x mysqlmymonlite.sh

To run the script, use the run command below which will save stats to text file named mysqlmymonlite_stats.txt:


    cd /root
    ./mysqlmymonlite.sh run 2>/dev/null > mysqlmymonlite_stats.txt

How to install and use mysqlmymonlite.sh video - best viewed in full screen HD mode.

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


    ./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:


    ./mysqlmymonlite.sh custom

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


    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 [CODE][/CODE] to wrap the output stats for easier reading.

Notes & Tips:

If your SSH2 Telnet client options allow for it you can increase the size of your scroll back buffer size to allow larger amounts of outputted text to be shown via scrolling back and forth.

If you get the following error: mysqlmymonlite.sh: /bin/bash^M: bad interpreter: No such file or directory, you probably edited the mysqlmymonlite.sh file on windows and added additional non-unix characters. You can convert the file to unix format via ssh telnet using command run from directory where mysqlmymonlite.sh is located:


dos2unix mysqlmymonlite.sh

Or use a text editor which can save the file in unix format. I use NoteTab Lite, open file and right click on the title tab for the filename and select 'save format' -> unix. Then continue editing file and saving it.

NoteTab Lite save file as Unix format in windows

Download mysqlmymonlite.sh:

mysqlmymonlite.sh currently is only available for download from the following locations listed below.

Please be careful downloading the script from locations or web sites other than the below listed sites:

mysqlmymon.com
cpanel.net Optimization forums direct link here

Download link: mysqlmymonlite.zip (Latest Version: 0.5.7)

Menu options:

As you can see below, besides the main run option which grabs all the stats, there's a few other options you can explore for vmstat and standalone mysqltuner, mysqlreport.
The showcreate, showindex, vbshowtables options are for MySQL where you can enter a MySQL database name and output to screen or save to text files the database's tables' show create, show index structure and database's table names. Handy when you don't even want to bother loading phpmyadmin or need to compare a database's table creation and index structure - i.e. output to text file 2 databases' index structure and then use a file DIFF compare tool to compare their indexes on each table.
The dblist option just spits out a list of all MySQL databases on your server.

Example output

All sensitive server hostname info has been masked and rewritten to just show the words 'yourhostname' instead of your real hostname making it anonymous. But please double check your output stats before posting online on forums or in public. For instance if you actually set your mysql password in /etc/my.cnf, the output will show that password, so remove it from output before posting publicly.

Below are example output stats gathered by mysqlmymonlite.sh:

mysqlmymonlite.sh command options	`./mysqlmymonlite.sh 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`
Basic Summary Stats	./mysqlmymonlite.sh run ---------------------------- System MySQL monitoring stats mysqlmymonlite.sh - v0.3.4 compiled by George Liu (eva2000) vbtechsupport.com ---------------------------- Report Generated: Tue Apr 3 19:47:44 EEST 2012 ---------------------------- MySQL Uptime: ---------------------------- MySQL server was started 2012-04-02 15:57:34 Uptime: 1 day 3 hours 50 min 9 sec Uptime 100209 Uptime_since_flush_status 100209 Max Used Connections: 41/886 (4.63%) Key Buffer Used: 225.92M/384.00M (58.83%) Current Key Buffer Usage: 81.96M (21.34%) InnoDB Buffer Pool: 8.00M/8.00M (100.00%) Query Cache: 48.73M/64.00M (76.14%) Table Locks Waited: 23.62k Rate: 0.2/s (0.06%) -------------------- Query Cache Limit (bytes): 1048576 Query Cache Min Unit (bytes): 4096 Query Cache Size (bytes): 67108864 Query Cache Free Mem (bytes): 16011136 Query Cache Used Mem (bytes): 51097728 Queries in Query Cache: 1 Query Cache Avg Size (bytes): 51097728 ---------------------------- Hardware Info: ---------------------------- Processors physical = 2, cores = 12, virtual = 24, hyperthreading = yes 24 2800.191 24 Intel(R) Xeon(R) CPU X5660 @ 2.80GHz 24 12288 KB
CPU Top Stats (mpstat & top )	---------------------------- TOP stats ---------------------------- Linux 2.6.18-274.18.1.el5 ((yourserverhostname)) 04/03/2012 07:47:44 PM CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s 07:47:46 PM all 4.68 0.00 0.98 0.00 0.00 0.12 0.00 94.21 2610.00 07:47:46 PM 0 2.50 0.00 1.00 0.00 0.00 3.00 0.00 93.50 2611.00 07:47:46 PM 1 22.89 0.00 2.49 0.00 0.00 0.00 0.00 74.63 0.00 07:47:46 PM 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM 3 6.50 0.00 0.50 0.00 0.00 0.00 0.00 93.00 0.00 07:47:46 PM 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM 5 7.96 0.00 2.49 0.00 0.00 0.00 0.00 89.55 0.00 07:47:46 PM 6 8.96 0.00 1.49 0.00 0.00 0.00 0.00 89.55 0.00 07:47:46 PM 7 6.50 0.00 5.00 0.00 0.00 0.00 0.00 88.50 0.00 07:47:46 PM 8 8.00 0.00 1.50 0.00 0.00 0.00 0.00 90.50 0.00 07:47:46 PM 9 0.50 0.00 0.50 0.00 0.00 0.00 0.00 99.00 0.00 07:47:46 PM 10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM 11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM 12 14.50 0.00 1.50 0.00 0.00 0.00 0.00 84.00 0.00 07:47:46 PM 13 5.97 0.00 2.49 0.00 0.00 0.00 0.00 91.54 0.00 07:47:46 PM 14 1.49 0.00 0.50 0.00 0.00 0.00 0.00 98.01 0.00 07:47:46 PM 15 0.50 0.00 0.50 0.00 0.00 0.00 0.00 99.00 0.00 07:47:46 PM 16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM 17 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM 18 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM 19 7.50 0.00 1.50 0.00 0.00 0.00 0.00 91.00 0.00 07:47:46 PM 20 18.50 0.00 3.00 0.00 0.00 0.00 0.00 78.50 0.00 07:47:46 PM 21 0.50 0.00 0.50 0.00 0.00 0.00 0.00 99.00 0.00 07:47:46 PM 22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM 23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:46 PM CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s 07:47:48 PM all 5.98 0.00 1.19 0.04 0.00 0.35 0.00 92.44 2511.56 07:47:48 PM 0 5.53 0.00 1.01 0.00 0.00 4.02 0.00 89.45 2511.06 07:47:48 PM 1 7.04 0.00 0.50 0.00 0.00 0.00 0.00 92.46 0.00 07:47:48 PM 2 21.39 0.00 4.98 0.00 0.00 0.00 0.00 73.63 0.00 07:47:48 PM 3 1.00 0.00 0.00 0.50 0.00 0.00 0.00 98.51 0.00 07:47:48 PM 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:48 PM 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:48 PM 6 4.50 0.00 2.00 0.00 0.00 0.00 0.00 93.50 0.00 07:47:48 PM 7 4.50 0.00 2.00 0.00 0.00 0.00 0.00 93.50 0.00 07:47:48 PM 8 25.00 0.00 1.50 0.00 0.00 0.00 0.00 73.50 0.00 07:47:48 PM 9 15.50 0.00 1.00 0.00 0.00 0.00 0.00 83.50 0.00 07:47:48 PM 10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:48 PM 11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:48 PM 12 3.50 0.00 1.00 0.50 0.00 2.00 0.00 93.00 0.00 07:47:48 PM 13 6.53 0.00 3.02 0.00 0.00 0.00 0.00 90.45 0.00 07:47:48 PM 14 11.50 0.00 3.00 0.00 0.00 0.00 0.00 85.50 0.00 07:47:48 PM 15 4.50 0.00 1.00 0.00 0.00 0.00 0.00 94.50 0.00 07:47:48 PM 16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:48 PM 17 9.50 0.00 1.00 0.00 0.00 2.00 0.00 87.50 0.00 07:47:48 PM 18 0.50 0.00 0.00 0.00 0.00 0.00 0.00 99.50 0.00 07:47:48 PM 19 8.00 0.00 1.00 0.00 0.00 0.00 0.00 91.00 0.00 07:47:48 PM 20 15.42 0.00 3.98 0.00 0.00 0.00 0.00 80.60 0.00 07:47:48 PM 21 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:48 PM 22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 07:47:48 PM 23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 Average: CPU %user %nice %sys %iowait %irq %soft %steal %idle intr/s Average: all 5.33 0.00 1.08 0.02 0.00 0.24 0.00 93.33 2560.90 Average: 0 4.01 0.00 1.00 0.00 0.00 3.51 0.00 91.48 2561.15 Average: 1 15.00 0.00 1.50 0.00 0.00 0.00 0.00 83.50 0.00 Average: 2 10.72 0.00 2.49 0.00 0.00 0.00 0.00 86.78 0.00 Average: 3 3.74 0.00 0.25 0.25 0.00 0.00 0.00 95.76 0.00 Average: 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 Average: 5 4.00 0.00 1.25 0.00 0.00 0.00 0.00 94.75 0.00 Average: 6 6.73 0.00 1.75 0.00 0.00 0.00 0.00 91.52 0.00 Average: 7 5.50 0.00 3.50 0.00 0.00 0.00 0.00 91.00 0.00 Average: 8 16.50 0.00 1.50 0.00 0.00 0.00 0.00 82.00 0.00 Average: 9 8.00 0.00 0.75 0.00 0.00 0.00 0.00 91.25 0.00 Average: 10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 Average: 11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 Average: 12 9.00 0.00 1.25 0.25 0.00 1.00 0.00 88.50 0.00 Average: 13 6.25 0.00 2.75 0.00 0.00 0.00 0.00 91.00 0.00 Average: 14 6.48 0.00 1.75 0.00 0.00 0.00 0.00 91.77 0.00 Average: 15 2.49 0.00 0.75 0.00 0.00 0.00 0.00 96.76 0.00 Average: 16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 Average: 17 4.75 0.00 0.50 0.00 0.00 1.00 0.00 93.75 0.00 Average: 18 0.25 0.00 0.00 0.00 0.00 0.00 0.00 99.75 0.00 Average: 19 7.75 0.00 1.25 0.00 0.00 0.00 0.00 91.00 0.00 Average: 20 16.96 0.00 3.49 0.00 0.00 0.00 0.00 79.55 0.00 Average: 21 0.25 0.00 0.25 0.00 0.00 0.00 0.00 99.50 0.00 Average: 22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 Average: 23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 0.00 top - 19:47:48 up 48 days, 13:01, 2 users, load average: 2.93, 3.11, 3.32 Tasks: 454 total, 2 running, 451 sleeping, 0 stopped, 1 zombie Cpu0 : 11.1%us, 6.4%sy, 0.0%ni, 80.7%id, 0.3%wa, 0.1%hi, 1.4%si, 0.0%st Cpu1 : 16.1%us, 2.4%sy, 0.0%ni, 81.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 17.4%us, 2.6%sy, 0.0%ni, 79.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 10.3%us, 1.9%sy, 0.0%ni, 87.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 7.0%us, 1.8%sy, 0.0%ni, 91.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu5 : 6.3%us, 1.8%sy, 0.0%ni, 91.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 4.9%us, 1.5%sy, 0.0%ni, 93.6%id, 0.0%wa, 0.0%hi, 0.1%si, 0.0%st Cpu7 : 9.2%us, 1.8%sy, 0.1%ni, 88.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu8 : 18.2%us, 3.1%sy, 0.1%ni, 78.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu9 : 12.9%us, 2.4%sy, 0.1%ni, 84.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu10 : 8.5%us, 1.9%sy, 0.0%ni, 89.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu11 : 6.4%us, 1.7%sy, 0.0%ni, 91.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu12 : 7.8%us, 3.0%sy, 0.0%ni, 89.0%id, 0.1%wa, 0.0%hi, 0.1%si, 0.0%st Cpu13 : 12.5%us, 4.4%sy, 0.0%ni, 83.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu14 : 12.9%us, 4.6%sy, 0.0%ni, 82.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu15 : 8.6%us, 3.4%sy, 0.0%ni, 88.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu16 : 7.6%us, 3.4%sy, 0.0%ni, 89.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu17 : 7.8%us, 3.5%sy, 0.0%ni, 88.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu18 : 6.5%us, 2.3%sy, 0.0%ni, 91.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu19 : 8.6%us, 3.4%sy, 0.1%ni, 87.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu20 : 13.8%us, 4.8%sy, 0.1%ni, 81.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu21 : 10.3%us, 3.9%sy, 0.0%ni, 85.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu22 : 8.0%us, 3.2%sy, 0.0%ni, 88.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu23 : 7.5%us, 3.1%sy, 0.0%ni, 89.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 32949832k total, 20085836k used, 12863996k free, 989924k buffers Swap: 34996216k total, 0k used, 34996216k free, 17522740k cached
Memory Stats (free & psmem.py & meminfo)	total used free shared buffers cached Mem: 32177 19615 12562 0 966 17112 Low: 32177 19615 12562 High: 0 0 0 -/+ buffers/cache: 1536 30640 Swap: 34175 0 34175 MemTotal: 32949832 kB MemFree: 12863484 kB Buffers: 989924 kB Cached: 17522740 kB SwapCached: 0 kB Active: 8837996 kB Inactive: 10450008 kB HighTotal: 0 kB HighFree: 0 kB LowTotal: 32949832 kB LowFree: 12863484 kB SwapTotal: 34996216 kB SwapFree: 34996216 kB Dirty: 72880 kB Writeback: 380 kB AnonPages: 767832 kB Mapped: 32092 kB Slab: 692876 kB PageTables: 23676 kB NFS_Unstable: 0 kB Bounce: 0 kB CommitLimit: 51471132 kB Committed_AS: 1916952 kB VmallocTotal: 34359738367 kB VmallocUsed: 285836 kB VmallocChunk: 34359448739 kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 Hugepagesize: 2048 kB -------------------------- ps_mem.py output: http://www.pixelbeat.org/scripts/ps_mem.py -------------------------- Private + Shared = RAM used Program 112.0 KiB + 26.5 KiB = 138.5 KiB klogd 136.0 KiB + 29.0 KiB = 165.0 KiB init 156.0 KiB + 39.0 KiB = 195.0 KiB syslogd 144.0 KiB + 53.5 KiB = 197.5 KiB portmap 120.0 KiB + 96.5 KiB = 216.5 KiB hald-addon-keyboard.#prelink#.04goSI [deleted] 180.0 KiB + 40.5 KiB = 220.5 KiB brcm_iscsiuio [deleted] 328.0 KiB + 21.5 KiB = 349.5 KiB hald-addon-storage 332.0 KiB + 25.0 KiB = 357.0 KiB dovecot 236.0 KiB + 138.0 KiB = 374.0 KiB mysqld_safe 280.0 KiB + 151.0 KiB = 431.0 KiB rpc.statd 384.0 KiB + 49.5 KiB = 433.5 KiB udevd 436.0 KiB + 43.0 KiB = 479.0 KiB dovecot-auth 388.0 KiB + 165.5 KiB = 553.5 KiB xinetd 516.0 KiB + 96.5 KiB = 612.5 KiB dbus-daemon 636.0 KiB + 64.5 KiB = 700.5 KiB exim 648.0 KiB + 135.0 KiB = 783.0 KiB mysqlmymonlite. 692.0 KiB + 136.5 KiB = 828.5 KiB crond 696.0 KiB + 353.0 KiB = 1.0 MiB pop3-login (2) 740.0 KiB + 380.0 KiB = 1.1 MiB imap-login (2) 916.0 KiB + 413.0 KiB = 1.3 MiB bash (2) 2.2 MiB + 69.5 KiB = 2.3 MiB cpanellogd 2.2 MiB + 1.5 MiB = 3.7 MiB sshd (3) 5.9 MiB + 162.0 KiB = 6.1 MiB queueprocd 6.5 MiB + 426.5 KiB = 6.9 MiB leechprotect 6.8 MiB + 360.0 KiB = 7.1 MiB tailwatchd 10.9 MiB + 86.5 KiB = 11.0 MiB cpsrvd-ssl 13.9 MiB + 198.5 KiB = 14.1 MiB named 15.2 MiB + 239.0 KiB = 15.4 MiB cpdavd 15.6 MiB + 182.0 KiB = 15.8 MiB mrtg 27.3 MiB + 14.8 MiB = 42.0 MiB lfd (3) 66.5 MiB + 9.7 MiB = 76.3 MiB httpd (67) 24.7 MiB + 52.5 MiB = 77.1 MiB spamd (3) 449.6 MiB + 130.0 KiB = 449.7 MiB mysqld --------------------------------- 737.8 MiB ================================= `smem -uk User Count Swap USS PSS RSS dbus 1 132.0K 328.0K 344.0K 688.0K nobody 1 0 692.0K 709.0K 1.1M ntp 1 72.0K 784.0K 952.0K 1.9M nsd 3 1.3M 2.0M 2.1M 2.8M postfix 2 0 1.8M 2.5M 6.1M nginx 1 0 2.6M 3.2M 4.1M root 27 14.4M 23.1M 25.9M 44.8M mysql 1 0 87.9M 88.1M 89.5M`
Disk Space Usage Stats (df)	`---------------------------- Server Disk Usage ---------------------------- Filesystem Size Used Avail Use% Mounted on /dev/mapper/xxx 400G 51G 329G 14% / /dev/sda1 99M 34M 61M 36% /boot tmpfs 16G 0 16G 0% /dev/shm /usr/tmpDSK 3.9G 201M 3.5G 6% /tmp ---------------------------- MySQL datadir disk usage ---------------------------- /var/lib/mysql/ uses 5174248 kilobytes of disk space`
Web Server & PHP Info	---------------------------------- WEB SERVER & PHP Info: ---------------------------------- PHP 5.3.10 (cli) (built: Apr 2 2012 15:49:38) Copyright (c) 1997-2012 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies with the ionCube PHP Loader v4.0.12, Copyright (c) 2002-2011, by ionCube Ltd., and with Zend Guard Loader v3.3, Copyright (c) 1998-2010, by Zend Technologies System => Linux yourserverhostname 2.6.18-274.18.1.el5 #1 SMP Thu Feb 9 12:45:44 EST 2012 x86_64 Build Date => Apr 2 2012 15:49:01 Configure Command => './configure' '--disable-fileinfo' '--disable-phar' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-curl=/opt/curlssl/' '--with-curlwrappers' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-mysqli=/usr/bin/mysql_config' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-pdo-mysql=shared' '--with-pdo-sqlite=shared' '--with-pic' '--with-png-dir=/usr' '--with-sqlite=shared' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr' Configuration File (php.ini) Path \| /usr/local/lib Loaded Configuration File \| /usr/local/lib/php.ini Server API \| Command Line Interface PHP API \| 20090626 Zend Extension Build \| API220090626,NTS PHP Extension Build \| API20090626,NTS DOM/XML API Version \| 20031129 Client API version \| 5.1.61 Client API library version \| 5.1.61 Client API header version \| 5.1.61 Client API version \| 5.1.61
Apache Info (fullstatus / mod_status)	Server Version: Apache/2.2.22 (Unix) mod_ssl/2.2.22 Server Built: Apr 2 2012 15:45:59 Current Time: Tuesday, 03-Apr-2012 19:47:43 EEST Restart Time: Tuesday, 03-Apr-2012 17:56:14 EEST Parent Server Generation: 21 Total accesses: 308093 - Total Traffic: 6.8 GB CPU Usage: u16.91 s6.46 cu772.13 cs0 - 11.9% CPU load 46.1 requests/sec - 1.0 MB/second - 23.2 kB/request 26 requests currently being processed, 45 idle workers Server version: Apache/2.2.22 (Unix) Server built: Apr 2 2012 15:45:59 Cpanel::Easy::Apache v3.11.2 rev9999 Server's Module Magic Number: 20051115:30 Server loaded: APR 1.4.5, APR-Util 1.4.1 Compiled using: APR 1.4.5, APR-Util 1.4.1 Architecture: 64-bit Server MPM: Prefork threaded: no forked: yes (variable process count) Server compiled with.... -D APACHE_MPM_DIR="server/mpm/prefork" -D APR_HAS_SENDFILE -D APR_HAS_MMAP -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled) -D APR_USE_SYSVSEM_SERIALIZE -D APR_USE_PTHREAD_SERIALIZE -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT -D APR_HAS_OTHER_CHILD -D AP_HAVE_RELIABLE_PIPED_LOGS -D DYNAMIC_MODULE_LIMIT=128 -D HTTPD_ROOT="/usr/local/apache" -D SUEXEC_BIN="/usr/local/apache/bin/suexec" -D DEFAULT_PIDLOG="logs/httpd.pid" -D DEFAULT_SCOREBOARD="logs/apache_runtime_status" -D DEFAULT_LOCKFILE="logs/accept.lock" -D DEFAULT_ERRORLOG="logs/error_log" -D AP_TYPES_CONFIG_FILE="conf/mime.types" -D SERVER_CONFIG_FILE="conf/httpd.conf" ------------------------------- From /usr/local/apache/conf/httpd.conf ------------------------------- Timeout 300 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 2 < ifmodule prefork.c > StartServers 20 MinSpareServers 20 MaxSpareServers 40 ServerLimit 512 MaxClients 256 MaxRequestsPerChild 4000 < /ifmodule >
MySQL Report Stats (explained)	---------------------------- mysqlreport output ---------------------------- mysqlreport [found] MySQL 5.1.61 uptime 1 3:50:15 Tue Apr 3 19:47:49 2012 __ Key _________________________________________________________________ Buffer used 225.92M of 384.00M %Used: 58.83 Current 83.07M %Usage: 21.63 Write hit 96.43% Read hit 98.36% __ Questions ___________________________________________________________ Total 94.27M 940.7/s QC Hits 54.32M 542.1/s %Total: 57.62 DMS 34.83M 347.5/s 36.94 Com_ 3.64M 36.3/s 3.86 COM_QUIT 1.46M 14.6/s 1.55 +Unknown 24.35k 0.2/s 0.03 Slow 10 s 8 0.0/s 0.00 %DMS: 0.00 Log: OFF DMS 34.83M 347.5/s 36.94 UPDATE 17.38M 173.5/s 18.44 49.91 SELECT 16.24M 162.1/s 17.23 46.63 INSERT 1.14M 11.4/s 1.21 3.28 REPLACE 34.91k 0.3/s 0.04 0.10 DELETE 26.18k 0.3/s 0.03 0.08 Com_ 3.64M 36.3/s 3.86 set_option 1.95M 19.5/s 2.07 change_db 1.64M 16.3/s 1.74 show_table_ 30.71k 0.3/s 0.03 __ SELECT and Sort _____________________________________________________ Scan 1.57M 15.7/s %SELECT: 9.69 Range 1.53M 15.3/s 9.43 Full join 27.05k 0.3/s 0.17 Range check 0 0/s 0.00 Full rng join 6 0.0/s 0.00 Sort scan 538.15k 5.4/s Sort range 693.75k 6.9/s Sort mrg pass 46.92k 0.5/s __ Query Cache _________________________________________________________ Memory usage 51.79M of 64.00M %Used: 80.92 Block Fragmnt 17.54% Hits 54.32M 542.1/s Inserts 16.00M 159.6/s Insrt:Prune 2.37:1 92.3/s Hit:Insert 3.40:1 __ Table Locks _________________________________________________________ Waited 23.62k 0.2/s %Total: 0.06 Immediate 37.94M 378.5/s __ Tables ______________________________________________________________ Open 64 of 64 %Cache: 100.00 Opened 1.53M 15.2/s __ Connections _________________________________________________________ Max used 41 of 886 %Max: 4.63 Total 1.46M 14.6/s __ Created Temp ________________________________________________________ Disk table 251.79k 2.5/s Table 621.91k 6.2/s Size: 16.0M File 62.75k 0.6/s __ Threads _____________________________________________________________ Running 1 of 4 Cached 5 of 8 %Hit: 97.95 Created 29.98k 0.3/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 333 0.0/s Connects 0 0/s __ Bytes _______________________________________________________________ Sent 291.94G 2.9M/s Received 10.53G 105.1k/s __ InnoDB Buffer Pool __________________________________________________ Usage 8.00M of 8.00M %Used: 100.00 Read hit 100.00% Pages Free 0 %Total: 0.00 Data 471 91.99 %Drty: 0.00 Misc 41 8.01 Latched 0.00 Reads 286.97M 2.9k/s From file 4.89k 0.0/s 0.00 Ahead Rnd 182 0.0/s Ahead Sql 235 0.0/s Writes 133.13k 1.3/s Flushes 13.96k 0.1/s Wait Free 0 0/s __ 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 5.74k 0.1/s Writes 18.21k 0.2/s fsync 8.50k 0.1/s Pending Reads 0 Writes 0 fsync 0 Pages Created 624 0.0/s Read 9.50k 0.1/s Written 13.96k 0.1/s Rows Deleted 767 0.0/s Inserted 27.49k 0.3/s Read 355.53M 3.5k/s Updated 2.31k 0.0/s
MySQL Storage Engine Tables Size (explained)	---------------------------- Total Server MyISAM and InnoDB Size ---------------------------- ************************* 1. row ************************* innodb_tablespace_utilization_perc: 0 total_size_gb: 4.85897333174944 index_size_gb: 1.23662244901061 data_size_gb: 3.62235088273883 innodb_total_size_gb: 0.04461669921875 innodb_data_size_gb: 0.01727294921875 innodb_index_size_gb: 0.02734375 myisam_total_size_gb: 4.80398430302739 myisam_data_size_gb: 3.59616817906499 myisam_index_size_gb: 1.2078161239624 perc_index: 25.450282600 perc_data: 74.549717300 innodb_perc_index: 61.285909700 innodb_perc_data: 38.714090200 myisam_perc_index: 25.141966400 myisam_perc_data: 74.858033500 innodb_perc_total_index: 2.211163900 innodb_perc_total_data: 0.476843600 myisam_perc_total_index: 97.670564200 myisam_perc_total_data: 99.277190200
MySQL Server Variables Output (excerpt) (5.1 variables & 5.5 variables)	+---------------------------+----------------+ \| Variable_name \| Value \| +---------------------------+----------------+ \| auto_increment_increment \| 1 \| \| auto_increment_offset \| 1 \| \| autocommit \| ON \| \| automatic_sp_privileges \| ON \| \| back_log \| 50 \| \| basedir \| / \| \| big_tables \| OFF \| \| binlog_cache_size \| 32768 \| \| binlog_direct_non_transactional_updates \| OFF \| \| binlog_format \| STATEMENT \| \| bulk_insert_buffer_size \| 8388608 \| \| character_set_client \| utf8 \| \| character_set_connection \| utf8 \| \| character_set_database \| utf8 \| \| character_set_filesystem \| binary \| \| character_set_results \| utf8 \| \| character_set_server \| utf8 \| \| character_set_system \| utf8 \| \| version \| 5.1.61 \| \| version_comment \| MySQL Community Server (GPL) \| \| version_compile_machine \| x86_64 \| \| version_compile_os \| unknown-linux-gnu \| \| wait_timeout \| 90 \| \| warning_count \| 0 \| +---------------------------+----------------+
MySQL Server Extended Status Output (excerpt) (5.5 status & 5.1 status)	+-----------------------------------+--------------+ \| Variable_name \| Value \| +-----------------------------------+--------------+ \| Aborted_clients \| 333 \| \| Aborted_connects \| 0 \| \| Binlog_cache_disk_use \| 0 \| \| Binlog_cache_use \| 0 \| \| Bytes_received \| 10531956822 \| \| Bytes_sent \| 291945025050 \| \| Com_admin_commands \| 2259 \| \| Key_blocks_not_flushed \| 0 \| \| Key_blocks_unused \| 318866 \| \| Key_blocks_used \| 231337 \| \| Key_read_requests \| 3654734955 \| \| Key_reads \| 59906439 \| \| Key_write_requests \| 73291882 \| \| Key_writes \| 2618709 \| \| Last_query_cost \| 0.000000 \| \| Max_used_connections \| 41 \| \| Not_flushed_delayed_rows \| 0 \|
InnoDB Table Status Output (5.1 status & 5.5 status)	---------------------------- INNODB Status ---------------------------- ************************* 1. row ************************* Type: InnoDB Name: Status: ===================================== 120403 19:47:50 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 30 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1756, signal count 1756 Mutex spin waits 0, rounds 2043, OS waits 32 RW-shared spins 3453, OS waits 1709; RW-excl spins 16, OS waits 14 ------------ TRANSACTIONS ------------ Trx id counter 0 5475152 Purge done for trx's n:o < 0 5475137 undo n:o < 0 0 History list length 23 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 24583, OS thread id 1183172928 MySQL thread id 1461464, query id 94274462 localhost root show engine innodb status -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 5835 OS file reads, 18209 OS file writes, 8499 OS fsyncs 3.10 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 5, seg size 7, 126 inserts, 126 merged recs, 116 merges Hash table size 17393, node heap has 21 buffer(s) 0.10 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 2383962618 Log flushed up to 0 2383962618 Last checkpoint at 0 2383962618 0 pending log writes, 0 pending chkp writes 5334 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 20662242; in additional pool allocated 972544 Dictionary memory allocated 215600 Buffer pool size 512 Free buffers 0 Database pages 491 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 9595, created 624, written 13959 3.10 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 955 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 24583, id 1181575488, state: sleeping Number of rows inserted 27486, updated 2305, deleted 767, read 355527089 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 6.67 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================
MySQL Error Log (5.1 error log & 5.5 error log)	---------------------------- MySQL Error Log ---------------------------- 120402 15:57:33 [Note] /usr/sbin/mysqld: Shutdown complete 120402 15:57:33 mysqld_safe mysqld from pid file /var/lib/mysql/yourserverhostname.pid ended 120402 15:57:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120402 15:57:34 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 120402 15:57:34 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 120402 15:57:34 [Warning] option 'table_cache': unsigned value 5242880 adjusted to 524288 120402 15:57:34 [Warning] Changed limits: max_open_files: 1024 max_connections: 886 table_cache: 64 120402 15:57:34 [Note] Plugin 'FEDERATED' is disabled. 120402 15:57:34 InnoDB: Initializing buffer pool, size = 8.0M 120402 15:57:34 InnoDB: Completed initialization of buffer pool 120402 15:57:34 InnoDB: Started; log sequence number 0 2354163553 120402 15:57:34 [Note] Event Scheduler: Loaded 0 events 120402 15:57:34 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.61' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) Report Complete: Tue Apr 3 19:47:50 EEST 2012 ----------------------------
Nginx server configuration	--------------- You are running Nginx --------------- nginx version: nginx/1.1.18 built by gcc 4.4.6 20110731 (Red Hat 4.4.6-3) (GCC) TLS SNI support enabled configure arguments: --sbin-path=/usr/local/sbin --conf-path=/usr/local/nginx/conf/nginx.conf --with-http_ssl_module --with-http_gzip_static_module --with-http_stub_status_module --with-http_sub_module --with-http_addition_module --with-http_secure_link_module --with-http_flv_module --with-http_realip_module --add-module=../ngx-fancyindex-ngx-fancyindex --add-module=../ngx_cache_purge-1.4 --add-module=../nginx-accesskey-2.0.3 --with-openssl=../openssl-1.0.0e --with-openssl-opt=enable-tlsext user nginx nginx; worker_processes 1; worker_rlimit_nofile 51200; worker_connections 32768; use epoll; sendfile on; keepalive_timeout 10; gzip on; gzip_vary on; gzip_disable "MSIE [1-6]\."; gzip_static on; gzip_min_length 1100; gzip_buffers 32 8k; gzip_http_version 1.0; gzip_comp_level 5; gzip_proxied any; gzip_types text/plain text/css text/javascript text/xml application/x-javascript application/xml application/xml+rss; client_body_buffer_size 256k; client_body_in_file_only off; client_body_timeout 60s; client_header_buffer_size 256k; client_header_timeout 20s; client_max_body_size 128m; large_client_header_buffers 4 256k; proxy_temp_path /tmp/nginx_proxy/;
Litespeed web server stats (4 cpu license)	.rtreport ------------------------------------------------------------- VERSION: LiteSpeed Web Server/Enterprise/4.1.8 UPTIME: 00:07:34 BPS_IN: 0, BPS_OUT: 0, SSL_BPS_IN: 0, SSL_BPS_OUT: 0 MAXCONN: 2000, PLAINCONN: 0, AVAILCONN: 2000, IDLECONN: 0, MAXSSL_CONN: 500, SSLCONN: 0, AVAILSSL: 500 REQ_RATE REQ_PROCESSING: 0 REQ_PER_SEC: 0 TOT_REQS: 2 CACHE_HITS_PER_SEC: 0 TOTAL_CACHE_HITS: 0 ------------------------------------------------------------- .rtreport.2 ------------------------------------------------------------- VERSION: LiteSpeed Web Server/Enterprise/4.1.8 UPTIME: 00:07:34 BPS_IN: 3, BPS_OUT: 5, SSL_BPS_IN: 0, SSL_BPS_OUT: 0 MAXCONN: 2000, PLAINCONN: 16, AVAILCONN: 1984, IDLECONN: 16, MAXSSL_CONN: 500, SSLCONN: 0, AVAILSSL: 500 REQ_RATE REQ_PROCESSING: 0 REQ_PER_SEC: 7.4 TOT_REQS: 1367 CACHE_HITS_PER_SEC: 0 TOTAL_CACHE_HITS: 0 [lsphp5]: CMAXCONN: 40, EMAXCONN: 40, POOL_SIZE: 3, [lsphp5]: INUSE_CONN: 0, IDLE_CONN: 3, [lsphp5]: WAITQUE_DEPTH: 0, REQ_PER_SEC: 0.9, TOT_REQS: 351 ------------------------------------------------------------- .rtreport.3 ------------------------------------------------------------- VERSION: LiteSpeed Web Server/Enterprise/4.1.8 UPTIME: 00:07:34 BPS_IN: 0, BPS_OUT: 0, SSL_BPS_IN: 0, SSL_BPS_OUT: 0 MAXCONN: 2000, PLAINCONN: 0, AVAILCONN: 2000, IDLECONN: 0, MAXSSL_CONN: 500, SSLCONN: 0, AVAILSSL: 500 REQ_RATE REQ_PROCESSING: 0 REQ_PER_SEC: 0 TOT_REQS: 0 CACHE_HITS_PER_SEC: 0 TOTAL_CACHE_HITS: 0 ------------------------------------------------------------- .rtreport.4 ------------------------------------------------------------- VERSION: LiteSpeed Web Server/Enterprise/4.1.8 UPTIME: 00:07:34 BPS_IN: 0, BPS_OUT: 0, SSL_BPS_IN: 0, SSL_BPS_OUT: 0 MAXCONN: 2000, PLAINCONN: 0, AVAILCONN: 2000, IDLECONN: 0, MAXSSL_CONN: 500, SSLCONN: 0, AVAILSSL: 500 REQ_RATE REQ_PROCESSING: 0 REQ_PER_SEC: 0 TOT_REQS: 0 CACHE_HITS_PER_SEC: 0 TOTAL_CACHE_HITS: 0 ------------------------------------------------------------- ------------------------------------------------ Litespeed Server & LSAPI PHP Info: ------------------------------------------------ Litespeed web server version: 4.1.12 WHM / Cpanel version: 11.32.2.25 LSPHP phpSuExec status: < phpSuExec >0 < phpSuExecMaxConn >20 WHM's PHP Handler config: /usr/local/cpanel/bin/rebuild_phpconf --current Available handlers: dso cgi none DEFAULT PHP: 5 PHP4 SAPI: none PHP5 SAPI: dso SUEXEC: enabled RUID2: not installed PHP 5.3.10 (litespeed) (built: Feb 7 2012 03:02:29) Copyright (c) 1997-2004 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies
mysqltuner option (modified version)	./mysqlmymonlite.sh mysqltuner ------------------------------------------------------------- System MySQL monitoring stats mysqlmymonlite.sh - 0.5.4 mysqlmymon.com compiled by George Liu (eva2000) vbtechsupport.com ------------------------------------------------------------- Report Generated: Tue Aug 25 14:30:27 UTC 2015 ------------------------------------------------- mysqltuner output ------------------------------------------------- >> MySQLTuner 1.5.1 - Major Hayden >> 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 [OK] Currently running supported MySQL version 10.0.21-MariaDB [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MyISAM [!!] InnoDB is enabled but isn't being used [OK] Total fragmented tables: 0 -------- Security Recommendations ------------------------------------------- [OK] There is no anonymous account in all database users [OK] All database users have passwords assigned [!!] There is not basic password file list ! -------- Performance Metrics ------------------------------------------------- [--] Up for: 14d 17h 58m 16s (1K q [0.001 qps], 175 conn, TX: 1M, RX: 392K) [--] Reads / Writes: 81% / 19% [--] Binary logging is disabled [--] Total buffers: 152.0M global + 1.0M per thread (300 max threads) [OK] Maximum reached memory usage: 153.0M (14.94% of installed RAM) [OK] Maximum possible memory usage: 461.4M (45.06% of installed RAM) [OK] Slow queries: 0% (0/1K) [OK] Highest usage of available connections: 0% (1/300) [OK] Aborted connections: 0.00% (0/175) [OK] Query cache efficiency: 23.6% (246 cached / 1K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 19 sorts) [!!] Temporary tables created on disk: 40% (60 on disk / 147 total) [OK] Thread cache hit rate: 99% (1 created / 175 connections) [OK] Table cache hit rate: 282% (82 open / 29 opened) [OK] Open file limit used: 0% (58/8K) [OK] Table locks acquired immediately: 100% (711 immediate / 711 locks) -------- MyISAM Metrics ----------------------------------------------------- [!!] Key buffer used: 18.3% (6M used / 33M cache) [OK] Key buffer size / total MyISAM indexes: 32.0M/122.0K [OK] Read Key buffer hit rate: 99.6% (1K cached / 7 reads) [!!] Write Key buffer hit rate: 58.9% (457 cached / 188 writes) -------- InnoDB Metrics ----------------------------------------------------- [--] InnoDB is disabled. [!!] InnoDB Storage engine is disabled. InnoDB is the default storage engine -------- AriaDB Metrics ----------------------------------------------------- [--] AriaDB is disabled. -------- Replication Metrics ------------------------------------------------- [--] No replication slave(s) for this server. [--] This is a standalone server.. -------- Recommendations ----------------------------------------------------- General recommendations: Add skip-innodb to MySQL configuration to disable InnoDB When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Variables to adjust: tmp_table_size (> 32M) max_heap_table_size (> 32M) Report Complete: Tue Aug 25 14:30:27 UTC 2015 ----------------------------