Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -------------------------------------------------------------
- System MySQL monitoring stats
- mysqlmymonlite.sh - 0.5.0 WHM mysqlmymon.com
- compiled by George Liu (eva2000) vbtechsupport.com
- -------------------------------------------------------------
- Report Generated:
- Fri Jan 3 17:45:58 CET 2014
- ----------------------------
- MySQL Uptime:
- ----------------------------
- MySQL server was started 2014-01-03 02:32:15
- Uptime: 15 hours 13 min 42 sec
- Uptime 54822
- Uptime_since_flush_status 54822
- Max Used Connections: 47/151 (31.13%)
- Key Buffer Used: 6.54M/8.00M (81.76%)
- Current Key Buffer Usage: 3.62M (45.25%)
- InnoDB Buffer Pool: 127.98M/127.98M (100.00%)
- Table Locks Waited: 4.50k Rate: 0.1/s (0.04%)
- --------------------
- Query Cache Limit (bytes): 1048576
- Query Cache Min Unit (bytes): 4096
- Query Cache Size (bytes): 0
- Query Cache Free Mem (bytes): 0
- Query Cache Used Mem (bytes): 0
- Queries in Query Cache: 1
- Query Cache Avg Size (bytes): 0
- ----------------------------
- Hardware Info:
- ----------------------------
- Processors physical = 1, cores = 4, virtual = 4, hyperthreading = no
- 4 3400.201
- 4 Intel(R) Xeon(R) CPU E3-1245 V2 @ 3.40GHz
- 4 8192 KB
- ----------------------------
- TOP stats
- ----------------------------
- Linux 2.6.32-042stab083.2 ((yourserverhostname)) 01/03/14 _x86_64_ (8 CPU)
- 17:46:00 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
- 17:46:02 all 0.13 29.50 6.14 11.23 0.00 0.00 0.13 0.00 52.87
- 17:46:02 0 0.51 30.26 6.67 6.67 0.00 0.00 0.51 0.00 55.38
- 17:46:02 1 0.00 28.88 6.42 4.28 0.00 0.00 0.00 0.00 60.43
- 17:46:02 2 0.00 22.60 2.82 5.08 0.00 0.00 0.00 0.00 69.49
- 17:46:02 3 0.00 35.78 7.84 27.45 0.00 0.00 0.00 0.00 28.92
- 17:46:02 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- 17:46:02 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- 17:46:02 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- 17:46:02 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- 17:46:02 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
- 17:46:04 all 0.00 20.50 3.27 13.96 0.00 0.00 0.00 0.00 62.26
- 17:46:04 0 0.00 40.34 5.58 5.58 0.00 0.00 0.00 0.00 48.50
- 17:46:04 1 0.00 8.79 2.20 0.55 0.00 0.00 0.00 0.00 88.46
- 17:46:04 2 0.00 2.87 0.57 12.07 0.00 0.00 0.00 0.00 84.48
- 17:46:04 3 0.00 23.53 3.92 36.76 0.00 0.00 0.00 0.00 35.78
- 17:46:04 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- 17:46:04 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- 17:46:04 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- 17:46:04 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
- Average: all 0.06 24.92 4.68 12.62 0.00 0.00 0.06 0.00 57.66
- Average: 0 0.23 35.75 6.07 6.07 0.00 0.00 0.23 0.00 51.64
- Average: 1 0.00 18.97 4.34 2.44 0.00 0.00 0.00 0.00 74.25
- Average: 2 0.00 12.82 1.71 8.55 0.00 0.00 0.00 0.00 76.92
- Average: 3 0.00 29.66 5.88 32.11 0.00 0.00 0.00 0.00 32.35
- Average: 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- Average: 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- Average: 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- Average: 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
- top - 17:46:04 up 45 days, 6:04, 1 user, load average: 7.17, 4.94, 3.40
- Tasks: 119 total, 2 running, 116 sleeping, 1 stopped, 0 zombie
- Cpu(s): 0.0%us, 0.4%sy, 1.5%ni, 17.6%id, 80.5%wa, 0.0%hi, 0.0%si, 0.0%st
- Mem: 31457280k total, 27302468k used, 4154812k free, 0k buffers
- Swap: 31457280k total, 181492k used, 31275788k free, 24801192k cached
- PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
- 14675 babilosa 24 4 209m 22m 7488 R 15.9 0.1 0:00.08 php
- 6409 nobody 24 4 1332m 77m 11m S 4.0 0.3 0:03.69 httpd
- 7160 babilosa 30 10 252m 66m 9096 D 4.0 0.2 0:12.98 php
- 18929 mysql 26 6 2530m 798m 5932 S 4.0 2.6 184:12.01 mysqld
- 5596 terrahar 30 10 259m 70m 8252 S 2.0 0.2 0:07.52 php
- 13007 nobody 24 4 1330m 65m 2436 S 2.0 0.2 0:00.61 httpd
- 13699 mailman 28 8 194m 9908 2312 S 2.0 0.0 0:03.72 python
- 13722 nobody 24 4 1330m 64m 2444 S 2.0 0.2 0:00.41 httpd
- 14031 beautifu 24 4 296m 107m 8792 S 2.0 0.3 0:01.98 php
- 1 root 20 0 19232 492 356 S 0.0 0.0 0:13.55 init
- 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd/121
- 3 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khelper/121
- 390 root 28 8 100m 18m 3892 S 0.0 0.1 0:58.34 cpsrvd-ssl
- 481 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.91 php
- 789 webmhsc 30 10 202m 6976 6972 S 0.0 0.0 0:59.47 php
- 888 u9085859 28 8 18948 2148 1740 S 0.0 0.0 0:00.00 pop3
- 893 u9085859 28 8 18948 2088 1716 S 0.0 0.0 0:00.00 pop3
- 1142 chaletde 28 8 23288 2472 2028 S 0.0 0.0 0:00.00 imap
- 1309 root 20 0 64308 200 196 S 0.0 0.0 0:00.00 saslauthd
- 1342 root 20 0 64308 24 20 S 0.0 0.0 0:00.00 saslauthd
- 1436 root 30 10 132m 148 92 S 0.0 0.0 0:20.73 pure-uploadscri
- 1703 root 20 0 21456 204 188 S 0.0 0.0 0:00.03 atd
- 1770 chaletde 28 8 25612 2800 2040 S 0.0 0.0 0:00.00 imap
- 1783 chaletde 28 8 23284 2412 1992 S 0.0 0.0 0:00.00 imap
- 1799 chaletde 28 8 23284 2352 1952 S 0.0 0.0 0:00.00 imap
- 1848 chaletde 28 8 23300 2616 2104 S 0.0 0.0 0:00.00 imap
- 2924 root 16 -4 10644 188 184 S 0.0 0.0 0:00.00 udevd
- 2954 nobody 24 4 1292m 75m 11m S 0.0 0.2 0:01.74 httpd
- 5009 root 20 0 66608 500 408 S 0.0 0.0 0:00.01 sshd
- 5218 root 20 0 237m 3824 816 S 0.0 0.0 0:35.44 rsyslogd
- 5701 root 20 0 11444 736 316 S 0.0 0.0 0:00.00 bash
- 5702 root 20 0 4076 556 472 S 0.0 0.0 0:00.00 tee
- 5703 root 20 0 4064 660 564 S 0.0 0.0 0:00.00 logger
- 5765 cpanelro 28 8 100m 17m 2808 S 0.0 0.1 0:00.02 cpsrvd-ssl
- 5976 webmhsc 30 10 202m 6980 6976 S 0.0 0.0 0:59.45 php
- 6187 named 28 8 413m 95m 2296 S 0.0 0.3 7:04.32 named
- 6363 nobody 24 4 170m 56m 732 S 0.0 0.2 0:00.00 httpd
- 6364 root 28 8 51072 9232 2284 S 0.0 0.0 0:00.04 leechprotect
- 6372 nobody 24 4 1332m 76m 10m S 0.0 0.2 0:02.07 httpd
- 6629 root 28 8 54776 9496 1668 S 0.0 0.0 0:43.09 tailwatchd
- 6700 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.59 php
- 6782 webmhsc 30 10 202m 7928 6976 S 0.0 0.0 0:59.86 php
- 7644 nobody 24 4 1316m 64m 2676 S 0.0 0.2 0:00.41 httpd
- 8664 u9085859 28 8 18948 2092 1716 S 0.0 0.0 0:00.00 pop3
- 8686 u9085859 28 8 18948 2152 1740 S 0.0 0.0 0:00.00 pop3
- 8901 cpanelro 28 8 100m 17m 2808 S 0.0 0.1 0:00.01 cpsrvd-ssl
- 9351 misterpa 30 10 214m 8312 8268 S 0.0 0.0 0:10.60 php
- 9355 webmhsc 30 10 202m 11m 6972 S 0.0 0.0 0:59.47 php
- 9571 nobody 24 4 1330m 75m 11m S 0.0 0.2 0:01.30 httpd
- 9597 root 20 0 11444 732 316 S 0.0 0.0 0:00.00 bash
- 9598 root 20 0 4076 548 468 S 0.0 0.0 0:00.00 tee
- 9599 root 20 0 4064 660 564 S 0.0 0.0 0:00.00 logger
- 11349 skydefrc 30 10 135m 868 640 S 0.0 0.0 0:00.00 pure-ftpd
- 11350 root 30 10 135m 368 216 S 0.0 0.0 0:00.00 pure-ftpd
- 11593 nobody 24 4 1322m 68m 3056 S 0.0 0.2 0:01.14 httpd
- 11714 root 20 0 9696 1896 1152 S 0.0 0.0 0:00.00 mysqlmymonlite.
- 11924 root 28 8 19600 1124 816 S 0.0 0.0 0:00.63 dovecot
- 11938 dovenull 28 8 42736 3852 2660 S 0.0 0.0 0:00.71 pop3-login
- 11939 dovenull 28 8 42740 3788 2656 S 0.0 0.0 0:00.40 imap-login
- 11940 dovecot 28 8 13304 1128 932 S 0.0 0.0 0:00.20 anvil
- 11941 root 28 8 13436 1312 968 S 0.0 0.0 0:00.33 log
- 11943 dovenull 28 8 42484 3632 2644 S 0.0 0.0 0:00.24 pop3-login
- 11944 root 28 8 16412 2116 1096 S 0.0 0.0 0:00.57 config
- 11945 dovenull 28 8 43076 4228 2700 S 0.0 0.0 0:01.19 imap-login
- 12555 root 28 8 174m 62m 3308 S 0.0 0.2 0:10.46 spamd child
- 13093 root 20 0 98300 4060 3096 S 0.0 0.0 0:00.01 sshd
- 13161 root 20 0 57684 2232 1620 S 0.0 0.0 0:00.00 sftp-server
- 13689 mailman 28 8 199m 8428 612 S 0.0 0.0 0:00.00 mailmanctl
- 13697 mailman 28 8 194m 9908 2312 S 0.0 0.0 0:03.70 python
- 13698 mailman 28 8 195m 9968 2312 S 0.0 0.0 0:04.02 python
- 13700 mailman 28 8 195m 9900 2312 S 0.0 0.0 0:03.67 python
- 13701 mailman 28 8 195m 9988 2312 S 0.0 0.0 0:03.79 python
- 13702 mailman 28 8 195m 9.8m 2312 S 0.0 0.0 0:04.09 python
- 13703 mailman 28 8 194m 9908 2312 S 0.0 0.0 0:03.75 python
- 13704 mailman 28 8 194m 9908 2312 S 0.0 0.0 0:00.05 python
- 13814 root 24 4 170m 67m 11m S 0.0 0.2 0:37.90 httpd
- 14198 root 28 8 421m 230m 1268 S 0.0 0.7 0:21.05 clamd
- 14205 mailnull 28 8 71536 2980 704 S 0.0 0.0 0:00.28 exim
- 14235 root 28 8 162m 51m 3268 S 0.0 0.2 0:04.92 /usr/local/cpan
- 14311 nobody 24 4 1306m 61m 2456 S 0.0 0.2 0:00.08 httpd
- 14565 beautifu 24 4 282m 93m 8632 D 0.0 0.3 0:01.44 php
- 14595 babilosa 24 4 250m 61m 8656 S 0.0 0.2 0:00.71 php
- 14665 root 20 0 15028 1168 876 R 0.0 0.0 0:00.00 top
- 14783 rubbi 28 8 23064 2128 1748 S 0.0 0.0 0:00.00 imap
- 14793 rubbi 28 8 23260 2416 2000 S 0.0 0.0 0:00.00 imap
- 15161 chaletde 28 8 23888 3096 2148 S 0.0 0.0 0:00.06 imap
- 18617 root 20 0 11444 540 316 S 0.0 0.0 0:00.00 bash
- 18618 root 20 0 4076 536 452 S 0.0 0.0 0:00.00 tee
- 18619 root 20 0 4064 648 556 S 0.0 0.0 0:00.00 logger
- 18804 root 20 0 11308 1512 1224 S 0.0 0.0 0:00.00 mysqld_safe
- 18866 root 30 10 135m 1408 1336 S 0.0 0.0 0:01.28 pure-ftpd
- 18868 root 28 8 133m 1388 1340 S 0.0 0.0 0:01.14 pure-authd
- 19198 root 28 8 141m 3404 1324 S 0.0 0.0 1:21.78 /usr/local/cpan
- 19630 audiotel 28 8 23276 2344 1932 S 0.0 0.0 0:00.05 imap
- 19640 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.82 php
- 19645 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.89 php
- 20492 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.91 php
- 23030 audiotel 28 8 23264 2516 1904 S 0.0 0.0 0:00.09 imap
- 23535 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.97 php
- 23568 root 20 0 98480 4504 3424 S 0.0 0.0 0:00.13 sshd
- 23626 root 20 0 11444 1836 1424 S 0.0 0.0 0:00.03 bash
- 23681 root 20 0 148m 7260 1444 S 0.0 0.0 1:34.04 lfd - sleeping
- 24062 root 20 0 114m 1348 644 S 0.0 0.0 0:03.87 crond
- 24386 misterpa 30 10 214m 8304 8260 S 0.0 0.0 0:10.81 php
- 25741 misterpa 30 10 214m 8304 8260 S 0.0 0.0 0:10.91 php
- 25821 misterpa 30 10 214m 8304 8260 S 0.0 0.0 0:10.75 php
- 26805 root 28 8 19408 1524 1180 S 0.0 0.0 0:00.00 ssl-params
- 27774 thmail 28 8 23300 2368 1956 S 0.0 0.0 0:00.00 imap
- 27784 thmail 28 8 26784 3348 2204 S 0.0 0.0 0:00.01 imap
- 27801 thmail 28 8 25676 3140 2180 S 0.0 0.0 0:00.00 imap
- 27813 thmail 28 8 23060 2420 2000 S 0.0 0.0 0:00.00 imap
- 30099 root 20 0 15396 1156 824 T 0.0 0.0 0:00.12 find
- 30289 root 28 8 33264 3904 1444 S 0.0 0.0 0:05.06 queueprocd - wa
- 30404 root 28 8 107m 3748 1296 S 0.0 0.0 0:09.56 dnsadmin - serv
- 30407 webmhsc 30 10 202m 6980 6976 S 0.0 0.0 0:59.55 php
- 30481 root 28 8 23532 2188 1472 S 0.0 0.0 0:35.42 cpdavd-dormant
- 30497 root 38 18 27112 2536 1156 S 0.0 0.0 0:00.92 cpanellogd - sl
- 30771 root 28 8 45188 2576 2188 S 0.0 0.0 0:12.53 cPhulkd - proce
- 31902 dovecot 28 8 29432 1816 1256 S 0.0 0.0 0:00.83 auth
- total used free shared buffers cached
- Mem: 30720 26667 4052 0 0 24220
- Low: 30720 26667 4052
- High: 0 0 0
- -/+ buffers/cache: 2447 28272
- Swap: 30720 177 30542
- MemTotal: 31457280 kB
- MemFree: 4150176 kB
- Cached: 24801332 kB
- Buffers: 0 kB
- Active: 7439920 kB
- Inactive: 19392680 kB
- Active(anon): 1504724 kB
- Inactive(anon): 526544 kB
- Active(file): 5935196 kB
- Inactive(file): 18866136 kB
- Unevictable: 0 kB
- Mlocked: 0 kB
- SwapTotal: 31457280 kB
- SwapFree: 31275788 kB
- Dirty: 15052 kB
- Writeback: 0 kB
- AnonPages: 2031268 kB
- Shmem: 13400 kB
- Slab: 474408 kB
- SReclaimable: 432580 kB
- SUnreclaim: 41828 kB
- Private + Shared = RAM used Program
- 4.0 KiB + 17.5 KiB = 21.5 KiB udevd
- 44.0 KiB + 64.5 KiB = 108.5 KiB atd
- 56.0 KiB + 63.0 KiB = 119.0 KiB pure-authd
- 60.0 KiB + 60.5 KiB = 120.5 KiB pure-uploadscript
- 0.0 KiB + 192.0 KiB = 192.0 KiB saslauthd (2)
- 208.0 KiB + 34.0 KiB = 242.0 KiB anvil
- 248.0 KiB + 57.5 KiB = 305.5 KiB tee (3)
- 284.0 KiB + 51.5 KiB = 335.5 KiB logger (3)
- 240.0 KiB + 99.0 KiB = 339.0 KiB init
- 356.0 KiB + 36.0 KiB = 392.0 KiB log
- 356.0 KiB + 42.5 KiB = 398.5 KiB dovecot
- 356.0 KiB + 43.5 KiB = 399.5 KiB ssl-params
- 292.0 KiB + 169.5 KiB = 461.5 KiB mysqld_safe
- 448.0 KiB + 29.0 KiB = 477.0 KiB find
- 456.0 KiB + 262.0 KiB = 718.0 KiB pure-ftpd (3)
- 388.0 KiB + 333.0 KiB = 721.0 KiB cPhulkd - proce
- 696.0 KiB + 55.0 KiB = 751.0 KiB auth
- 748.0 KiB + 34.5 KiB = 782.5 KiB crond
- 660.0 KiB + 153.0 KiB = 813.0 KiB sftp-server
- 752.0 KiB + 166.5 KiB = 918.5 KiB mysqlmymonlite.
- 848.0 KiB + 218.0 KiB = 1.0 MiB cpdavd-dormant
- 1.0 MiB + 39.0 KiB = 1.1 MiB config
- 908.0 KiB + 542.0 KiB = 1.4 MiB bash (4)
- 1.3 MiB + 112.0 KiB = 1.5 MiB cpanellogd - sl
- 1.5 MiB + 380.0 KiB = 1.9 MiB pop3 (4)
- 2.1 MiB + 313.0 KiB = 2.4 MiB pop3-login (2)
- 2.4 MiB + 70.5 KiB = 2.5 MiB exim
- 2.4 MiB + 198.0 KiB = 2.6 MiB dnsadmin - serv
- 2.5 MiB + 129.5 KiB = 2.6 MiB queueprocd - wa
- 2.6 MiB + 330.0 KiB = 2.9 MiB imap-login (2)
- 3.1 MiB + 42.0 KiB = 3.2 MiB rsyslogd
- 2.2 MiB + 1.3 MiB = 3.5 MiB sshd (3)
- 5.7 MiB + 147.0 KiB = 5.8 MiB lfd - sleeping
- 6.8 MiB + 372.0 KiB = 7.1 MiB leechprotect
- 7.6 MiB + 115.5 KiB = 7.7 MiB mailmanctl
- 7.7 MiB + 240.0 KiB = 7.9 MiB tailwatchd
- 8.2 MiB + 1.5 MiB = 9.7 MiB imap (14)
- 9.5 MiB + 13.6 MiB = 23.2 MiB cpsrvd-ssl (3)
- 27.7 MiB + 11.9 MiB = 39.6 MiB /usr/local/cpan (2)
- 37.6 MiB + 11.7 MiB = 49.4 MiB spamd child
- 59.6 MiB + 1.2 MiB = 60.9 MiB python (8)
- 94.9 MiB + 91.0 KiB = 95.0 MiB named
- 145.7 MiB + 66.3 MiB = 212.0 MiB httpd (11)
- 229.5 MiB + 54.0 KiB = 229.5 MiB clamd
- 397.9 MiB + 8.9 MiB = 406.7 MiB php (21)
- 797.8 MiB + 156.0 KiB = 797.9 MiB mysqld
- ---------------------------------
- 1.9 GiB
- =================================
- Private + Shared = RAM used Program
- ----------------------------
- MySQL datadir disk usage
- ----------------------------
- /var/lib/mysql/ uses 16734064 kilobytes of disk space
- ----------------------------
- ulimit -aH
- ----------------------------
- core file size (blocks, -c) 1000000
- data seg size (kbytes, -d) unlimited
- scheduling priority (-e) 0
- file size (blocks, -f) unlimited
- pending signals (-i) 255461
- max locked memory (kbytes, -l) 64
- max memory size (kbytes, -m) unlimited
- open files (-n) 4096
- pipe size (512 bytes, -p) 8
- POSIX message queues (bytes, -q) 819200
- real-time priority (-r) 0
- stack size (kbytes, -s) 8192
- cpu time (seconds, -t) unlimited
- max user processes (-u) 14335
- virtual memory (kbytes, -v) unlimited
- file locks (-x) unlimited
- ----------------------------------------------------------
- tail -15 /etc/security/limits.conf
- ----------------------------------------------------------
- # - nice - max nice priority allowed to raise to values: [-20, 19]
- # - rtprio - max realtime priority
- #
- #<domain> <type> <item> <value>
- #
- #* soft core 0
- #* hard rss 10000
- #@student hard nproc 20
- #@faculty soft nproc 20
- #@faculty hard nproc 50
- #ftp hard nproc 0
- #@student - maxlogins 4
- # End of file
- ----------------------------------------------------------
- mysqld process limits:
- cat /proc/18929/limits
- ----------------------------------------------------------
- Limit Soft Limit Hard Limit Units
- Max cpu time unlimited unlimited seconds
- Max file size unlimited unlimited bytes
- Max data size unlimited unlimited bytes
- Max stack size 8388608 8388608 bytes
- Max core file size 1024000000 1024000000 bytes
- Max resident set unlimited unlimited bytes
- Max processes 14335 14335 processes
- Max open files 50000 50000 files
- Max locked memory 65536 65536 bytes
- Max address space unlimited unlimited bytes
- Max file locks unlimited unlimited locks
- Max pending signals 255461 255461 signals
- Max msgqueue size 819200 819200 bytes
- Max nice priority 0 0
- Max realtime priority 0 0
- Max realtime timeout unlimited unlimited us
- ----------------------------------
- CPANEL WEB SERVER & PHP Info:
- ----------------------------------
- WHM / Cpanel version: 11.40.1.8
- WHM's PHP Handler config:
- /usr/local/cpanel/bin/rebuild_phpconf --current
- Available handlers: suphp cgi none
- DEFAULT PHP: 5
- PHP4 SAPI: none
- PHP5 SAPI: suphp
- SUEXEC: enabled
- RUID2: not installed
- PHP 5.4.23 (cli) (built: Dec 27 2013 14:01:04)
- Copyright (c) 1997-2013 The PHP Group
- Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
- with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd., and
- with Zend Guard Loader v3.3, Copyright (c) 1998-2013, by Zend Technologies
- System => Linux yourserverhostname 2.6.32-042stab083.2 #1 SMP Fri Nov 8 18:08:40 MSK 2013 x86_64
- Build Date => Dec 27 2013 13:59:35
- Configure Command => './configure' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-mbstring' '--enable-pdo=shared' '--enable-soap' '--enable-sockets' '--enable-zip' '--prefix=/usr/local' '--with-curl=/opt/curlssl/' '--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-libexpat-dir=/usr' '--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-tidy=/opt/tidy/' '--with-xmlrpc' '--with-xpm-dir=/usr' '--with-xsl=/opt/xslt/' '--with-zlib' '--with-zlib-dir=/usr'
- Server API | Command Line Interface
- Configuration File (php.ini) Path | /usr/local/lib
- Loaded Configuration File | /usr/local/lib/php.ini
- PHP API | 20100412
- Zend Extension Build | API220100525,NTS
- PHP Extension Build | API20100525,NTS
- DOM/XML API Version | 20031129
- Client API version | 5.5.34
- Client API library version | 5.5.34
- Client API header version | 5.5.34
- API Extensions | pdo_mysql
- Client API version | mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
- Phar API version | 1.1.1
- display_errors | Off | Off
- error_log | error_log | error_log
- extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20100525 | /usr/local/lib/php/extensions/no-debug-non-zts-20100525
- file_uploads | On | On
- log_errors | On | On
- log_errors_max_len | 1024 | 1024
- max_execution_time | 0 | 0
- max_file_uploads | 20 | 20
- memory_limit | 320M | 320M
- open_basedir | /home:/usr:/tmp:/var/netenberg | /home:/usr:/tmp:/var/netenberg
- post_max_size | 20M | 20M
- realpath_cache_size | 16K | 16K
- realpath_cache_ttl | 120 | 120
- sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
- sql.safe_mode | Off | Off
- upload_max_filesize | 20M | 20M
- upload_tmp_dir | no value | no value
- sqlite3.extension_dir | no value | no value
- cURL support | enabled
- cURL Information | 7.24.0
- ZLib Version | 1.2.3
- GD Support | enabled
- GD Version | bundled (2.1.0 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.49
- WBMP Support | enabled
- libXML support | active
- libXML Compiled Version | 2.9.0
- libXML Loaded Version | 20900
- libXML streams | enabled
- PCRE (Perl Compatible Regular Expressions) Support | enabled
- PCRE Library Version | 8.21 2011-12-12
- Soap Client | enabled
- Soap Server | enabled
- ZLib Support | enabled
- Server version: Apache/2.2.26 (Unix)
- Server built: Dec 27 2013 13:55:28
- Cpanel::Easy::Apache v3.22.25 rev9999
- Server's Module Magic Number: 20051115:33
- Server loaded: APR 1.4.8, APR-Util 1.5.2
- Compiled using: APR 1.4.8, APR-Util 1.5.2
- Architecture: 64-bit
- Server MPM: Worker
- threaded: yes (fixed thread count)
- forked: yes (variable process count)
- Server compiled with....
- -D APACHE_MPM_DIR="server/mpm/worker"
- -D APR_HAS_SENDFILE
- -D APR_HAS_MMAP
- -D APR_HAVE_IPV6 (IPv4-mapped addresses disabled)
- -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_SCOREBOARD="logs/apache_runtime_status"
- -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)
- authn_file_module (static)
- authn_default_module (static)
- authz_host_module (static)
- authz_groupfile_module (static)
- authz_user_module (static)
- authz_default_module (static)
- auth_basic_module (static)
- file_cache_module (static)
- cache_module (static)
- disk_cache_module (static)
- mem_cache_module (static)
- include_module (static)
- filter_module (static)
- deflate_module (static)
- log_config_module (static)
- logio_module (static)
- env_module (static)
- expires_module (static)
- headers_module (static)
- unique_id_module (static)
- setenvif_module (static)
- version_module (static)
- proxy_module (static)
- proxy_connect_module (static)
- proxy_ftp_module (static)
- proxy_http_module (static)
- proxy_scgi_module (static)
- proxy_ajp_module (static)
- proxy_balancer_module (static)
- ssl_module (static)
- mpm_worker_module (static)
- http_module (static)
- mime_module (static)
- dav_module (static)
- status_module (static)
- autoindex_module (static)
- asis_module (static)
- info_module (static)
- suexec_module (static)
- cgid_module (static)
- dav_fs_module (static)
- negotiation_module (static)
- dir_module (static)
- actions_module (static)
- speling_module (static)
- userdir_module (static)
- alias_module (static)
- rewrite_module (static)
- so_module (static)
- bwlimited_module (shared)
- suphp_module (shared)
- security2_module (shared)
- Compiled in modules:
- core.c
- mod_authn_file.c
- mod_authn_default.c
- mod_authz_host.c
- mod_authz_groupfile.c
- mod_authz_user.c
- mod_authz_default.c
- mod_auth_basic.c
- mod_file_cache.c
- mod_cache.c
- mod_disk_cache.c
- mod_mem_cache.c
- mod_include.c
- mod_filter.c
- mod_deflate.c
- mod_log_config.c
- mod_logio.c
- mod_env.c
- mod_expires.c
- mod_headers.c
- mod_unique_id.c
- mod_setenvif.c
- mod_version.c
- mod_proxy.c
- mod_proxy_connect.c
- mod_proxy_ftp.c
- mod_proxy_http.c
- mod_proxy_scgi.c
- mod_proxy_ajp.c
- mod_proxy_balancer.c
- mod_ssl.c
- worker.c
- http_core.c
- mod_mime.c
- mod_dav.c
- mod_status.c
- mod_autoindex.c
- mod_asis.c
- mod_info.c
- mod_suexec.c
- mod_cgid.c
- mod_dav_fs.c
- mod_negotiation.c
- mod_dir.c
- mod_actions.c
- mod_speling.c
- mod_userdir.c
- mod_alias.c
- mod_rewrite.c
- mod_so.c
- -------------------------------
- From /usr/local/apache/conf/httpd.conf
- -------------------------------
- Timeout 300
- KeepAlive Off
- MaxKeepAliveRequests 100
- KeepAliveTimeout 5
- </IfModule>
- StartServers 5
- <IfModule prefork.c>
- MinSpareServers 5
- MaxSpareServers 10
- </IfModule>
- MinSpareServers 5
- MaxSpareServers 10
- </IfModule>
- ServerLimit 500
- MaxClients 500
- MaxRequestsPerChild 10000
- </IfModule>
- ----------------------------
- mysqlreport output
- ----------------------------
- MySQL 5.5.34-cll uptime 0 15:13:53 Fri Jan 3 17:46:08 2014
- __ Key _________________________________________________________________
- Buffer used 6.54M of 8.00M %Used: 81.76
- Current 4.00M %Usage: 49.99
- Write hit 99.43%
- Read hit 99.85%
- __ Questions ___________________________________________________________
- Total 12.17M 222.0/s
- DMS 10.84M 197.7/s %Total: 89.08
- Com_ 1.26M 23.0/s 10.35
- COM_QUIT 292.51k 5.3/s 2.40
- -Unknown 223.11k 4.1/s 1.83
- Slow 10 s 219 0.0/s 0.00 %DMS: 0.00 Log: OFF
- DMS 10.84M 197.7/s 89.08
- SELECT 9.86M 179.8/s 81.00 90.93
- UPDATE 411.71k 7.5/s 3.38 3.80
- INSERT 321.23k 5.9/s 2.64 2.96
- DELETE 193.09k 3.5/s 1.59 1.78
- REPLACE 57.21k 1.0/s 0.47 0.53
- Com_ 1.26M 23.0/s 10.35
- set_option 497.05k 9.1/s 4.08
- change_db 315.40k 5.8/s 2.59
- stmt_close 53.28k 1.0/s 0.44
- __ Rows ________________________________________________________________
- Rows 8.02G 146.2k/s
- Using idx 4.11G 74.9k/s %Index: 51.20
- Rows/question 658.85
- __ SELECT and Sort _____________________________________________________
- Scan 2.35M 42.9/s %SELECT: 23.85
- Range 162.03k 3.0/s 1.64
- Full join 1.83k 0.0/s 0.02
- Range check 106 0.0/s 0.00
- Full rng join 32 0.0/s 0.00
- Sort scan 1.19M 21.8/s
- Sort range 419.87k 7.7/s
- Sort mrg pass 1.24k 0.0/s
- __ Table Locks _________________________________________________________
- Waited 4.50k 0.1/s %Total: 0.04
- Immediate 12.46M 227.3/s
- __ Tables ______________________________________________________________
- Open 400 of 400 %Cache: 100.00
- Opened 17.03M 310.6/s
- __ Connections _________________________________________________________
- Max used 47 of 151 %Max: 31.13
- Total 292.63k 5.3/s
- __ Created Temp ________________________________________________________
- Disk table 175.36k 3.2/s %Disk: 49.83
- Table 351.91k 6.4/s Size: 16.0M
- File 2.57k 0.0/s
- __ Threads _____________________________________________________________
- Running 7 of 10
- Created 292.54k 5.3/s
- Slow 0 0/s
- Cached 0 of 0 %Hit: 0.03
- __ Aborted _____________________________________________________________
- Clients 248 0.0/s
- Connects 53.30k 1.0/s
- __ Bytes _______________________________________________________________
- Sent 106.71G 1.9M/s
- Received 2.19G 39.8k/s
- __ InnoDB Buffer Pool __________________________________________________
- Usage 127.98M of 127.98M %Usage: 100.00
- Read hit 95.10%
- Pages
- Free 0 %Total: 0.00
- Data 8.19k 99.95 %Drty: 0.79
- Misc 4 0.05
- Latched 0 0.00
- Reads 337.28M 6.2k/s
- From disk 16.54M 301.6/s %Disk: 4.90
- Ahead Rnd 0 0/s
- Writes 3.09M 56.3/s
- Wait Free 0 0/s %Wait: 0.00
- Flushes 512.38k 9.3/s
- __ InnoDB Lock _________________________________________________________
- Waits 4936 0.1/s
- Current 0
- Time acquiring
- Total 154269 ms
- Average 31 ms
- Max 13214 ms
- __ InnoDB Data, Pages, Rows ____________________________________________
- Data
- Reads 16.57M 302.2/s
- Writes 796.86k 14.5/s
- fsync 314.58k 5.7/s
- Pending
- Reads 0
- Writes 0
- fsync 2
- Pages
- Created 24.58k 0.4/s
- Read 16.56M 301.9/s
- Written 512.38k 9.3/s
- Rows
- Deleted 84.78k 1.5/s
- Inserted 454.08k 8.3/s
- Read 342.10M 6.2k/s
- Updated 162.28k 3.0/s
- ----------------------------
- Total Server MyISAM and InnoDB Size
- ----------------------------
- *************************** 1. row ***************************
- innodb_tablespace_utilization_perc: 100
- total_size_gb: 10.35635173600167
- index_size_gb: 2.3308553025126457
- data_size_gb: 8.025496433489025
- innodb_total_size_gb: 2.789520263671875
- innodb_data_size_gb: 2.1698760986328125
- innodb_index_size_gb: 0.6196441650390625
- myisam_total_size_gb: 7.565571169368923
- myisam_data_size_gb: 5.855028490535915
- myisam_index_size_gb: 1.7105426788330078
- perc_index: 22.506528900
- perc_data: 77.493471000
- innodb_perc_index: 22.213287800
- innodb_perc_data: 77.786712100
- myisam_perc_index: 22.609564300
- myisam_perc_data: 77.390435600
- innodb_perc_total_index: 26.584411400
- innodb_perc_total_data: 27.037281900
- myisam_perc_total_index: 73.386909800
- myisam_perc_total_data: 72.955343400
- ----------------------------
- MySQL settings
- ----------------------------
- [mysqld]
- innodb_file_per_table=1
- open_files_limit=50000
- ---
- +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
- | Variable_name | Value |
- +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
- | auto_increment_increment | 1 |
- | auto_increment_offset | 1 |
- | autocommit | ON |
- | automatic_sp_privileges | ON |
- | back_log | 50 |
- | basedir | /usr |
- | big_tables | OFF |
- | binlog_cache_size | 32768 |
- | binlog_direct_non_transactional_updates | OFF |
- | binlog_format | STATEMENT |
- | binlog_stmt_cache_size | 32768 |
- | bulk_insert_buffer_size | 8388608 |
- | character_set_client | latin1 |
- | character_set_connection | latin1 |
- | character_set_database | latin1 |
- | character_set_filesystem | binary |
- | character_set_results | latin1 |
- | character_set_server | latin1 |
- | character_set_system | utf8 |
- | character_sets_dir | /usr/share/mysql/charsets/ |
- | collation_connection | latin1_swedish_ci |
- | collation_database | latin1_swedish_ci |
- | collation_server | latin1_swedish_ci |
- | completion_type | NO_CHAIN |
- | concurrent_insert | AUTO |
- | connect_timeout | 10 |
- | datadir | /var/lib/mysql/ |
- | date_format | %Y-%m-%d |
- | datetime_format | %Y-%m-%d %H:%i:%s |
- | default_storage_engine | InnoDB |
- | default_week_format | 0 |
- | delay_key_write | ON |
- | delayed_insert_limit | 100 |
- | delayed_insert_timeout | 300 |
- | delayed_queue_size | 1000 |
- | div_precision_increment | 4 |
- | engine_condition_pushdown | ON |
- | event_scheduler | OFF |
- | expire_logs_days | 0 |
- | flush | OFF |
- | flush_time | 0 |
- | foreign_key_checks | ON |
- | ft_boolean_syntax | + -><()~*:""&| |
- | ft_max_word_len | 84 |
- | ft_min_word_len | 4 |
- | ft_query_expansion_limit | 20 |
- | ft_stopword_file | (built-in) |
- | general_log | OFF |
- | general_log_file | /var/lib/mysql/fr1.log |
- | group_concat_max_len | 1024 |
- | have_compress | YES |
- | have_crypt | YES |
- | have_csv | YES |
- | have_dynamic_loading | YES |
- | have_geometry | YES |
- | have_innodb | YES |
- | have_ndbcluster | NO |
- | have_openssl | DISABLED |
- | have_partitioning | YES |
- | have_profiling | YES |
- | have_query_cache | YES |
- | have_rtree_keys | YES |
- | have_ssl | DISABLED |
- | have_symlink | YES |
- | hostname | yourserverhostname |
- | ignore_builtin_innodb | OFF |
- | init_connect | |
- | init_file | |
- | init_slave | |
- | innodb_adaptive_flushing | ON |
- | innodb_adaptive_hash_index | ON |
- | innodb_additional_mem_pool_size | 8388608 |
- | innodb_autoextend_increment | 8 |
- | innodb_autoinc_lock_mode | 1 |
- | innodb_buffer_pool_instances | 1 |
- | innodb_buffer_pool_size | 134217728 |
- | innodb_change_buffering | all |
- | innodb_checksums | ON |
- | innodb_commit_concurrency | 0 |
- | innodb_concurrency_tickets | 500 |
- | innodb_data_file_path | ibdata1:10M:autoextend |
- | innodb_data_home_dir | |
- | innodb_doublewrite | ON |
- | innodb_fast_shutdown | 1 |
- | innodb_file_format | Antelope |
- | innodb_file_format_check | ON |
- | innodb_file_format_max | Antelope |
- | innodb_file_per_table | ON |
- | innodb_flush_log_at_trx_commit | 1 |
- | innodb_flush_method | |
- | innodb_force_load_corrupted | OFF |
- | innodb_force_recovery | 0 |
- | innodb_io_capacity | 200 |
- | innodb_large_prefix | OFF |
- | innodb_lock_wait_timeout | 50 |
- | innodb_locks_unsafe_for_binlog | OFF |
- | innodb_log_buffer_size | 8388608 |
- | innodb_log_file_size | 5242880 |
- | innodb_log_files_in_group | 2 |
- | innodb_log_group_home_dir | ./ |
- | innodb_max_dirty_pages_pct | 75 |
- | innodb_max_purge_lag | 0 |
- | innodb_mirrored_log_groups | 1 |
- | innodb_old_blocks_pct | 37 |
- | innodb_old_blocks_time | 0 |
- | innodb_open_files | 300 |
- | innodb_print_all_deadlocks | OFF |
- | innodb_purge_batch_size | 20 |
- | innodb_purge_threads | 0 |
- | innodb_random_read_ahead | OFF |
- | innodb_read_ahead_threshold | 56 |
- | innodb_read_io_threads | 4 |
- | innodb_replication_delay | 0 |
- | innodb_rollback_on_timeout | OFF |
- | innodb_rollback_segments | 128 |
- | innodb_spin_wait_delay | 6 |
- | innodb_stats_method | nulls_equal |
- | innodb_stats_on_metadata | ON |
- | innodb_stats_sample_pages | 8 |
- | innodb_strict_mode | OFF |
- | innodb_support_xa | ON |
- | innodb_sync_spin_loops | 30 |
- | innodb_table_locks | ON |
- | innodb_thread_concurrency | 0 |
- | innodb_thread_sleep_delay | 10000 |
- | innodb_use_native_aio | ON |
- | innodb_use_sys_malloc | ON |
- | innodb_version | 5.5.34 |
- | innodb_write_io_threads | 4 |
- | interactive_timeout | 28800 |
- | join_buffer_size | 131072 |
- | keep_files_on_create | OFF |
- | key_buffer_size | 8388608 |
- | key_cache_age_threshold | 300 |
- | key_cache_block_size | 1024 |
- | key_cache_division_limit | 100 |
- | large_files_support | ON |
- | large_page_size | 0 |
- | large_pages | OFF |
- | lc_messages | en_US |
- | lc_messages_dir | /usr/share/mysql/ |
- | lc_time_names | en_US |
- | license | GPL |
- | local_infile | ON |
- | lock_wait_timeout | 31536000 |
- | locked_in_memory | OFF |
- | log | OFF |
- | log_bin | OFF |
- | log_bin_trust_function_creators | OFF |
- | log_error | /var/lib/mysql/yourserverhostname.err |
- | log_output | FILE |
- | log_queries_not_using_indexes | OFF |
- | log_slave_updates | OFF |
- | log_slow_queries | OFF |
- | log_warnings | 1 |
- | long_query_time | 10.000000 |
- | low_priority_updates | OFF |
- | lower_case_file_system | OFF |
- | lower_case_table_names | 0 |
- | max_allowed_packet | 1048576 |
- | max_binlog_cache_size | 18446744073709547520 |
- | max_binlog_size | 1073741824 |
- | max_binlog_stmt_cache_size | 18446744073709547520 |
- | max_connect_errors | 10 |
- | max_connections | 151 |
- | max_delayed_threads | 20 |
- | max_error_count | 64 |
- | max_heap_table_size | 16777216 |
- | max_insert_delayed_threads | 20 |
- | max_join_size | 18446744073709551615 |
- | max_length_for_sort_data | 1024 |
- | max_long_data_size | 1048576 |
- | max_prepared_stmt_count | 16382 |
- | max_relay_log_size | 0 |
- | max_seeks_for_key | 18446744073709551615 |
- | max_sort_length | 1024 |
- | max_sp_recursion_depth | 0 |
- | max_tmp_tables | 32 |
- | max_user_connections | 0 |
- | max_write_lock_count | 18446744073709551615 |
- | metadata_locks_cache_size | 1024 |
- | min_examined_row_limit | 0 |
- | multi_range_count | 256 |
- | myisam_data_pointer_size | 6 |
- | myisam_max_sort_file_size | 9223372036853727232 |
- | myisam_mmap_size | 18446744073709551615 |
- | myisam_recover_options | OFF |
- | myisam_repair_threads | 1 |
- | myisam_sort_buffer_size | 8388608 |
- | myisam_stats_method | nulls_unequal |
- | myisam_use_mmap | OFF |
- | net_buffer_length | 16384 |
- | net_read_timeout | 30 |
- | net_retry_count | 10 |
- | net_write_timeout | 60 |
- | new | OFF |
- | old | OFF |
- | old_alter_table | OFF |
- | old_passwords | OFF |
- | open_files_limit | 50000 |
- | optimizer_prune_level | 1 |
- | optimizer_search_depth | 62 |
- | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on |
- | performance_schema | OFF |
- | performance_schema_events_waits_history_long_size | 10000 |
- | performance_schema_events_waits_history_size | 10 |
- | performance_schema_max_cond_classes | 80 |
- | performance_schema_max_cond_instances | 1000 |
- | performance_schema_max_file_classes | 50 |
- | performance_schema_max_file_handles | 32768 |
- | performance_schema_max_file_instances | 10000 |
- | performance_schema_max_mutex_classes | 200 |
- | performance_schema_max_mutex_instances | 1000000 |
- | performance_schema_max_rwlock_classes | 30 |
- | performance_schema_max_rwlock_instances | 1000000 |
- | performance_schema_max_table_handles | 100000 |
- | performance_schema_max_table_instances | 50000 |
- | performance_schema_max_thread_classes | 50 |
- | performance_schema_max_thread_instances | 1000 |
- | pid_file | /var/lib/mysql/yourserverhostname.pid |
- | plugin_dir | /usr/lib64/mysql/plugin/ |
- | port | 3306 |
- | preload_buffer_size | 32768 |
- | profiling | OFF |
- | profiling_history_size | 15 |
- | protocol_version | 10 |
- | query_alloc_block_size | 8192 |
- | query_cache_limit | 1048576 |
- | query_cache_min_res_unit | 4096 |
- | query_cache_size | 0 |
- | query_cache_type | ON |
- | query_cache_wlock_invalidate | OFF |
- | query_prealloc_size | 8192 |
- | range_alloc_block_size | 4096 |
- | read_buffer_size | 131072 |
- | read_only | OFF |
- | read_rnd_buffer_size | 262144 |
- | relay_log | |
- | relay_log_index | |
- | relay_log_info_file | relay-log.info |
- | relay_log_purge | ON |
- | relay_log_recovery | OFF |
- | relay_log_space_limit | 0 |
- | report_host | |
- | report_password | |
- | report_port | 3306 |
- | report_user | |
- | rpl_recovery_rank | 0 |
- | secure_auth | OFF |
- | secure_file_priv | |
- | server_id | 0 |
- | skip_external_locking | ON |
- | skip_name_resolve | OFF |
- | skip_networking | OFF |
- | skip_show_database | OFF |
- | slave_compressed_protocol | OFF |
- | slave_exec_mode | STRICT |
- | slave_load_tmpdir | /tmp |
- | slave_max_allowed_packet | 1073741824 |
- | slave_net_timeout | 3600 |
- | slave_skip_errors | OFF |
- | slave_transaction_retries | 10 |
- | slave_type_conversions | |
- | slow_launch_time | 2 |
- | slow_query_log | OFF |
- | slow_query_log_file | /var/lib/mysql/fr1-slow.log |
- | socket | /var/lib/mysql/mysql.sock |
- | sort_buffer_size | 2097152 |
- | sql_auto_is_null | OFF |
- | sql_big_selects | ON |
- | sql_big_tables | OFF |
- | sql_buffer_result | OFF |
- | sql_log_bin | ON |
- | sql_log_off | OFF |
- | sql_low_priority_updates | OFF |
- | sql_max_join_size | 18446744073709551615 |
- | sql_mode | |
- | sql_notes | ON |
- | sql_quote_show_create | ON |
- | sql_safe_updates | OFF |
- | sql_select_limit | 18446744073709551615 |
- | sql_slave_skip_counter | 0 |
- | sql_warnings | OFF |
- | ssl_ca | |
- | ssl_capath | |
- | ssl_cert | |
- | ssl_cipher | |
- | ssl_key | |
- | storage_engine | InnoDB |
- | stored_program_cache | 256 |
- | sync_binlog | 0 |
- | sync_frm | ON |
- | sync_master_info | 0 |
- | sync_relay_log | 0 |
- | sync_relay_log_info | 0 |
- | system_time_zone | CET |
- | table_definition_cache | 400 |
- | table_open_cache | 400 |
- | thread_cache_size | 0 |
- | thread_concurrency | 10 |
- | thread_handling | one-thread-per-connection |
- | thread_stack | 262144 |
- | thread_statistics | OFF |
- | time_format | %H:%i:%s |
- | time_zone | SYSTEM |
- | timed_mutexes | OFF |
- | tmp_table_size | 16777216 |
- | tmpdir | /tmp |
- | transaction_alloc_block_size | 8192 |
- | transaction_prealloc_size | 4096 |
- | tx_isolation | REPEATABLE-READ |
- | unique_checks | ON |
- | updatable_views_with_limit | YES |
- | userstat | OFF |
- | version | 5.5.34-cll |
- | version_comment | MySQL Community Server (GPL) |
- | version_compile_machine | x86_64 |
- | version_compile_os | Linux |
- | wait_timeout | 28800 |
- +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
- +------------------------------------------+--------------+
- | Variable_name | Value |
- +------------------------------------------+--------------+
- | Aborted_clients | 248 |
- | Aborted_connects | 53310 |
- | Binlog_cache_disk_use | 0 |
- | Binlog_cache_use | 0 |
- | Binlog_stmt_cache_disk_use | 0 |
- | Binlog_stmt_cache_use | 0 |
- | Bytes_received | 2186985489 |
- | Bytes_sent | 106729882414 |
- | Com_admin_commands | 9419 |
- | Com_assign_to_keycache | 0 |
- | Com_alter_db | 74 |
- | Com_alter_db_upgrade | 0 |
- | Com_alter_event | 0 |
- | Com_alter_function | 0 |
- | Com_alter_procedure | 0 |
- | Com_alter_server | 0 |
- | Com_alter_table | 22397 |
- | Com_alter_tablespace | 0 |
- | Com_analyze | 0 |
- | Com_begin | 15 |
- | Com_binlog | 0 |
- | Com_call_procedure | 0 |
- | Com_change_db | 315485 |
- | Com_change_master | 0 |
- | Com_check | 15 |
- | Com_checksum | 0 |
- | Com_commit | 15 |
- | Com_create_db | 182 |
- | Com_create_event | 0 |
- | Com_create_function | 0 |
- | Com_create_index | 0 |
- | Com_create_procedure | 2 |
- | Com_create_server | 0 |
- | Com_create_table | 11116 |
- | Com_create_trigger | 0 |
- | Com_create_udf | 0 |
- | Com_create_user | 0 |
- | Com_create_view | 0 |
- | Com_dealloc_sql | 0 |
- | Com_delete | 193123 |
- | Com_delete_multi | 11 |
- | Com_do | 0 |
- | Com_drop_db | 64 |
- | Com_drop_event | 0 |
- | Com_drop_function | 0 |
- | Com_drop_index | 0 |
- | Com_drop_procedure | 2 |
- | Com_drop_server | 0 |
- | Com_drop_table | 9859 |
- | Com_drop_trigger | 0 |
- | Com_drop_user | 2 |
- | Com_drop_view | 0 |
- | Com_empty_query | 0 |
- | Com_execute_sql | 0 |
- | Com_flush | 862 |
- | Com_grant | 6308 |
- | Com_ha_close | 0 |
- | Com_ha_open | 0 |
- | Com_ha_read | 0 |
- | Com_help | 0 |
- | Com_insert | 321161 |
- | Com_insert_select | 96 |
- | Com_install_plugin | 0 |
- | Com_kill | 0 |
- | Com_load | 0 |
- | Com_lock_tables | 19126 |
- | Com_optimize | 8 |
- | Com_preload_keys | 0 |
- | Com_prepare_sql | 0 |
- | Com_purge | 0 |
- | Com_purge_before_date | 0 |
- | Com_release_savepoint | 0 |
- | Com_rename_table | 0 |
- | Com_rename_user | 0 |
- | Com_repair | 0 |
- | Com_replace | 57214 |
- | Com_replace_select | 1 |
- | Com_reset | 0 |
- | Com_resignal | 0 |
- | Com_revoke | 0 |
- | Com_revoke_all | 0 |
- | Com_rollback | 0 |
- | Com_rollback_to_savepoint | 0 |
- | Com_savepoint | 0 |
- | Com_select | 9867696 |
- | Com_set_option | 497168 |
- | Com_signal | 0 |
- | Com_show_authors | 0 |
- | Com_show_binlog_events | 0 |
- | Com_show_binlogs | 39 |
- | Com_show_charsets | 0 |
- | Com_show_client_statistics | 0 |
- | Com_show_collations | 0 |
- | Com_show_contributors | 0 |
- | Com_show_create_db | 453 |
- | Com_show_create_event | 0 |
- | Com_show_create_func | 0 |
- | Com_show_create_proc | 1 |
- | Com_show_create_table | 21714 |
- | Com_show_create_trigger | 26 |
- | Com_show_databases | 195 |
- | Com_show_engine_logs | 0 |
- | Com_show_engine_mutex | 0 |
- | Com_show_engine_status | 0 |
- | Com_show_events | 15 |
- | Com_show_errors | 0 |
- | Com_show_fields | 49834 |
- | Com_show_function_status | 4219 |
- | Com_show_grants | 4697 |
- | Com_show_index_statistics | 0 |
- | Com_show_keys | 154 |
- | Com_show_master_status | 10 |
- | Com_show_open_tables | 0 |
- | Com_show_plugins | 0 |
- | Com_show_privileges | 0 |
- | Com_show_procedure_status | 4219 |
- | Com_show_processlist | 184 |
- | Com_show_profile | 0 |
- | Com_show_profiles | 4 |
- | Com_show_relaylog_events | 0 |
- | Com_show_slave_hosts | 0 |
- | Com_show_slave_status | 10 |
- | Com_show_status | 1646 |
- | Com_show_storage_engines | 0 |
- | Com_show_table_statistics | 0 |
- | Com_show_table_status | 46053 |
- | Com_show_tables | 11337 |
- | Com_show_thread_statistics | 0 |
- | Com_show_triggers | 43612 |
- | Com_show_user_statistics | 0 |
- | Com_show_variables | 261 |
- | Com_show_warnings | 39 |
- | Com_slave_start | 0 |
- | Com_slave_stop | 0 |
- | Com_stmt_close | 53303 |
- | Com_stmt_execute | 53303 |
- | Com_stmt_fetch | 0 |
- | Com_stmt_prepare | 53303 |
- | Com_stmt_reprepare | 0 |
- | Com_stmt_reset | 0 |
- | Com_stmt_send_long_data | 0 |
- | Com_truncate | 323 |
- | Com_uninstall_plugin | 0 |
- | Com_unlock_tables | 19220 |
- | Com_update | 407721 |
- | Com_update_multi | 4148 |
- | Com_xa_commit | 0 |
- | Com_xa_end | 0 |
- | Com_xa_prepare | 0 |
- | Com_xa_recover | 0 |
- | Com_xa_rollback | 0 |
- | Com_xa_start | 0 |
- | Compression | OFF |
- | Connections | 292722 |
- | Created_tmp_disk_tables | 175425 |
- | Created_tmp_files | 2570 |
- | Created_tmp_tables | 352064 |
- | Delayed_errors | 0 |
- | Delayed_insert_threads | 1 |
- | Delayed_writes | 868 |
- | Flush_commands | 1 |
- | Handler_commit | 2185411 |
- | Handler_delete | 116178 |
- | Handler_discover | 0 |
- | Handler_prepare | 0 |
- | Handler_read_first | 803599 |
- | Handler_read_key | 159210441 |
- | Handler_read_last | 82920 |
- | Handler_read_next | 3938938489 |
- | Handler_read_prev | 7082048 |
- | Handler_read_rnd | 99297839 |
- | Handler_read_rnd_next | 3683610774 |
- | Handler_rollback | 5 |
- | Handler_savepoint | 0 |
- | Handler_savepoint_rollback | 0 |
- | Handler_update | 4323651 |
- | Handler_write | 207662598 |
- | Innodb_buffer_pool_pages_data | 8180 |
- | Innodb_buffer_pool_bytes_data | 134021120 |
- | Innodb_buffer_pool_pages_dirty | 83 |
- | Innodb_buffer_pool_bytes_dirty | 1359872 |
- | Innodb_buffer_pool_pages_flushed | 512701 |
- | Innodb_buffer_pool_pages_free | 0 |
- | Innodb_buffer_pool_pages_misc | 11 |
- | Innodb_buffer_pool_pages_total | 8191 |
- | Innodb_buffer_pool_read_ahead_rnd | 0 |
- | Innodb_buffer_pool_read_ahead | 14581 |
- | Innodb_buffer_pool_read_ahead_evicted | 253 |
- | Innodb_buffer_pool_read_requests | 337881640 |
- | Innodb_buffer_pool_reads | 16635307 |
- | Innodb_buffer_pool_wait_free | 0 |
- | Innodb_buffer_pool_write_requests | 3090483 |
- | Innodb_data_fsyncs | 314717 |
- | Innodb_data_pending_fsyncs | 1 |
- | Innodb_data_pending_reads | 0 |
- | Innodb_data_pending_writes | 0 |
- | Innodb_data_read | 272834547712 |
- | Innodb_data_reads | 16667682 |
- | Innodb_data_writes | 797287 |
- | Innodb_data_written | 17168151552 |
- | Innodb_dblwr_pages_written | 512701 |
- | Innodb_dblwr_writes | 9799 |
- | Innodb_have_atomic_builtins | ON |
- | Innodb_log_waits | 0 |
- | Innodb_log_write_requests | 592731 |
- | Innodb_log_writes | 253921 |
- | Innodb_os_log_fsyncs | 260400 |
- | Innodb_os_log_pending_fsyncs | 1 |
- | Innodb_os_log_pending_writes | 0 |
- | Innodb_os_log_written | 365658624 |
- | Innodb_page_size | 16384 |
- | Innodb_pages_created | 24589 |
- | Innodb_pages_read | 16652365 |
- | Innodb_pages_written | 512701 |
- | Innodb_row_lock_current_waits | 0 |
- | Innodb_row_lock_time | 154308 |
- | Innodb_row_lock_time_avg | 31 |
- | Innodb_row_lock_time_max | 13214 |
- | Innodb_row_lock_waits | 4940 |
- | Innodb_rows_deleted | 84788 |
- | Innodb_rows_inserted | 454116 |
- | Innodb_rows_read | 342461085 |
- | Innodb_rows_updated | 162401 |
- | Innodb_truncated_status_writes | 0 |
- | Key_blocks_not_flushed | 0 |
- | Key_blocks_unused | 5398 |
- | Key_blocks_used | 6698 |
- | Key_read_requests | 729095477 |
- | Key_reads | 1076574 |
- | Key_write_requests | 74558545 |
- | Key_writes | 421893 |
- | Last_query_cost | 0.000000 |
- | Max_used_connections | 47 |
- | Not_flushed_delayed_rows | 0 |
- | Open_files | 314 |
- | Open_streams | 0 |
- | Open_table_definitions | 400 |
- | Open_tables | 400 |
- | Opened_files | 29086578 |
- | Opened_table_definitions | 16967865 |
- | Opened_tables | 17085728 |
- | Performance_schema_cond_classes_lost | 0 |
- | Performance_schema_cond_instances_lost | 0 |
- | Performance_schema_file_classes_lost | 0 |
- | Performance_schema_file_handles_lost | 0 |
- | Performance_schema_file_instances_lost | 0 |
- | Performance_schema_locker_lost | 0 |
- | Performance_schema_mutex_classes_lost | 0 |
- | Performance_schema_mutex_instances_lost | 0 |
- | Performance_schema_rwlock_classes_lost | 0 |
- | Performance_schema_rwlock_instances_lost | 0 |
- | Performance_schema_table_handles_lost | 0 |
- | Performance_schema_table_instances_lost | 0 |
- | Performance_schema_thread_classes_lost | 0 |
- | Performance_schema_thread_instances_lost | 0 |
- | Prepared_stmt_count | 0 |
- | Qcache_free_blocks | 0 |
- | Qcache_free_memory | 0 |
- | Qcache_hits | 0 |
- | Qcache_inserts | 0 |
- | Qcache_lowmem_prunes | 0 |
- | Qcache_not_cached | 0 |
- | Qcache_queries_in_cache | 0 |
- | Qcache_total_blocks | 0 |
- | Queries | 12287493 |
- | Questions | 12180887 |
- | Rpl_status | AUTH_MASTER |
- | Select_full_join | 1832 |
- | Select_full_range_join | 32 |
- | Select_range | 162096 |
- | Select_range_check | 106 |
- | Select_scan | 2351142 |
- | Slave_heartbeat_period | 0.000 |
- | Slave_open_temp_tables | 0 |
- | Slave_received_heartbeats | 0 |
- | Slave_retried_transactions | 0 |
- | Slave_running | OFF |
- | Slow_launch_threads | 0 |
- | Slow_queries | 220 |
- | Sort_merge_passes | 1235 |
- | Sort_range | 419949 |
- | Sort_rows | 130900397 |
- | Sort_scan | 1193552 |
- | Ssl_accept_renegotiates | 0 |
- | Ssl_accepts | 0 |
- | Ssl_callback_cache_hits | 0 |
- | Ssl_cipher | |
- | Ssl_cipher_list | |
- | Ssl_client_connects | 0 |
- | Ssl_connect_renegotiates | 0 |
- | Ssl_ctx_verify_depth | 0 |
- | Ssl_ctx_verify_mode | 0 |
- | Ssl_default_timeout | 0 |
- | Ssl_finished_accepts | 0 |
- | Ssl_finished_connects | 0 |
- | Ssl_session_cache_hits | 0 |
- | Ssl_session_cache_misses | 0 |
- | Ssl_session_cache_mode | NONE |
- | Ssl_session_cache_overflows | 0 |
- | Ssl_session_cache_size | 0 |
- | Ssl_session_cache_timeouts | 0 |
- | Ssl_sessions_reused | 0 |
- | Ssl_used_session_cache_entries | 0 |
- | Ssl_verify_depth | 0 |
- | Ssl_verify_mode | 0 |
- | Ssl_version | |
- | Table_locks_immediate | 12479287 |
- | Table_locks_waited | 4507 |
- | Tc_log_max_pages_used | 0 |
- | Tc_log_page_size | 0 |
- | Tc_log_page_waits | 0 |
- | Threads_cached | 0 |
- | Threads_connected | 8 |
- | Threads_created | 292627 |
- | Threads_running | 4 |
- | Uptime | 54850 |
- | Uptime_since_flush_status | 54850 |
- +------------------------------------------+--------------+
- +--------+---------------+-----------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
- | Id | User | Host | db | Command | Time | State | Info |
- +--------+---------------+-----------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
- | 75 | eximstats | localhost | eximstats | Sleep | 72 | | |
- | 282769 | DELAYED | localhost | eximstats | Delayed insert | 72 | Waiting for INSERT | |
- | 290066 | terrahar_matt | localhost | terrahar_wp | Sleep | 4 | | |
- | 290261 | leechprotect | localhost | leechprotect | Sleep | 281 | | |
- | 290496 | babilosa_db | localhost | babilosa_wp | Sleep | 0 | | |
- | 292686 | babilosa_db | localhost | babilosa_wp | Query | 0 | query end | UPDATE `e4tfya_options` SET `option_value` = 'a:3:{s:5:\"hooks\";a:2:{s:24:\"ai1ec_purge_events_cach |
- | 292699 | terrahar_matt | localhost | terrahar_wp | Query | 0 | query end | update oqms0w9y2_wfFileMods set oldMD5 = newMD5 where filenameMD5='????j?J?w?HQ?N?' |
- | 292715 | babilosa_db | localhost | babilosa_wp | Query | 0 | query end | UPDATE `e4tfya_options` SET `option_value` = 'a:18:{i:1388767585;a:1:{s:12:\"ai1ec_n_cron\";a:1:{s:3 |
- | 292721 | root | localhost | | Query | 0 | | show processlist |
- +--------+---------------+-----------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
- ------------------------------------
- INNODB Buffer Pool Stats
- ------------------------------------
- *************************** 1. row ***************************
- POOL_ID: 0
- POOL_SIZE: 8191
- FREE_BUFFERS: 0
- DATABASE_PAGES: 8180
- OLD_DATABASE_PAGES: 2999
- MODIFIED_DATABASE_PAGES: 83
- PENDING_DECOMPRESS: 0
- PENDING_READS: 0
- PENDING_FLUSH_LRU: 0
- PENDING_FLUSH_LIST: 0
- PAGES_MADE_YOUNG: 16683363
- PAGES_NOT_MADE_YOUNG: 0
- PAGES_MADE_YOUNG_RATE: 6144.87279191201
- PAGES_MADE_NOT_YOUNG_RATE: 0
- NUMBER_PAGES_READ: 16652365
- NUMBER_PAGES_CREATED: 24589
- NUMBER_PAGES_WRITTEN: 512701
- PAGES_READ_RATE: 6104.432840795467
- PAGES_CREATE_RATE: 0.6665926008221309
- PAGES_WRITTEN_RATE: 20.886568159093436
- NUMBER_PAGES_GET: 337881640
- HIT_RATE: 849
- YOUNG_MAKE_PER_THOUSAND_GETS: 152
- NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0
- NUMBER_PAGES_READ_AHEAD: 14581
- NUMBER_READ_AHEAD_EVICTED: 253
- READ_AHEAD_RATE: 0
- READ_AHEAD_EVICTED_RATE: 0
- LRU_IO_TOTAL: 94758
- LRU_IO_CURRENT: 3557
- UNCOMPRESS_TOTAL: 0
- UNCOMPRESS_CURRENT: 0
- ----------------------------
- INNODB Status
- ----------------------------
- *************************** 1. row ***************************
- Type: InnoDB
- Name:
- Status:
- =====================================
- 140103 17:46:25 INNODB MONITOR OUTPUT
- =====================================
- Per second averages calculated from the last 9 seconds
- -----------------
- BACKGROUND THREAD
- -----------------
- srv_master_thread loops: 46411 1_second, 46064 sleeps, 4608 10_second, 349 background, 348 flush
- srv_master_thread log flush and writes: 49587
- ----------
- SEMAPHORES
- ----------
- OS WAIT ARRAY INFO: reservation count 19384, signal count 17490
- Mutex spin waits 213335, rounds 932730, OS waits 7677
- RW-shared spins 8802, rounds 234550, OS waits 6919
- RW-excl spins 715, rounds 142743, OS waits 4447
- Spin rounds per wait: 4.37 mutex, 26.65 RW-shared, 199.64 RW-excl
- ------------------------
- LATEST FOREIGN KEY ERROR
- ------------------------
- 140103 14:05:19 Error in foreign key constraint of table cptmpdb_webodevi_x69kvpu69dDgw4T3/cache_messages:
- FOREIGN KEY (`user_id`)
- REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
- INDEX `changed_index` (`changed`),
- PRIMARY KEY (`user_id`, `mailbox`, `uid`)
- ) :
- Cannot resolve table name close to:
- (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
- INDEX `changed_index` (`changed`),
- PRIMARY KEY (`user_id`, `mailbox`, `uid`)
- )
- ------------
- TRANSACTIONS
- ------------
- Trx id counter 3CE58AC6
- Purge done for trx's n:o < 3CE57B03 undo n:o < 0
- History list length 3433
- LIST OF TRANSACTIONS FOR EACH SESSION:
- ---TRANSACTION 0, not started
- MySQL thread id 292723, OS thread handle 0x7fb636292700, query id 12287500 localhost root
- show engine innodb status
- ---TRANSACTION 3CE58AC4, not started flushing log
- mysql tables in use 1, locked 1
- MySQL thread id 292715, OS thread handle 0x7fb633548700, query id 12287490 localhost babilosa_db query end
- UPDATE `e4tfya_options` SET `option_value` = 'a:18:{i:1388767585;a:1:{s:12:\"ai1ec_n_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1388767639;a:1:{s:13:\"backwpup_cron\";a:1:{s:32:\"4ef54d4ada20caa38401a05f7ccc9311\";a:2:{s:8:\"schedule\";b:0;s:4:\"args\";a:1:{s:2:\"id\";s:7:\"restart\";}}}}i:1388768400;a:1:{s:20:\"wp_maybe_auto_update\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1388769217;a:1:{s:20:\"jetpac
- ---TRANSACTION 3CE58ABE, not started flushing log
- mysql tables in use 1, locked 1
- MySQL thread id 292699, OS thread handle 0x7fb633750700, query id 12287412 localhost terrahar_matt query end
- update oqms0w9y2_wfFileMods set oldMD5 = newMD5 where filenameMD5='????j?J?w?HQ?N?'
- ---TRANSACTION 3CE58AC2, not started flushing log
- mysql tables in use 1, locked 1
- MySQL thread id 292686, OS thread handle 0x7fb633444700, query id 12287489 localhost babilosa_db query end
- UPDATE `e4tfya_options` SET `option_value` = 'a:3:{s:5:\"hooks\";a:2:{s:24:\"ai1ec_purge_events_cache\";a:5:{s:4:\"hook\";s:24:\"ai1ec_purge_events_cache\";s:9:\"timestamp\";i:1383218514;s:7:\"version\";s:1:\"0\";s:10:\"recurrence\";s:11:\"every_10800\";s:4:\"freq\";s:2:\"3h\";}s:12:\"ai1ec_n_cron\";a:5:{s:4:\"hook\";s:12:\"ai1ec_n_cron\";s:9:\"timestamp\";i:1388767578;s:7:\"version\";i:107;s:10:\"recurrence\";s:5:\"daily\";s:4:\"freq\";s:2:\"1d\";}}s:5:\"freqs\";a:2:{i:10800;a:3:{s:4:\"hash\";s:11:\"every_10800\";s:4:\"name\";N;s:7:\"seconds\";i:10800;}i:86400;a:3:{s:4:\"hash\";s:11:\"every_8
- ---TRANSACTION 3CE539F0, not started
- MySQL thread id 290496, OS thread handle 0x7fb63608a700, query id 12287376 localhost babilosa_db
- ---TRANSACTION 3CE57B28, not started
- MySQL thread id 290066, OS thread handle 0x7fb635f45700, query id 12282966 localhost terrahar_matt
- --------
- FILE I/O
- --------
- I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
- I/O thread 1 state: waiting for completed aio requests (log thread)
- I/O thread 2 state: waiting for completed aio requests (read thread)
- I/O thread 3 state: waiting for completed aio requests (read thread)
- I/O thread 4 state: waiting for completed aio requests (read thread)
- I/O thread 5 state: waiting for completed aio requests (read thread)
- I/O thread 6 state: waiting for completed aio requests (write thread)
- I/O thread 7 state: waiting for completed aio requests (write thread)
- I/O thread 8 state: waiting for completed aio requests (write thread)
- I/O thread 9 state: waiting for completed aio requests (write thread)
- Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
- ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
- Pending flushes (fsync) log: 1; buffer pool: 0
- 16667682 OS file reads, 797287 OS file writes, 314717 OS fsyncs
- 6104.43 reads/s, 16384 avg bytes/read, 27.55 writes/s, 8.44 fsyncs/s
- -------------------------------------
- INSERT BUFFER AND ADAPTIVE HASH INDEX
- -------------------------------------
- Ibuf: size 1, free list len 6152, seg size 6154, 2627 merges
- merged operations:
- insert 13194, delete mark 200, delete 4
- discarded operations:
- insert 0, delete mark 0, delete 0
- Hash table size 276671, node heap has 11 buffer(s)
- 4469.73 hash searches/s, 1833.80 non-hash searches/s
- ---
- LOG
- ---
- Log sequence number 42677122851
- Log flushed up to 42677114301
- Last checkpoint at 42676986276
- 1 pending log writes, 0 pending chkp writes
- 258532 log i/o's done, 6.11 log i/o's/second
- ----------------------
- BUFFER POOL AND MEMORY
- ----------------------
- Total memory allocated 137363456; in additional pool allocated 0
- Dictionary memory allocated 112191421
- Buffer pool size 8191
- Free buffers 0
- Database pages 8180
- Old database pages 2999
- Modified db pages 83
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 16683363, not young 0
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 16652365, created 24589, written 512701
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- No buffer pool page gets since the last printout
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 8180, unzip_LRU len: 0
- I/O sum[94758]:cur[3557], unzip sum[0]:cur[0]
- --------------
- ROW OPERATIONS
- --------------
- 0 queries inside InnoDB, 0 queries in queue
- 1 read views open inside InnoDB
- Main thread process no. 18929, id 140420562712320, state: sleeping
- Number of rows inserted 454116, updated 162401, deleted 84788, read 342461085
- 1.22 inserts/s, 6.67 updates/s, 0.11 deletes/s, 28420.51 reads/s
- ----------------------------
- END OF INNODB MONITOR OUTPUT
- ============================
- ----------------------------
- MySQL Error Log
- ----------------------------
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_TMW@yourserverhostname'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_nodead@yourserverIP'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user2_tmw@localhost'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_new@localhost'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_nodead@localhost'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_new@yourserverIP'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_TMW@localhost'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_TMW@yourserverIP'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user2_tmw@yourserverhostname'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user2_tmw@yourserverIP'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_nodead@yourserverhostname'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_new@yourserverhostname'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_TMW@yourserverhostname'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user1_nodead@yourserverIP'; Ignoring user
- 140103 14:05:23 [Warning] Found invalid password for user: 'user2_tmw@localhost'; Ignoring user
- Report Complete:
- Fri Jan 3 17:46:25 CET 2014
- ----------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement