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.
[box type=”warning”]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[/box]
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.
