mysqlmymonlite.sh – gather MySQL & Apache, Nginx web server information stats in less than 12 seconds !

Mysqlmymonlite.sh is a simple bash shell script which allows the end user to gather alot of MySQL and Apache, Nginx web server related information for troubleshooting or optimization purposes. It literally takes less than 12 seconds to obtain all the information I listed below for ./mysqlmymonlite.sh run as an example. The script also incorporates mysqlreport script as well.

vBulletin forum clients often have to have their vBulletin web servers tuned or optimized to meet their growing needs. Often I get hired for more extensive optimization tuning as such. But vBulletin also as courtesy, provides basic advice only for their clients in private Server Configuration support forum. The problem is it takes quite alot of time for non-tech savy Linux users to gather all the information that is required. Hence, I decided to write mysqlmymonlite.sh script to make it easier for vBulletin customers to gather this required information. You’d need to be a licensed vBulletin customer to be able to download the script right now and it’s still early days in the script’s development.

mysqlmymonlite.sh will only be made available for download on vbtechsupport.com and vbulletin.com support forums right now. Please be careful when running the script if downloading off other web sites

Updates:

  • From mysqlmymonlite.sh CentOS/RHEL v0.2.1, CentOS/RHEL v0.2.1 WHM and Debian v0.2.3, MASKDB option added to hide actual databases’ names for privacy reasons to allow public use of mysqlmymonlite.sh script.
  • From mysqlmymonlite.sh v0.1.6 and higher, all sensitive server hostname info has been masked and rewritten to just show the words ‘yourhostname’ instead of your real hostname making it anonymous for vB clients who’s request basic server optimisation request & advice in vBulletin’s private Server Configuration support forum wants their actual server hostname hidden.
  • I’ve made various improvements for Apache and Nginx server and config detection as well as added Apache mod_status/fullstatus output to the list of information gathered by mysqlmymonlite.sh.
  • Added EXCLUDEDB option so you can list which databases you want excluded from PER TABLE output for index, data size, storage engine type etc.

 

 

Compatible Platforms

 

Original mysqlmymonlite.sh was written and tested on CentOS 5.5 64bit OS, but I have also made versions for CentOS/RHEL with WHM/Cpanel control panels as well the latest addition, a Debian version tested on Debian 6.0.2.1 Squeeze. All versions tested on MariaDB 5.2.7 64bit MySQL server base, MySQL 5.0.92 and MySQL 5.5.13 so far. You basically edit 3 variables in the script then run or output it to a text file.

Example output

Here’s example output on virtualbox based CentOS 6.2 64bit test server with mysqlmymonlite.sh v0.3.2.

./mysqlmymonlite.sh

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

[root@centos62svr2 tools]# ./mysqlmymonlite.sh run
 
----------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - v0.3.2
compiled by George Liu (eva2000) vbtechsupport.com
----------------------------
 
Report Generated:
Wed Feb 15 10:23:14 EST 2012
 
----------------------------
MySQL Uptime:
----------------------------
MySQL server was started 2012-02-15 01:29:56
Uptime: 8 hours 53 min 18 sec  
Uptime 31998
Uptime_since_flush_status 31998
 
Max Used Connections:      1/500 (0.20%)
Key Buffer Used:           0/128.00M (0.00%)
Current Key Buffer Usage:  23.34M (18.24%)
Query Cache:               17.38k/128.00M (0.01%)
Table Locks Waited:        0 Rate: 0/s (0.00%)
--------------------
Query Cache Limit (bytes): 1048576
Query Cache Min Unit (bytes): 4096
Query Cache Size (bytes): 134217728
Query Cache Free Mem (bytes): 134199936
Query Cache Used Mem (bytes): 17792
Queries in Query Cache: 1
Query Cache Avg Size (bytes): 17792
 
----------------------------
Hardware Info:
----------------------------
Processors physical = 1, cores = 2, virtual = 2, hyperthreading = no
      2  2162.246
      2  Intel(R) Xeon(R) CPU           W3540  @ 2.93GHz
      2  6144 KB
 
 
----------------------------
TOP stats
----------------------------
 
Linux 2.6.32-220.2.1.el6.x86_64 ((yourserverhostname))  02/15/2012      _x86_64_        (2 CPU)
 
10:23:14 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
10:23:16 AM  all    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
10:23:16 AM    0    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
10:23:16 AM    1    0.00    0.00    0.54    0.00    0.00    0.00    0.00    0.00   99.46
 
10:23:16 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
10:23:18 AM  all    0.00    0.00    0.25    0.00    0.00    0.00    0.00    0.00   99.75
10:23:18 AM    0    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
10:23:18 AM    1    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
 
Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest   %idle
Average:     all    0.00    0.00    0.13    0.00    0.00    0.00    0.00    0.00   99.87
Average:       0    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
Average:       1    0.00    0.00    0.26    0.00    0.00    0.00    0.00    0.00   99.74
 
top - 10:23:19 up  8:54,  1 user,  load average: 0.00, 0.06, 0.06
Tasks: 111 total,   1 running, 110 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.0%us,  0.1%sy,  0.0%ni, 99.7%id,  0.2%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   1020648k total,   684868k used,   335780k free,   109700k buffers
Swap:  3047416k total,        0k used,  3047416k free,   193092k cached
 
  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                              
 
 3095 apache    20   0  465m 8212 2464 S  0.0  0.8   0:00.22 httpd                                                                                
 3096 apache    20   0  465m 7876 2140 S  0.0  0.8   0:00.22 httpd                                                                                
 3097 apache    20   0  465m 8028 2292 S  0.0  0.8   0:00.24 httpd                                                                                
 3098 apache    20   0  465m 8028 2292 S  0.0  0.8   0:00.22 httpd                                                                                
 3099 apache    20   0  465m 8028 2292 S  0.0  0.8   0:00.22 httpd                                                                                
 3100 apache    20   0  465m 8028 2292 S  0.0  0.8   0:00.23 httpd                                                                                
 3101 apache    20   0  465m 8028 2292 S  0.0  0.8   0:00.22 httpd                                                                                
 3102 apache    20   0  465m 7876 2140 S  0.0  0.8   0:00.22 httpd                                                                                
 3524 root      20   0 97852 4008 3072 S  0.0  0.4   0:00.22 sshd                                                                                 
 3527 root      20   0  105m 1884 1472 S  0.0  0.2   0:00.03 bash                                                                                 
 5352 root      20   0  104m 1744 1136 S  0.0  0.2   0:00.01 mysqlmymonlite.                                                                      
 5511 root      20   0 15084 1076  824 R  0.0  0.1   0:00.00 top                                                                                  
 
 
             total       used       free     shared    buffers     cached
Mem:           996        668        327          0        107        188
Low:           996        668        327
High:            0          0          0
-/+ buffers/cache:        373        623
Swap:         2975          0       2975
 
MemTotal:        1020648 kB
MemFree:          335780 kB
Buffers:          109700 kB
Cached:           193092 kB
SwapCached:            0 kB
Active:           267572 kB
Inactive:         130528 kB
Active(anon):      95512 kB
Inactive(anon):      192 kB
Active(file):     172060 kB
Inactive(file):   130336 kB
Unevictable:           0 kB
Mlocked:               0 kB
SwapTotal:       3047416 kB
SwapFree:        3047416 kB
Dirty:                56 kB
Writeback:             0 kB
AnonPages:         95348 kB
Mapped:            19316 kB
Shmem:               400 kB
Slab:             257184 kB
SReclaimable:     203004 kB
SUnreclaim:        54180 kB
KernelStack:        1016 kB
PageTables:         6868 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:     3557740 kB
Committed_AS:     897008 kB
VmallocTotal:   34359738367 kB
VmallocUsed:       28704 kB
VmallocChunk:   34359698932 kB
HardwareCorrupted:     0 kB
AnonHugePages:     65536 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
DirectMap4k:        8128 kB
DirectMap2M:     1040384 kB
 
