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