Latest Version: 0.5.2


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:

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:

Keeping mysqlmymonlite.sh up to date:

Currently, 2 methods to get notified for mysqlmymonlite.sh updates.

  1. via Twitter at https://twitter.com/vbtechsupport
  2. mysqlmymonlite.sh has it's own Google+ Page for script updates too

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:

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:

  1. vBulletin.com's private Server Configuration forum for vBulletin licensed customers
  2. mysqlmymon.com and vbtechsupport.com web sites
  3. cpanel.net Optimization forums direct link here

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


Menu options:


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 - v0.3.4
compiled by George Liu (eva2000) vbtechsupport.com
----------------------------

Report Generated:
Wed Apr 4 00:07:54 EEST 2012

-------------------------------------------------
mysqltuner output
-------------------------------------------------
mysqltuner.pl [found]

 >>  MySQLTuner 1.2.0 mod - 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] Logged in using credentials passed on the command line

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.61
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
[--] Data in MyISAM tables: 3G (Tables: 2035)
[--] Data in InnoDB tables: 17M (Tables: 29)
[--] Data in MEMORY tables: 9M (Tables: 8)
[!!] Total fragmented tables: 256

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 8h 10m 20s (110M q [954.711 qps], 1M conn, TX: 343B, RX: 12B)
[--] Reads / Writes: 47% / 53%
[--] Total buffers: 474.0M global + 12.4M per thread (886 max threads)
[OK] Maximum possible memory usage: 11.2G (35% of installed RAM)
[OK] Slow queries: 0% (8/110M)
[OK] Highest usage of available connections: 4% (41/886)
[OK] Key buffer size / total MyISAM indexes: 384.0M/1.2G
[OK] Key buffer hit rate: 98.3% (4B cached / 71M reads)
[OK] Query cache efficiency: 76.4% (63M cached / 82M selects)
[!!] Query cache prunes per day: 5956165
[OK] Sorts requiring temporary tables: 3% (53K temp sorts / 1M sorts)
[!!] Joins performed without indexes: 33185
[!!] Temporary tables created on disk: 29% (299K on disk / 1M total)
[OK] Thread cache hit rate: 97% (35K created / 1M connections)
[!!] Table cache hit rate: 0% (64 open / 1M opened)
[OK] Open file limit used: 11% (115/1K)
[OK] Table locks acquired immediately: 99% (44M immediate / 44M locks)
[!!] InnoDB data size / buffer pool: 17.7M/8.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Adjust your join queries to always utilize indexes
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Increase table_cache gradually to avoid file descriptor limits

Variables to adjust:
    query_cache_size (> 64M)
    join_buffer_size (> 128.0K, or always use indexes with joins)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    table_cache (> 64)
    innodb_buffer_pool_size (>= 17M, innodb data size is larger buffer size, 
set innodb_buffer_pool_size appropriately)


Report Complete:
Wed Apr 4 00:07:54 EEST 2012
----------------------------