--------------------------
ps_mem.py output:
http://www.pixelbeat.org/scripts/ps_mem.py
--------------------------
 Private  +   Shared  =  RAM used       Program 
 
168.0 KiB +  25.5 KiB = 193.5 KiB       acpid
160.0 KiB +  55.0 KiB = 215.0 KiB       abrt-dump-oops
200.0 KiB +  38.5 KiB = 238.5 KiB       atd
156.0 KiB +  93.5 KiB = 249.5 KiB       hald-addon-acpi
272.0 KiB +  55.5 KiB = 327.5 KiB       rpc.idmapd
192.0 KiB + 137.5 KiB = 329.5 KiB       hald-addon-input
208.0 KiB + 136.0 KiB = 344.0 KiB       hald-runner
228.0 KiB + 123.0 KiB = 351.0 KiB       abrtd
292.0 KiB +  85.5 KiB = 377.5 KiB       rpcbind
384.0 KiB +  39.0 KiB = 423.0 KiB       auditd
368.0 KiB + 107.0 KiB = 475.0 KiB       rpc.statd
284.0 KiB + 219.5 KiB = 503.5 KiB       mysqld_safe
460.0 KiB +  60.0 KiB = 520.0 KiB       memcached
412.0 KiB + 135.0 KiB = 547.0 KiB       mingetty (6)
556.0 KiB +  15.5 KiB = 571.5 KiB       dhclient
544.0 KiB +  39.5 KiB = 583.5 KiB       dbus-daemon
552.0 KiB + 109.0 KiB = 661.0 KiB       init
684.0 KiB +  58.5 KiB = 742.5 KiB       crond
696.0 KiB + 100.0 KiB = 796.0 KiB       ntpd
616.0 KiB + 204.5 KiB = 820.5 KiB       mysqlmymonlite.
608.0 KiB + 230.5 KiB = 838.5 KiB       bash
772.0 KiB +  75.0 KiB = 847.0 KiB       rsyslogd
268.0 KiB + 710.5 KiB = 978.5 KiB       udevd (3)
  1.6 MiB +  29.5 KiB =   1.6 MiB       haproxy
  2.6 MiB + 173.5 KiB =   2.7 MiB       hald
  2.9 MiB + 166.5 KiB =   3.1 MiB       qpidd
  2.3 MiB + 818.5 KiB =   3.1 MiB       sshd (2)
  3.0 MiB + 422.0 KiB =   3.4 MiB       sendmail.sendmail (2)
  6.2 MiB +   8.3 MiB =  14.5 MiB       httpd (9)
 72.8 MiB + 166.5 KiB =  73.0 MiB       mysqld
---------------------------------
                        113.1 MiB
=================================
 
 Private  +   Shared  =  RAM used       Program 
 
 
----------------------------
Server Disk Usage
----------------------------
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_centos62-lv_root
                       13G  2.6G  9.3G  22% /
tmpfs                 499M     0  499M   0% /dev/shm
/dev/sda1             485M   51M  409M  12% /boot
 
----------------------------
MySQL datadir disk usage
----------------------------
/var/lib/mysql/ uses 1056 kilobytes of disk space
 
----------------------------
ulimit -aH
----------------------------
core file size          (blocks, -c) unlimited
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 7831
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 65536
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) unlimited
cpu time               (seconds, -t) unlimited
max user processes              (-u) 7831
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
 
----------------------------
WEB SERVER & PHP Info:
----------------------------
PHP 5.3.10 (cli) (built: Feb 13 2012 02:20:28) 
Copyright (c) 1997-2012 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies
 
System => Linux yourserverhostname 2.6.32-220.2.1.el6.x86_64 #1 SMP Fri Dec 23 02:21:33 CST 2011 x86_64
Build Date => Feb 13 2012 02:20:04
 
Configure Command =>  './configure'  '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' 
'--target=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' 
'--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' 
'--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' 
'--infodir=/usr/share/info' '--with-libdir=lib64' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' 
'--disable-debug' '--with-pic' '--disable-rpath' '--with-bz2' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' 
'--with-png-dir=/usr' '--with-xpm-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' 
'--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-zlib' '--with-layout=GNU' '--enable-mbstring' 
'--enable-soap' '--enable-exif' '--enable-ftp' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' 
'--enable-sysvmsg' '--with-kerberos' '--enable-ucd-snmp-hack' '--enable-shmop' '--enable-calendar' 
'--with-libxml-dir=/usr' '--enable-xml' '--enable-dom' '--enable-dba' '--enable-xmlreader' '--enable-xmlwriter' 
'--with-sqlite3' '--enable-phar' '--enable-fileinfo' '--with-mysql=/usr' '--with-mysqli=/usr/bin/mysql_config' 
'--with-jpeg-dir=/usr' '--with-kerberos' '--with-mcrypt' '--with-gd' '--with-curl' '--with-curlwrappers' 
'--with-apxs2=/usr/sbin/apxs'
 
Configuration File (php.ini) Path | /etc
Loaded Configuration File | /etc/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.3.3-MariaDB-rc
Client API library version | 5.3.3-MariaDB-rc
Client API header version | 5.3.3-MariaDB-rc
Phar API version | 1.1.1
 
display_errors | Off | Off
error_log | no value | no value
extension_dir | /usr/lib64/20090626 | /usr/lib64/20090626
file_uploads | On | On
log_errors | On | On
log_errors_max_len | 1024 | 1024
magic_quotes_gpc | Off | Off
magic_quotes_sybase | Off | Off
max_execution_time | 0 | 0
max_file_uploads | 20 | 20
memory_limit | 256M | 256M
open_basedir | no value | no value
post_max_size | 15M | 15M
realpath_cache_size | 2048k | 2048k
realpath_cache_ttl | 300 | 300
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i 
sql.safe_mode | Off | Off
upload_max_filesize | 15M | 15M
upload_tmp_dir | no value | no value
sqlite3.extension_dir | no value | no value
safe_mode_allowed_env_vars | PHP_ | PHP_
safe_mode_protected_env_vars | LD_LIBRARY_PATH | LD_LIBRARY_PATH
 
cURL support | enabled
cURL Information | 7.19.7
ZLib Version | 1.2.3
GD Support | enabled
GD Version | bundled (2.0.34 compatible)
FreeType Support | enabled
FreeType Linkage | with freetype
FreeType Version | 2.3.11
GIF Read Support | enabled
GIF Create Support | enabled
JPEG Support | enabled
libJPEG Version | 6b
PNG Support | enabled
libPNG Version | 1.2.46
WBMP Support | enabled
libXML support | active
libXML Compiled Version | 2.7.6
libXML Loaded Version | 20706
libXML streams | enabled
PCRE (Perl Compatible Regular Expressions) Support | enabled
PCRE Library Version | 8.12 2011-01-15
Soap Client | enabled
Soap Server | enabled
ZLib Support | enabled
 
apc
APC Support | enabled
APC Debugging | Disabled
apc.cache_by_default | On | On
apc.canonicalize | On | On
apc.coredump_unmap | Off | Off
apc.enable_cli | On | On
apc.enabled | On | On
apc.file_md5 | Off | Off
apc.file_update_protection | 2 | 2
apc.filters | no value | no value
apc.gc_ttl | 600 | 600
apc.include_once_override | Off | Off
apc.lazy_classes | Off | Off
apc.lazy_functions | Off | Off
apc.max_file_size | 1M | 1M
apc.mmap_file_mask | no value | no value
apc.num_files_hint | 1000 | 1000
apc.preload_path | no value | no value
apc.report_autofilter | Off | Off
apc.rfc1867 | Off | Off
apc.rfc1867_freq | 0 | 0
apc.rfc1867_name | APC_UPLOAD_PROGRESS | APC_UPLOAD_PROGRESS
apc.rfc1867_prefix | upload_ | upload_
apc.rfc1867_ttl | 3600 | 3600
apc.serializer | default | default
apc.shm_segments | 1 | 1
apc.shm_size | 256M | 256M
apc.slam_defense | On | On
apc.stat | On | On
apc.stat_ctime | Off | Off
apc.ttl | 7200 | 7200
apc.use_request_time | On | On
apc.user_entries_hint | 4096 | 4096
apc.user_ttl | 3600 | 3600
apc.write_lock | On | On
 
memcache
memcache support | enabled
memcache.allow_failover | 1 | 1
memcache.chunk_size | 32768 | 32768
memcache.compress_threshold | 20000 | 20000
memcache.default_port | 11211 | 11211
memcache.hash_function | crc32 | crc32
memcache.hash_strategy | consistent | consistent
memcache.lock_timeout | 15 | 15
memcache.max_failover_attempts | 20 | 20
memcache.protocol | ascii | ascii
memcache.redundancy | 1 | 1
memcache.session_redundancy | 2 | 2
Registered save handlers | files user sqlite memcache 
 
Server version: Apache/2.2.21 (Unix)
Server built:   Sep 18 2011 07:37:12
Servers Module Magic Number: 20051115:30
Server loaded:  APR 1.3.9, APR-Util 1.3.9
Compiled using: APR 1.3.9, APR-Util 1.3.9
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="/etc/httpd"
 -D SUEXEC_BIN="/usr/sbin/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"
 
Loaded Modules:
 core_module (static)
 mpm_prefork_module (static)
 http_module (static)
 so_module (static)
 auth_basic_module (shared)
 authn_file_module (shared)
 authn_alias_module (shared)
 authn_default_module (shared)
 authz_host_module (shared)
 authz_user_module (shared)
 authz_groupfile_module (shared)
 authz_default_module (shared)
 include_module (shared)
 log_config_module (shared)
 env_module (shared)
 mime_magic_module (shared)
 expires_module (shared)
 deflate_module (shared)
 headers_module (shared)
 setenvif_module (shared)
 mime_module (shared)
 status_module (shared)
 autoindex_module (shared)
 info_module (shared)
 vhost_alias_module (shared)
 negotiation_module (shared)
 dir_module (shared)
 actions_module (shared)
 userdir_module (shared)
 alias_module (shared)
 rewrite_module (shared)
 cache_module (shared)
 suexec_module (shared)
 cgi_module (shared)
 php5_module (shared)
 rpaf_module (shared)
Syntax OK
 
Compiled in modules:
  core.c
  prefork.c
  http_core.c
  mod_so.c
 
 
-------------------------------
From /etc/httpd/conf/httpd.conf
-------------------------------
Timeout 120
KeepAlive On
MaxKeepAliveRequests 125
KeepAliveTimeout 15
 
StartServers       8
MinSpareServers    5
MaxSpareServers   20
ServerLimit      512
MaxClients       256
MaxRequestsPerChild  4000
</IfModule>
<IfModule prefork.c>
StartServers       8
MinSpareServers    5
MaxSpareServers   20
ServerLimit      512
MaxClients       256
MaxRequestsPerChild  4000
</IfModule>
<IfModule worker.c>
StartServers         2
MaxClients         150
MinSpareThreads     25
MaxSpareThreads     75 
ThreadsPerChild     25
MaxRequestsPerChild  0
</IfModule>
 
----------------------------
mysqlreport output
----------------------------
mysqlreport [found]
MySQL 5.3.3-MariaDB-rc-  uptime 0 8:53:24       Wed Feb 15 10:23:20 2012
 
__ Key _________________________________________________________________
Buffer used         0 of 128.00M  %Used:   0.00
  Current      23.34M            %Usage:  18.24
Write hit       0.00%
Read hit        0.00%
 
__ Questions ___________________________________________________________
Total           1.42k     0.0/s
  COM_QUIT        487     0.0/s  %Total:  34.22
  DMS             484     0.0/s           34.01
  Com_            462     0.0/s           32.47
  -Unknown         10     0.0/s            0.70
Slow 1 s            0       0/s            0.00  %DMS:   0.00  Log: OFF
DMS               484     0.0/s           34.01
  SELECT          484     0.0/s           34.01        100.00
  REPLACE           0       0/s            0.00          0.00
  DELETE            0       0/s            0.00          0.00
  INSERT            0       0/s            0.00          0.00
  UPDATE            0       0/s            0.00          0.00
Com_              462     0.0/s           32.47
  show_variab     189     0.0/s           13.28
  show_tables      64     0.0/s            4.50
  show_databa      39     0.0/s            2.74
 
__ SELECT and Sort _____________________________________________________
Scan              457     0.0/s %SELECT:  94.42
Range               0       0/s            0.00
Full join           0       0/s            0.00
Range check         0       0/s            0.00
Full rng join       0       0/s            0.00
Sort scan          55     0.0/s
Sort range          0       0/s
Sort mrg pass       0       0/s
 
__ Query Cache _________________________________________________________
Memory usage   17.38k of 128.00M  %Used:   0.01
Block Fragmnt 100.00%
Hits                0       0/s
Inserts             1     0.0/s
Insrt:Prune       1:1       0/s
Hit:Insert     0.00:1
 
__ Table Locks _________________________________________________________
Waited              0       0/s  %Total:   0.00
Immediate          21     0.0/s
 
__ Tables ______________________________________________________________
Open               24 of 1000    %Cache:   0.24
Opened             31     0.0/s
 
__ Connections _________________________________________________________
Max used            1 of  500      %Max:   0.20
Total             489     0.0/s
 
__ Created Temp ________________________________________________________
Disk table         16     0.0/s
Table             559     0.0/s    Size:  64.0M
File                0       0/s
 
__ Threads _____________________________________________________________
Running             1 of    1
Cached              0 of  256      %Hit:  99.80
Created             1     0.0/s
Slow                0       0/s
 
__ Aborted _____________________________________________________________
Clients             0       0/s
Connects            0       0/s
 
__ Bytes _______________________________________________________________
Sent            1.18M    36.8/s
Received       73.18k     2.3/s
 
----------------------------
Total Server MyISAM and InnoDB Size
----------------------------
*************************** 1. row ***************************
innodb_tablespace_utilization_perc: NULL
                     total_size_gb: 0.000742611475288868
                     index_size_gb: 0.000153541564941406
                      data_size_gb: 0.000589069910347462
              innodb_total_size_gb: 0
               innodb_data_size_gb: 0
              innodb_index_size_gb: 0
              myisam_total_size_gb: 0.000620541162788868
               myisam_data_size_gb: 0.000528034754097462
              myisam_index_size_gb: 9.25064086914062e-05
                        perc_index: 20.6759
                         perc_data: 79.3241
                 innodb_perc_index: NULL
                  innodb_perc_data: NULL
                 myisam_perc_index: 14.9074
                  myisam_perc_data: 85.0926
           innodb_perc_total_index: 0.0000
            innodb_perc_total_data: 0.0000
           myisam_perc_total_index: 60.2484
            myisam_perc_total_data: 89.6387
 
---
-------------------------------------------
| Variable_name | Value |
+------------------------------------------
| aria_block_size | 8192 |
| aria_checkpoint_interval | 30 |
| aria_checkpoint_log_activity | 1048576 |
| aria_force_start_after_recovery_failures | 0 |
| aria_group_commit | none |
| aria_group_commit_interval | 0 |
| aria_log_file_size | 1073741824 |
| aria_log_purge_type | immediate |
| aria_max_sort_file_size | 9223372036853727232 |
| aria_page_checksum | ON |
| aria_pagecache_age_threshold | 300 |
| aria_pagecache_buffer_size | 134217720 |
| aria_pagecache_division_limit | 100 |
| aria_recover | NORMAL |
| aria_repair_threads | 1 |
| aria_sort_buffer_size | 134217728 |
| aria_stats_method | nulls_unequal |
| aria_sync_log_dir | NEWFILE |
| aria_used_for_temp_tables | ON |
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
 
| version | 5.3.3-MariaDB-rc-mariadb108 |
| version_comment | (MariaDB - http://mariadb.com/) |
| version_compile_machine | x86_64 |
| version_compile_os | unknown-linux-gnu |
| wait_timeout | 60 |
| warning_count | 0 |
+------------------------------------------+---------------------
 
+-----------------------------------+-----------+
| Variable_name | Value |
+-----------------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Access_denied_errors | 0 |
| Aria_pagecache_blocks_not_flushed | 0 |
| Aria_pagecache_blocks_unused | 15737 |
| Aria_pagecache_blocks_used | 0 |
| Aria_pagecache_read_requests | 0 |
| Aria_pagecache_reads | 0 |
| Aria_pagecache_write_requests | 0 |
| Aria_pagecache_writes | 0 |
| Aria_transaction_log_syncs | 0 |
 
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 1 |
| Threads_running | 1 |
| Uptime | 32004 |
| Uptime_since_flush_status | 32004 |
| binlog_commits | 0 |
| binlog_group_commits | 0 |
| binlog_snapshot_file | |
| binlog_snapshot_position | 0 |
+-----------------------------------+-----------+
+-----+------+-----------+----+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+------+-----------+----+---------+------+-------+------------------+----------+
| 490 | root | localhost | | Query | 0 | | show processlist | 0.000 |
+-----+------+-----------+----+---------+------+-------+------------------+----------+
 
----------------------------
MySQL Error Log
----------------------------
 
Version: '5.3.3-MariaDB-rc-mariadb108'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  (MariaDB - http://mariadb.com/)
120213  2:37:52 [Note] /usr/sbin/mysqld: Normal shutdown
 
120213  2:37:52 [Note] Event Scheduler: Purging the queue. 0 events
120213  2:37:52 [Note] /usr/sbin/mysqld: Shutdown complete
 
120213 02:37:52 mysqld_safe mysqld from pid file /var/lib/mysql/yourserverhostname.pid ended
120215 01:29:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120215  1:29:56 [Note] Plugin 'ARCHIVE' is disabled.
120215  1:29:56 [Note] Plugin 'PBXT' is disabled.
120215  1:29:56 [Note] Plugin 'PBXT_STATISTICS' is disabled.
120215  1:29:56 [Note] Plugin 'InnoDB' is disabled.
120215  1:29:57 [Note] Event Scheduler: Loaded 0 events
120215  1:29:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.3.3-MariaDB-rc-mariadb108'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  (MariaDB - http://mariadb.com/)
 
Report Complete:
Wed Feb 15 10:23:20 EST 2012
----------------------------

There’s also more brief reporting modes for mysqlreport and mysqltuner. See next page for sample output details.

Pages: 1 2


Previous:
Next:



MaxCDN Site Acceleration

Get Cost Effective Content Delivery
Unbeatable speed, stats, & price
http://www.maxcdn.com



No Comments

Trackbacks/Pingbacks

  1. Web Tech Articles Recap | vbtechsupport.com - [...] benchmark & monitoring toolCentOS 6.0 fix for VBoxGuestAdditions installation for VirtualBoxmysqlmymonlite.sh – gather MySQL & Apache, Nginx web server…
  2. mysqlmymonlite.sh official site mysqlmymon.com online | vbtechsupport.com - [...] tech | 0 commentsSince June, 2011 last year, vBulletin licensed customers have benefited from using mysqlmymonlite.sh script to gather…

Leave a Comment