Guest User

Untitled

a guest
Jan 3rd, 2014
115
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. -------------------------------------------------------------
  3. System MySQL monitoring stats
  4. mysqlmymonlite.sh - 0.5.0 WHM mysqlmymon.com
  5. compiled by George Liu (eva2000) vbtechsupport.com
  6. -------------------------------------------------------------
  7.  
  8. Report Generated:
  9. Fri Jan 3 17:45:58 CET 2014
  10.  
  11. ----------------------------
  12. MySQL Uptime:
  13. ----------------------------
  14. MySQL server was started 2014-01-03 02:32:15
  15. Uptime: 15 hours 13 min 42 sec
  16. Uptime 54822
  17. Uptime_since_flush_status 54822
  18.  
  19. Max Used Connections: 47/151 (31.13%)
  20. Key Buffer Used: 6.54M/8.00M (81.76%)
  21. Current Key Buffer Usage: 3.62M (45.25%)
  22. InnoDB Buffer Pool: 127.98M/127.98M (100.00%)
  23. Table Locks Waited: 4.50k Rate: 0.1/s (0.04%)
  24. --------------------
  25. Query Cache Limit (bytes): 1048576
  26. Query Cache Min Unit (bytes): 4096
  27. Query Cache Size (bytes): 0
  28. Query Cache Free Mem (bytes): 0
  29. Query Cache Used Mem (bytes): 0
  30. Queries in Query Cache: 1
  31. Query Cache Avg Size (bytes): 0
  32.  
  33. ----------------------------
  34. Hardware Info:
  35. ----------------------------
  36. Processors physical = 1, cores = 4, virtual = 4, hyperthreading = no
  37. 4 3400.201
  38. 4 Intel(R) Xeon(R) CPU E3-1245 V2 @ 3.40GHz
  39. 4 8192 KB
  40.  
  41.  
  42. ----------------------------
  43. TOP stats
  44. ----------------------------
  45.  
  46. Linux 2.6.32-042stab083.2 ((yourserverhostname)) 01/03/14 _x86_64_ (8 CPU)
  47.  
  48. 17:46:00 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
  49. 17:46:02 all 0.13 29.50 6.14 11.23 0.00 0.00 0.13 0.00 52.87
  50. 17:46:02 0 0.51 30.26 6.67 6.67 0.00 0.00 0.51 0.00 55.38
  51. 17:46:02 1 0.00 28.88 6.42 4.28 0.00 0.00 0.00 0.00 60.43
  52. 17:46:02 2 0.00 22.60 2.82 5.08 0.00 0.00 0.00 0.00 69.49
  53. 17:46:02 3 0.00 35.78 7.84 27.45 0.00 0.00 0.00 0.00 28.92
  54. 17:46:02 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  55. 17:46:02 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  56. 17:46:02 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  57. 17:46:02 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  58.  
  59. 17:46:02 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
  60. 17:46:04 all 0.00 20.50 3.27 13.96 0.00 0.00 0.00 0.00 62.26
  61. 17:46:04 0 0.00 40.34 5.58 5.58 0.00 0.00 0.00 0.00 48.50
  62. 17:46:04 1 0.00 8.79 2.20 0.55 0.00 0.00 0.00 0.00 88.46
  63. 17:46:04 2 0.00 2.87 0.57 12.07 0.00 0.00 0.00 0.00 84.48
  64. 17:46:04 3 0.00 23.53 3.92 36.76 0.00 0.00 0.00 0.00 35.78
  65. 17:46:04 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  66. 17:46:04 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  67. 17:46:04 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  68. 17:46:04 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  69.  
  70. Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
  71. Average: all 0.06 24.92 4.68 12.62 0.00 0.00 0.06 0.00 57.66
  72. Average: 0 0.23 35.75 6.07 6.07 0.00 0.00 0.23 0.00 51.64
  73. Average: 1 0.00 18.97 4.34 2.44 0.00 0.00 0.00 0.00 74.25
  74. Average: 2 0.00 12.82 1.71 8.55 0.00 0.00 0.00 0.00 76.92
  75. Average: 3 0.00 29.66 5.88 32.11 0.00 0.00 0.00 0.00 32.35
  76. Average: 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  77. Average: 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  78. Average: 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  79. Average: 7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
  80.  
  81. top - 17:46:04 up 45 days, 6:04, 1 user, load average: 7.17, 4.94, 3.40
  82. Tasks: 119 total, 2 running, 116 sleeping, 1 stopped, 0 zombie
  83. 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
  84. Mem: 31457280k total, 27302468k used, 4154812k free, 0k buffers
  85. Swap: 31457280k total, 181492k used, 31275788k free, 24801192k cached
  86.  
  87. PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
  88. 14675 babilosa 24 4 209m 22m 7488 R 15.9 0.1 0:00.08 php
  89. 6409 nobody 24 4 1332m 77m 11m S 4.0 0.3 0:03.69 httpd
  90. 7160 babilosa 30 10 252m 66m 9096 D 4.0 0.2 0:12.98 php
  91. 18929 mysql 26 6 2530m 798m 5932 S 4.0 2.6 184:12.01 mysqld
  92. 5596 terrahar 30 10 259m 70m 8252 S 2.0 0.2 0:07.52 php
  93. 13007 nobody 24 4 1330m 65m 2436 S 2.0 0.2 0:00.61 httpd
  94. 13699 mailman 28 8 194m 9908 2312 S 2.0 0.0 0:03.72 python
  95. 13722 nobody 24 4 1330m 64m 2444 S 2.0 0.2 0:00.41 httpd
  96. 14031 beautifu 24 4 296m 107m 8792 S 2.0 0.3 0:01.98 php
  97. 1 root 20 0 19232 492 356 S 0.0 0.0 0:13.55 init
  98. 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd/121
  99. 3 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khelper/121
  100. 390 root 28 8 100m 18m 3892 S 0.0 0.1 0:58.34 cpsrvd-ssl
  101. 481 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.91 php
  102. 789 webmhsc 30 10 202m 6976 6972 S 0.0 0.0 0:59.47 php
  103. 888 u9085859 28 8 18948 2148 1740 S 0.0 0.0 0:00.00 pop3
  104. 893 u9085859 28 8 18948 2088 1716 S 0.0 0.0 0:00.00 pop3
  105. 1142 chaletde 28 8 23288 2472 2028 S 0.0 0.0 0:00.00 imap
  106. 1309 root 20 0 64308 200 196 S 0.0 0.0 0:00.00 saslauthd
  107. 1342 root 20 0 64308 24 20 S 0.0 0.0 0:00.00 saslauthd
  108. 1436 root 30 10 132m 148 92 S 0.0 0.0 0:20.73 pure-uploadscri
  109. 1703 root 20 0 21456 204 188 S 0.0 0.0 0:00.03 atd
  110. 1770 chaletde 28 8 25612 2800 2040 S 0.0 0.0 0:00.00 imap
  111. 1783 chaletde 28 8 23284 2412 1992 S 0.0 0.0 0:00.00 imap
  112. 1799 chaletde 28 8 23284 2352 1952 S 0.0 0.0 0:00.00 imap
  113. 1848 chaletde 28 8 23300 2616 2104 S 0.0 0.0 0:00.00 imap
  114. 2924 root 16 -4 10644 188 184 S 0.0 0.0 0:00.00 udevd
  115. 2954 nobody 24 4 1292m 75m 11m S 0.0 0.2 0:01.74 httpd
  116. 5009 root 20 0 66608 500 408 S 0.0 0.0 0:00.01 sshd
  117. 5218 root 20 0 237m 3824 816 S 0.0 0.0 0:35.44 rsyslogd
  118. 5701 root 20 0 11444 736 316 S 0.0 0.0 0:00.00 bash
  119. 5702 root 20 0 4076 556 472 S 0.0 0.0 0:00.00 tee
  120. 5703 root 20 0 4064 660 564 S 0.0 0.0 0:00.00 logger
  121. 5765 cpanelro 28 8 100m 17m 2808 S 0.0 0.1 0:00.02 cpsrvd-ssl
  122. 5976 webmhsc 30 10 202m 6980 6976 S 0.0 0.0 0:59.45 php
  123. 6187 named 28 8 413m 95m 2296 S 0.0 0.3 7:04.32 named
  124. 6363 nobody 24 4 170m 56m 732 S 0.0 0.2 0:00.00 httpd
  125. 6364 root 28 8 51072 9232 2284 S 0.0 0.0 0:00.04 leechprotect
  126. 6372 nobody 24 4 1332m 76m 10m S 0.0 0.2 0:02.07 httpd
  127. 6629 root 28 8 54776 9496 1668 S 0.0 0.0 0:43.09 tailwatchd
  128. 6700 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.59 php
  129. 6782 webmhsc 30 10 202m 7928 6976 S 0.0 0.0 0:59.86 php
  130. 7644 nobody 24 4 1316m 64m 2676 S 0.0 0.2 0:00.41 httpd
  131. 8664 u9085859 28 8 18948 2092 1716 S 0.0 0.0 0:00.00 pop3
  132. 8686 u9085859 28 8 18948 2152 1740 S 0.0 0.0 0:00.00 pop3
  133. 8901 cpanelro 28 8 100m 17m 2808 S 0.0 0.1 0:00.01 cpsrvd-ssl
  134. 9351 misterpa 30 10 214m 8312 8268 S 0.0 0.0 0:10.60 php
  135. 9355 webmhsc 30 10 202m 11m 6972 S 0.0 0.0 0:59.47 php
  136. 9571 nobody 24 4 1330m 75m 11m S 0.0 0.2 0:01.30 httpd
  137. 9597 root 20 0 11444 732 316 S 0.0 0.0 0:00.00 bash
  138. 9598 root 20 0 4076 548 468 S 0.0 0.0 0:00.00 tee
  139. 9599 root 20 0 4064 660 564 S 0.0 0.0 0:00.00 logger
  140. 11349 skydefrc 30 10 135m 868 640 S 0.0 0.0 0:00.00 pure-ftpd
  141. 11350 root 30 10 135m 368 216 S 0.0 0.0 0:00.00 pure-ftpd
  142. 11593 nobody 24 4 1322m 68m 3056 S 0.0 0.2 0:01.14 httpd
  143. 11714 root 20 0 9696 1896 1152 S 0.0 0.0 0:00.00 mysqlmymonlite.
  144. 11924 root 28 8 19600 1124 816 S 0.0 0.0 0:00.63 dovecot
  145. 11938 dovenull 28 8 42736 3852 2660 S 0.0 0.0 0:00.71 pop3-login
  146. 11939 dovenull 28 8 42740 3788 2656 S 0.0 0.0 0:00.40 imap-login
  147. 11940 dovecot 28 8 13304 1128 932 S 0.0 0.0 0:00.20 anvil
  148. 11941 root 28 8 13436 1312 968 S 0.0 0.0 0:00.33 log
  149. 11943 dovenull 28 8 42484 3632 2644 S 0.0 0.0 0:00.24 pop3-login
  150. 11944 root 28 8 16412 2116 1096 S 0.0 0.0 0:00.57 config
  151. 11945 dovenull 28 8 43076 4228 2700 S 0.0 0.0 0:01.19 imap-login
  152. 12555 root 28 8 174m 62m 3308 S 0.0 0.2 0:10.46 spamd child
  153. 13093 root 20 0 98300 4060 3096 S 0.0 0.0 0:00.01 sshd
  154. 13161 root 20 0 57684 2232 1620 S 0.0 0.0 0:00.00 sftp-server
  155. 13689 mailman 28 8 199m 8428 612 S 0.0 0.0 0:00.00 mailmanctl
  156. 13697 mailman 28 8 194m 9908 2312 S 0.0 0.0 0:03.70 python
  157. 13698 mailman 28 8 195m 9968 2312 S 0.0 0.0 0:04.02 python
  158. 13700 mailman 28 8 195m 9900 2312 S 0.0 0.0 0:03.67 python
  159. 13701 mailman 28 8 195m 9988 2312 S 0.0 0.0 0:03.79 python
  160. 13702 mailman 28 8 195m 9.8m 2312 S 0.0 0.0 0:04.09 python
  161. 13703 mailman 28 8 194m 9908 2312 S 0.0 0.0 0:03.75 python
  162. 13704 mailman 28 8 194m 9908 2312 S 0.0 0.0 0:00.05 python
  163. 13814 root 24 4 170m 67m 11m S 0.0 0.2 0:37.90 httpd
  164. 14198 root 28 8 421m 230m 1268 S 0.0 0.7 0:21.05 clamd
  165. 14205 mailnull 28 8 71536 2980 704 S 0.0 0.0 0:00.28 exim
  166. 14235 root 28 8 162m 51m 3268 S 0.0 0.2 0:04.92 /usr/local/cpan
  167. 14311 nobody 24 4 1306m 61m 2456 S 0.0 0.2 0:00.08 httpd
  168. 14565 beautifu 24 4 282m 93m 8632 D 0.0 0.3 0:01.44 php
  169. 14595 babilosa 24 4 250m 61m 8656 S 0.0 0.2 0:00.71 php
  170. 14665 root 20 0 15028 1168 876 R 0.0 0.0 0:00.00 top
  171. 14783 rubbi 28 8 23064 2128 1748 S 0.0 0.0 0:00.00 imap
  172. 14793 rubbi 28 8 23260 2416 2000 S 0.0 0.0 0:00.00 imap
  173. 15161 chaletde 28 8 23888 3096 2148 S 0.0 0.0 0:00.06 imap
  174. 18617 root 20 0 11444 540 316 S 0.0 0.0 0:00.00 bash
  175. 18618 root 20 0 4076 536 452 S 0.0 0.0 0:00.00 tee
  176. 18619 root 20 0 4064 648 556 S 0.0 0.0 0:00.00 logger
  177. 18804 root 20 0 11308 1512 1224 S 0.0 0.0 0:00.00 mysqld_safe
  178. 18866 root 30 10 135m 1408 1336 S 0.0 0.0 0:01.28 pure-ftpd
  179. 18868 root 28 8 133m 1388 1340 S 0.0 0.0 0:01.14 pure-authd
  180. 19198 root 28 8 141m 3404 1324 S 0.0 0.0 1:21.78 /usr/local/cpan
  181. 19630 audiotel 28 8 23276 2344 1932 S 0.0 0.0 0:00.05 imap
  182. 19640 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.82 php
  183. 19645 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.89 php
  184. 20492 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.91 php
  185. 23030 audiotel 28 8 23264 2516 1904 S 0.0 0.0 0:00.09 imap
  186. 23535 misterpa 30 10 214m 8308 8264 S 0.0 0.0 0:10.97 php
  187. 23568 root 20 0 98480 4504 3424 S 0.0 0.0 0:00.13 sshd
  188. 23626 root 20 0 11444 1836 1424 S 0.0 0.0 0:00.03 bash
  189. 23681 root 20 0 148m 7260 1444 S 0.0 0.0 1:34.04 lfd - sleeping
  190. 24062 root 20 0 114m 1348 644 S 0.0 0.0 0:03.87 crond
  191. 24386 misterpa 30 10 214m 8304 8260 S 0.0 0.0 0:10.81 php
  192. 25741 misterpa 30 10 214m 8304 8260 S 0.0 0.0 0:10.91 php
  193. 25821 misterpa 30 10 214m 8304 8260 S 0.0 0.0 0:10.75 php
  194. 26805 root 28 8 19408 1524 1180 S 0.0 0.0 0:00.00 ssl-params
  195. 27774 thmail 28 8 23300 2368 1956 S 0.0 0.0 0:00.00 imap
  196. 27784 thmail 28 8 26784 3348 2204 S 0.0 0.0 0:00.01 imap
  197. 27801 thmail 28 8 25676 3140 2180 S 0.0 0.0 0:00.00 imap
  198. 27813 thmail 28 8 23060 2420 2000 S 0.0 0.0 0:00.00 imap
  199. 30099 root 20 0 15396 1156 824 T 0.0 0.0 0:00.12 find
  200. 30289 root 28 8 33264 3904 1444 S 0.0 0.0 0:05.06 queueprocd - wa
  201. 30404 root 28 8 107m 3748 1296 S 0.0 0.0 0:09.56 dnsadmin - serv
  202. 30407 webmhsc 30 10 202m 6980 6976 S 0.0 0.0 0:59.55 php
  203. 30481 root 28 8 23532 2188 1472 S 0.0 0.0 0:35.42 cpdavd-dormant
  204. 30497 root 38 18 27112 2536 1156 S 0.0 0.0 0:00.92 cpanellogd - sl
  205. 30771 root 28 8 45188 2576 2188 S 0.0 0.0 0:12.53 cPhulkd - proce
  206. 31902 dovecot 28 8 29432 1816 1256 S 0.0 0.0 0:00.83 auth
  207.  
  208.  
  209. total used free shared buffers cached
  210. Mem: 30720 26667 4052 0 0 24220
  211. Low: 30720 26667 4052
  212. High: 0 0 0
  213. -/+ buffers/cache: 2447 28272
  214. Swap: 30720 177 30542
  215.  
  216. MemTotal: 31457280 kB
  217. MemFree: 4150176 kB
  218. Cached: 24801332 kB
  219. Buffers: 0 kB
  220. Active: 7439920 kB
  221. Inactive: 19392680 kB
  222. Active(anon): 1504724 kB
  223. Inactive(anon): 526544 kB
  224. Active(file): 5935196 kB
  225. Inactive(file): 18866136 kB
  226. Unevictable: 0 kB
  227. Mlocked: 0 kB
  228. SwapTotal: 31457280 kB
  229. SwapFree: 31275788 kB
  230. Dirty: 15052 kB
  231. Writeback: 0 kB
  232. AnonPages: 2031268 kB
  233. Shmem: 13400 kB
  234. Slab: 474408 kB
  235. SReclaimable: 432580 kB
  236. SUnreclaim: 41828 kB
  237.  
  238.  
  239. Private + Shared = RAM used Program
  240.  
  241. 4.0 KiB + 17.5 KiB = 21.5 KiB udevd
  242. 44.0 KiB + 64.5 KiB = 108.5 KiB atd
  243. 56.0 KiB + 63.0 KiB = 119.0 KiB pure-authd
  244. 60.0 KiB + 60.5 KiB = 120.5 KiB pure-uploadscript
  245. 0.0 KiB + 192.0 KiB = 192.0 KiB saslauthd (2)
  246. 208.0 KiB + 34.0 KiB = 242.0 KiB anvil
  247. 248.0 KiB + 57.5 KiB = 305.5 KiB tee (3)
  248. 284.0 KiB + 51.5 KiB = 335.5 KiB logger (3)
  249. 240.0 KiB + 99.0 KiB = 339.0 KiB init
  250. 356.0 KiB + 36.0 KiB = 392.0 KiB log
  251. 356.0 KiB + 42.5 KiB = 398.5 KiB dovecot
  252. 356.0 KiB + 43.5 KiB = 399.5 KiB ssl-params
  253. 292.0 KiB + 169.5 KiB = 461.5 KiB mysqld_safe
  254. 448.0 KiB + 29.0 KiB = 477.0 KiB find
  255. 456.0 KiB + 262.0 KiB = 718.0 KiB pure-ftpd (3)
  256. 388.0 KiB + 333.0 KiB = 721.0 KiB cPhulkd - proce
  257. 696.0 KiB + 55.0 KiB = 751.0 KiB auth
  258. 748.0 KiB + 34.5 KiB = 782.5 KiB crond
  259. 660.0 KiB + 153.0 KiB = 813.0 KiB sftp-server
  260. 752.0 KiB + 166.5 KiB = 918.5 KiB mysqlmymonlite.
  261. 848.0 KiB + 218.0 KiB = 1.0 MiB cpdavd-dormant
  262. 1.0 MiB + 39.0 KiB = 1.1 MiB config
  263. 908.0 KiB + 542.0 KiB = 1.4 MiB bash (4)
  264. 1.3 MiB + 112.0 KiB = 1.5 MiB cpanellogd - sl
  265. 1.5 MiB + 380.0 KiB = 1.9 MiB pop3 (4)
  266. 2.1 MiB + 313.0 KiB = 2.4 MiB pop3-login (2)
  267. 2.4 MiB + 70.5 KiB = 2.5 MiB exim
  268. 2.4 MiB + 198.0 KiB = 2.6 MiB dnsadmin - serv
  269. 2.5 MiB + 129.5 KiB = 2.6 MiB queueprocd - wa
  270. 2.6 MiB + 330.0 KiB = 2.9 MiB imap-login (2)
  271. 3.1 MiB + 42.0 KiB = 3.2 MiB rsyslogd
  272. 2.2 MiB + 1.3 MiB = 3.5 MiB sshd (3)
  273. 5.7 MiB + 147.0 KiB = 5.8 MiB lfd - sleeping
  274. 6.8 MiB + 372.0 KiB = 7.1 MiB leechprotect
  275. 7.6 MiB + 115.5 KiB = 7.7 MiB mailmanctl
  276. 7.7 MiB + 240.0 KiB = 7.9 MiB tailwatchd
  277. 8.2 MiB + 1.5 MiB = 9.7 MiB imap (14)
  278. 9.5 MiB + 13.6 MiB = 23.2 MiB cpsrvd-ssl (3)
  279. 27.7 MiB + 11.9 MiB = 39.6 MiB /usr/local/cpan (2)
  280. 37.6 MiB + 11.7 MiB = 49.4 MiB spamd child
  281. 59.6 MiB + 1.2 MiB = 60.9 MiB python (8)
  282. 94.9 MiB + 91.0 KiB = 95.0 MiB named
  283. 145.7 MiB + 66.3 MiB = 212.0 MiB httpd (11)
  284. 229.5 MiB + 54.0 KiB = 229.5 MiB clamd
  285. 397.9 MiB + 8.9 MiB = 406.7 MiB php (21)
  286. 797.8 MiB + 156.0 KiB = 797.9 MiB mysqld
  287. ---------------------------------
  288. 1.9 GiB
  289. =================================
  290.  
  291. Private + Shared = RAM used Program
  292.  
  293. ----------------------------
  294. MySQL datadir disk usage
  295. ----------------------------
  296. /var/lib/mysql/ uses 16734064 kilobytes of disk space
  297.  
  298. ----------------------------
  299. ulimit -aH
  300. ----------------------------
  301. core file size (blocks, -c) 1000000
  302. data seg size (kbytes, -d) unlimited
  303. scheduling priority (-e) 0
  304. file size (blocks, -f) unlimited
  305. pending signals (-i) 255461
  306. max locked memory (kbytes, -l) 64
  307. max memory size (kbytes, -m) unlimited
  308. open files (-n) 4096
  309. pipe size (512 bytes, -p) 8
  310. POSIX message queues (bytes, -q) 819200
  311. real-time priority (-r) 0
  312. stack size (kbytes, -s) 8192
  313. cpu time (seconds, -t) unlimited
  314. max user processes (-u) 14335
  315. virtual memory (kbytes, -v) unlimited
  316. file locks (-x) unlimited
  317.  
  318. ----------------------------------------------------------
  319. tail -15 /etc/security/limits.conf
  320. ----------------------------------------------------------
  321. # - nice - max nice priority allowed to raise to values: [-20, 19]
  322. # - rtprio - max realtime priority
  323. #
  324. #<domain> <type> <item> <value>
  325. #
  326.  
  327. #* soft core 0
  328. #* hard rss 10000
  329. #@student hard nproc 20
  330. #@faculty soft nproc 20
  331. #@faculty hard nproc 50
  332. #ftp hard nproc 0
  333. #@student - maxlogins 4
  334.  
  335. # End of file
  336.  
  337. ----------------------------------------------------------
  338. mysqld process limits:
  339. cat /proc/18929/limits
  340. ----------------------------------------------------------
  341. Limit Soft Limit Hard Limit Units
  342. Max cpu time unlimited unlimited seconds
  343. Max file size unlimited unlimited bytes
  344. Max data size unlimited unlimited bytes
  345. Max stack size 8388608 8388608 bytes
  346. Max core file size 1024000000 1024000000 bytes
  347. Max resident set unlimited unlimited bytes
  348. Max processes 14335 14335 processes
  349. Max open files 50000 50000 files
  350. Max locked memory 65536 65536 bytes
  351. Max address space unlimited unlimited bytes
  352. Max file locks unlimited unlimited locks
  353. Max pending signals 255461 255461 signals
  354. Max msgqueue size 819200 819200 bytes
  355. Max nice priority 0 0
  356. Max realtime priority 0 0
  357. Max realtime timeout unlimited unlimited us
  358.  
  359. ----------------------------------
  360. CPANEL WEB SERVER & PHP Info:
  361. ----------------------------------
  362. WHM / Cpanel version: 11.40.1.8
  363.  
  364. WHM's PHP Handler config:
  365. /usr/local/cpanel/bin/rebuild_phpconf --current
  366. Available handlers: suphp cgi none
  367. DEFAULT PHP: 5
  368. PHP4 SAPI: none
  369. PHP5 SAPI: suphp
  370. SUEXEC: enabled
  371. RUID2: not installed
  372.  
  373. PHP 5.4.23 (cli) (built: Dec 27 2013 14:01:04)
  374. Copyright (c) 1997-2013 The PHP Group
  375. Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
  376. with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd., and
  377. with Zend Guard Loader v3.3, Copyright (c) 1998-2013, by Zend Technologies
  378.  
  379. System => Linux yourserverhostname 2.6.32-042stab083.2 #1 SMP Fri Nov 8 18:08:40 MSK 2013 x86_64
  380. Build Date => Dec 27 2013 13:59:35
  381.  
  382. 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'
  383.  
  384. Server API | Command Line Interface
  385. Configuration File (php.ini) Path | /usr/local/lib
  386. Loaded Configuration File | /usr/local/lib/php.ini
  387. PHP API | 20100412
  388. Zend Extension Build | API220100525,NTS
  389. PHP Extension Build | API20100525,NTS
  390. DOM/XML API Version | 20031129
  391. Client API version | 5.5.34
  392. Client API library version | 5.5.34
  393. Client API header version | 5.5.34
  394. API Extensions | pdo_mysql
  395. Client API version | mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
  396. Phar API version | 1.1.1
  397.  
  398. display_errors | Off | Off
  399. error_log | error_log | error_log
  400. extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20100525 | /usr/local/lib/php/extensions/no-debug-non-zts-20100525
  401. file_uploads | On | On
  402. log_errors | On | On
  403. log_errors_max_len | 1024 | 1024
  404. max_execution_time | 0 | 0
  405. max_file_uploads | 20 | 20
  406. memory_limit | 320M | 320M
  407. open_basedir | /home:/usr:/tmp:/var/netenberg | /home:/usr:/tmp:/var/netenberg
  408. post_max_size | 20M | 20M
  409. realpath_cache_size | 16K | 16K
  410. realpath_cache_ttl | 120 | 120
  411. sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  412. sql.safe_mode | Off | Off
  413. upload_max_filesize | 20M | 20M
  414. upload_tmp_dir | no value | no value
  415. sqlite3.extension_dir | no value | no value
  416.  
  417. cURL support | enabled
  418. cURL Information | 7.24.0
  419. ZLib Version | 1.2.3
  420. GD Support | enabled
  421. GD Version | bundled (2.1.0 compatible)
  422. FreeType Support | enabled
  423. FreeType Linkage | with freetype
  424. FreeType Version | 2.3.11
  425. GIF Read Support | enabled
  426. GIF Create Support | enabled
  427. JPEG Support | enabled
  428. libJPEG Version | 6b
  429. PNG Support | enabled
  430. libPNG Version | 1.2.49
  431. WBMP Support | enabled
  432. libXML support | active
  433. libXML Compiled Version | 2.9.0
  434. libXML Loaded Version | 20900
  435. libXML streams | enabled
  436. PCRE (Perl Compatible Regular Expressions) Support | enabled
  437. PCRE Library Version | 8.21 2011-12-12
  438. Soap Client | enabled
  439. Soap Server | enabled
  440. ZLib Support | enabled
  441.  
  442.  
  443.  
  444.  
  445.  
  446.  
  447.  
  448. Server version: Apache/2.2.26 (Unix)
  449. Server built: Dec 27 2013 13:55:28
  450. Cpanel::Easy::Apache v3.22.25 rev9999
  451. Server's Module Magic Number: 20051115:33
  452. Server loaded: APR 1.4.8, APR-Util 1.5.2
  453. Compiled using: APR 1.4.8, APR-Util 1.5.2
  454. Architecture: 64-bit
  455. Server MPM: Worker
  456. threaded: yes (fixed thread count)
  457. forked: yes (variable process count)
  458. Server compiled with....
  459. -D APACHE_MPM_DIR="server/mpm/worker"
  460. -D APR_HAS_SENDFILE
  461. -D APR_HAS_MMAP
  462. -D APR_HAVE_IPV6 (IPv4-mapped addresses disabled)
  463. -D APR_USE_SYSVSEM_SERIALIZE
  464. -D APR_USE_PTHREAD_SERIALIZE
  465. -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
  466. -D APR_HAS_OTHER_CHILD
  467. -D AP_HAVE_RELIABLE_PIPED_LOGS
  468. -D DYNAMIC_MODULE_LIMIT=128
  469. -D HTTPD_ROOT="/usr/local/apache"
  470. -D SUEXEC_BIN="/usr/local/apache/bin/suexec"
  471. -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
  472. -D DEFAULT_ERRORLOG="logs/error_log"
  473. -D AP_TYPES_CONFIG_FILE="conf/mime.types"
  474. -D SERVER_CONFIG_FILE="conf/httpd.conf"
  475.  
  476. Loaded Modules:
  477. core_module (static)
  478. authn_file_module (static)
  479. authn_default_module (static)
  480. authz_host_module (static)
  481. authz_groupfile_module (static)
  482. authz_user_module (static)
  483. authz_default_module (static)
  484. auth_basic_module (static)
  485. file_cache_module (static)
  486. cache_module (static)
  487. disk_cache_module (static)
  488. mem_cache_module (static)
  489. include_module (static)
  490. filter_module (static)
  491. deflate_module (static)
  492. log_config_module (static)
  493. logio_module (static)
  494. env_module (static)
  495. expires_module (static)
  496. headers_module (static)
  497. unique_id_module (static)
  498. setenvif_module (static)
  499. version_module (static)
  500. proxy_module (static)
  501. proxy_connect_module (static)
  502. proxy_ftp_module (static)
  503. proxy_http_module (static)
  504. proxy_scgi_module (static)
  505. proxy_ajp_module (static)
  506. proxy_balancer_module (static)
  507. ssl_module (static)
  508. mpm_worker_module (static)
  509. http_module (static)
  510. mime_module (static)
  511. dav_module (static)
  512. status_module (static)
  513. autoindex_module (static)
  514. asis_module (static)
  515. info_module (static)
  516. suexec_module (static)
  517. cgid_module (static)
  518. dav_fs_module (static)
  519. negotiation_module (static)
  520. dir_module (static)
  521. actions_module (static)
  522. speling_module (static)
  523. userdir_module (static)
  524. alias_module (static)
  525. rewrite_module (static)
  526. so_module (static)
  527. bwlimited_module (shared)
  528. suphp_module (shared)
  529. security2_module (shared)
  530.  
  531. Compiled in modules:
  532. core.c
  533. mod_authn_file.c
  534. mod_authn_default.c
  535. mod_authz_host.c
  536. mod_authz_groupfile.c
  537. mod_authz_user.c
  538. mod_authz_default.c
  539. mod_auth_basic.c
  540. mod_file_cache.c
  541. mod_cache.c
  542. mod_disk_cache.c
  543. mod_mem_cache.c
  544. mod_include.c
  545. mod_filter.c
  546. mod_deflate.c
  547. mod_log_config.c
  548. mod_logio.c
  549. mod_env.c
  550. mod_expires.c
  551. mod_headers.c
  552. mod_unique_id.c
  553. mod_setenvif.c
  554. mod_version.c
  555. mod_proxy.c
  556. mod_proxy_connect.c
  557. mod_proxy_ftp.c
  558. mod_proxy_http.c
  559. mod_proxy_scgi.c
  560. mod_proxy_ajp.c
  561. mod_proxy_balancer.c
  562. mod_ssl.c
  563. worker.c
  564. http_core.c
  565. mod_mime.c
  566. mod_dav.c
  567. mod_status.c
  568. mod_autoindex.c
  569. mod_asis.c
  570. mod_info.c
  571. mod_suexec.c
  572. mod_cgid.c
  573. mod_dav_fs.c
  574. mod_negotiation.c
  575. mod_dir.c
  576. mod_actions.c
  577. mod_speling.c
  578. mod_userdir.c
  579. mod_alias.c
  580. mod_rewrite.c
  581. mod_so.c
  582.  
  583.  
  584. -------------------------------
  585. From /usr/local/apache/conf/httpd.conf
  586. -------------------------------
  587. Timeout 300
  588. KeepAlive Off
  589. MaxKeepAliveRequests 100
  590. KeepAliveTimeout 5
  591.  
  592. </IfModule>
  593. StartServers 5
  594. <IfModule prefork.c>
  595. MinSpareServers 5
  596. MaxSpareServers 10
  597. </IfModule>
  598. MinSpareServers 5
  599. MaxSpareServers 10
  600. </IfModule>
  601. ServerLimit 500
  602. MaxClients 500
  603. MaxRequestsPerChild 10000
  604. </IfModule>
  605.  
  606.  
  607. ----------------------------
  608. mysqlreport output
  609. ----------------------------
  610.  
  611. MySQL 5.5.34-cll uptime 0 15:13:53 Fri Jan 3 17:46:08 2014
  612.  
  613. __ Key _________________________________________________________________
  614. Buffer used 6.54M of 8.00M %Used: 81.76
  615. Current 4.00M %Usage: 49.99
  616. Write hit 99.43%
  617. Read hit 99.85%
  618.  
  619. __ Questions ___________________________________________________________
  620. Total 12.17M 222.0/s
  621. DMS 10.84M 197.7/s %Total: 89.08
  622. Com_ 1.26M 23.0/s 10.35
  623. COM_QUIT 292.51k 5.3/s 2.40
  624. -Unknown 223.11k 4.1/s 1.83
  625. Slow 10 s 219 0.0/s 0.00 %DMS: 0.00 Log: OFF
  626. DMS 10.84M 197.7/s 89.08
  627. SELECT 9.86M 179.8/s 81.00 90.93
  628. UPDATE 411.71k 7.5/s 3.38 3.80
  629. INSERT 321.23k 5.9/s 2.64 2.96
  630. DELETE 193.09k 3.5/s 1.59 1.78
  631. REPLACE 57.21k 1.0/s 0.47 0.53
  632. Com_ 1.26M 23.0/s 10.35
  633. set_option 497.05k 9.1/s 4.08
  634. change_db 315.40k 5.8/s 2.59
  635. stmt_close 53.28k 1.0/s 0.44
  636.  
  637. __ Rows ________________________________________________________________
  638. Rows 8.02G 146.2k/s
  639. Using idx 4.11G 74.9k/s %Index: 51.20
  640. Rows/question 658.85
  641.  
  642. __ SELECT and Sort _____________________________________________________
  643. Scan 2.35M 42.9/s %SELECT: 23.85
  644. Range 162.03k 3.0/s 1.64
  645. Full join 1.83k 0.0/s 0.02
  646. Range check 106 0.0/s 0.00
  647. Full rng join 32 0.0/s 0.00
  648. Sort scan 1.19M 21.8/s
  649. Sort range 419.87k 7.7/s
  650. Sort mrg pass 1.24k 0.0/s
  651.  
  652. __ Table Locks _________________________________________________________
  653. Waited 4.50k 0.1/s %Total: 0.04
  654. Immediate 12.46M 227.3/s
  655.  
  656. __ Tables ______________________________________________________________
  657. Open 400 of 400 %Cache: 100.00
  658. Opened 17.03M 310.6/s
  659.  
  660. __ Connections _________________________________________________________
  661. Max used 47 of 151 %Max: 31.13
  662. Total 292.63k 5.3/s
  663.  
  664. __ Created Temp ________________________________________________________
  665. Disk table 175.36k 3.2/s %Disk: 49.83
  666. Table 351.91k 6.4/s Size: 16.0M
  667. File 2.57k 0.0/s
  668.  
  669. __ Threads _____________________________________________________________
  670. Running 7 of 10
  671. Created 292.54k 5.3/s
  672. Slow 0 0/s
  673. Cached 0 of 0 %Hit: 0.03
  674.  
  675. __ Aborted _____________________________________________________________
  676. Clients 248 0.0/s
  677. Connects 53.30k 1.0/s
  678.  
  679. __ Bytes _______________________________________________________________
  680. Sent 106.71G 1.9M/s
  681. Received 2.19G 39.8k/s
  682.  
  683. __ InnoDB Buffer Pool __________________________________________________
  684. Usage 127.98M of 127.98M %Usage: 100.00
  685. Read hit 95.10%
  686. Pages
  687. Free 0 %Total: 0.00
  688. Data 8.19k 99.95 %Drty: 0.79
  689. Misc 4 0.05
  690. Latched 0 0.00
  691. Reads 337.28M 6.2k/s
  692. From disk 16.54M 301.6/s %Disk: 4.90
  693. Ahead Rnd 0 0/s
  694. Writes 3.09M 56.3/s
  695. Wait Free 0 0/s %Wait: 0.00
  696. Flushes 512.38k 9.3/s
  697.  
  698. __ InnoDB Lock _________________________________________________________
  699. Waits 4936 0.1/s
  700. Current 0
  701. Time acquiring
  702. Total 154269 ms
  703. Average 31 ms
  704. Max 13214 ms
  705.  
  706. __ InnoDB Data, Pages, Rows ____________________________________________
  707. Data
  708. Reads 16.57M 302.2/s
  709. Writes 796.86k 14.5/s
  710. fsync 314.58k 5.7/s
  711. Pending
  712. Reads 0
  713. Writes 0
  714. fsync 2
  715.  
  716. Pages
  717. Created 24.58k 0.4/s
  718. Read 16.56M 301.9/s
  719. Written 512.38k 9.3/s
  720.  
  721. Rows
  722. Deleted 84.78k 1.5/s
  723. Inserted 454.08k 8.3/s
  724. Read 342.10M 6.2k/s
  725. Updated 162.28k 3.0/s
  726.  
  727. ----------------------------
  728. Total Server MyISAM and InnoDB Size
  729. ----------------------------
  730. *************************** 1. row ***************************
  731. innodb_tablespace_utilization_perc: 100
  732. total_size_gb: 10.35635173600167
  733. index_size_gb: 2.3308553025126457
  734. data_size_gb: 8.025496433489025
  735. innodb_total_size_gb: 2.789520263671875
  736. innodb_data_size_gb: 2.1698760986328125
  737. innodb_index_size_gb: 0.6196441650390625
  738. myisam_total_size_gb: 7.565571169368923
  739. myisam_data_size_gb: 5.855028490535915
  740. myisam_index_size_gb: 1.7105426788330078
  741. perc_index: 22.506528900
  742. perc_data: 77.493471000
  743. innodb_perc_index: 22.213287800
  744. innodb_perc_data: 77.786712100
  745. myisam_perc_index: 22.609564300
  746. myisam_perc_data: 77.390435600
  747. innodb_perc_total_index: 26.584411400
  748. innodb_perc_total_data: 27.037281900
  749. myisam_perc_total_index: 73.386909800
  750. myisam_perc_total_data: 72.955343400
  751.  
  752. ----------------------------
  753. MySQL settings
  754. ----------------------------
  755. [mysqld]
  756. innodb_file_per_table=1
  757. open_files_limit=50000
  758. ---
  759. +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
  760. | Variable_name | Value |
  761. +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
  762. | auto_increment_increment | 1 |
  763. | auto_increment_offset | 1 |
  764. | autocommit | ON |
  765. | automatic_sp_privileges | ON |
  766. | back_log | 50 |
  767. | basedir | /usr |
  768. | big_tables | OFF |
  769. | binlog_cache_size | 32768 |
  770. | binlog_direct_non_transactional_updates | OFF |
  771. | binlog_format | STATEMENT |
  772. | binlog_stmt_cache_size | 32768 |
  773. | bulk_insert_buffer_size | 8388608 |
  774. | character_set_client | latin1 |
  775. | character_set_connection | latin1 |
  776. | character_set_database | latin1 |
  777. | character_set_filesystem | binary |
  778. | character_set_results | latin1 |
  779. | character_set_server | latin1 |
  780. | character_set_system | utf8 |
  781. | character_sets_dir | /usr/share/mysql/charsets/ |
  782. | collation_connection | latin1_swedish_ci |
  783. | collation_database | latin1_swedish_ci |
  784. | collation_server | latin1_swedish_ci |
  785. | completion_type | NO_CHAIN |
  786. | concurrent_insert | AUTO |
  787. | connect_timeout | 10 |
  788. | datadir | /var/lib/mysql/ |
  789. | date_format | %Y-%m-%d |
  790. | datetime_format | %Y-%m-%d %H:%i:%s |
  791. | default_storage_engine | InnoDB |
  792. | default_week_format | 0 |
  793. | delay_key_write | ON |
  794. | delayed_insert_limit | 100 |
  795. | delayed_insert_timeout | 300 |
  796. | delayed_queue_size | 1000 |
  797. | div_precision_increment | 4 |
  798. | engine_condition_pushdown | ON |
  799. | event_scheduler | OFF |
  800. | expire_logs_days | 0 |
  801. | flush | OFF |
  802. | flush_time | 0 |
  803. | foreign_key_checks | ON |
  804. | ft_boolean_syntax | + -><()~*:""&| |
  805. | ft_max_word_len | 84 |
  806. | ft_min_word_len | 4 |
  807. | ft_query_expansion_limit | 20 |
  808. | ft_stopword_file | (built-in) |
  809. | general_log | OFF |
  810. | general_log_file | /var/lib/mysql/fr1.log |
  811. | group_concat_max_len | 1024 |
  812. | have_compress | YES |
  813. | have_crypt | YES |
  814. | have_csv | YES |
  815. | have_dynamic_loading | YES |
  816. | have_geometry | YES |
  817. | have_innodb | YES |
  818. | have_ndbcluster | NO |
  819. | have_openssl | DISABLED |
  820. | have_partitioning | YES |
  821. | have_profiling | YES |
  822. | have_query_cache | YES |
  823. | have_rtree_keys | YES |
  824. | have_ssl | DISABLED |
  825. | have_symlink | YES |
  826. | hostname | yourserverhostname |
  827. | ignore_builtin_innodb | OFF |
  828. | init_connect | |
  829. | init_file | |
  830. | init_slave | |
  831. | innodb_adaptive_flushing | ON |
  832. | innodb_adaptive_hash_index | ON |
  833. | innodb_additional_mem_pool_size | 8388608 |
  834. | innodb_autoextend_increment | 8 |
  835. | innodb_autoinc_lock_mode | 1 |
  836. | innodb_buffer_pool_instances | 1 |
  837. | innodb_buffer_pool_size | 134217728 |
  838. | innodb_change_buffering | all |
  839. | innodb_checksums | ON |
  840. | innodb_commit_concurrency | 0 |
  841. | innodb_concurrency_tickets | 500 |
  842. | innodb_data_file_path | ibdata1:10M:autoextend |
  843. | innodb_data_home_dir | |
  844. | innodb_doublewrite | ON |
  845. | innodb_fast_shutdown | 1 |
  846. | innodb_file_format | Antelope |
  847. | innodb_file_format_check | ON |
  848. | innodb_file_format_max | Antelope |
  849. | innodb_file_per_table | ON |
  850. | innodb_flush_log_at_trx_commit | 1 |
  851. | innodb_flush_method | |
  852. | innodb_force_load_corrupted | OFF |
  853. | innodb_force_recovery | 0 |
  854. | innodb_io_capacity | 200 |
  855. | innodb_large_prefix | OFF |
  856. | innodb_lock_wait_timeout | 50 |
  857. | innodb_locks_unsafe_for_binlog | OFF |
  858. | innodb_log_buffer_size | 8388608 |
  859. | innodb_log_file_size | 5242880 |
  860. | innodb_log_files_in_group | 2 |
  861. | innodb_log_group_home_dir | ./ |
  862. | innodb_max_dirty_pages_pct | 75 |
  863. | innodb_max_purge_lag | 0 |
  864. | innodb_mirrored_log_groups | 1 |
  865. | innodb_old_blocks_pct | 37 |
  866. | innodb_old_blocks_time | 0 |
  867. | innodb_open_files | 300 |
  868. | innodb_print_all_deadlocks | OFF |
  869. | innodb_purge_batch_size | 20 |
  870. | innodb_purge_threads | 0 |
  871. | innodb_random_read_ahead | OFF |
  872. | innodb_read_ahead_threshold | 56 |
  873. | innodb_read_io_threads | 4 |
  874. | innodb_replication_delay | 0 |
  875. | innodb_rollback_on_timeout | OFF |
  876. | innodb_rollback_segments | 128 |
  877. | innodb_spin_wait_delay | 6 |
  878. | innodb_stats_method | nulls_equal |
  879. | innodb_stats_on_metadata | ON |
  880. | innodb_stats_sample_pages | 8 |
  881. | innodb_strict_mode | OFF |
  882. | innodb_support_xa | ON |
  883. | innodb_sync_spin_loops | 30 |
  884. | innodb_table_locks | ON |
  885. | innodb_thread_concurrency | 0 |
  886. | innodb_thread_sleep_delay | 10000 |
  887. | innodb_use_native_aio | ON |
  888. | innodb_use_sys_malloc | ON |
  889. | innodb_version | 5.5.34 |
  890. | innodb_write_io_threads | 4 |
  891. | interactive_timeout | 28800 |
  892. | join_buffer_size | 131072 |
  893. | keep_files_on_create | OFF |
  894. | key_buffer_size | 8388608 |
  895. | key_cache_age_threshold | 300 |
  896. | key_cache_block_size | 1024 |
  897. | key_cache_division_limit | 100 |
  898. | large_files_support | ON |
  899. | large_page_size | 0 |
  900. | large_pages | OFF |
  901. | lc_messages | en_US |
  902. | lc_messages_dir | /usr/share/mysql/ |
  903. | lc_time_names | en_US |
  904. | license | GPL |
  905. | local_infile | ON |
  906. | lock_wait_timeout | 31536000 |
  907. | locked_in_memory | OFF |
  908. | log | OFF |
  909. | log_bin | OFF |
  910. | log_bin_trust_function_creators | OFF |
  911. | log_error | /var/lib/mysql/yourserverhostname.err |
  912. | log_output | FILE |
  913. | log_queries_not_using_indexes | OFF |
  914. | log_slave_updates | OFF |
  915. | log_slow_queries | OFF |
  916. | log_warnings | 1 |
  917. | long_query_time | 10.000000 |
  918. | low_priority_updates | OFF |
  919. | lower_case_file_system | OFF |
  920. | lower_case_table_names | 0 |
  921. | max_allowed_packet | 1048576 |
  922. | max_binlog_cache_size | 18446744073709547520 |
  923. | max_binlog_size | 1073741824 |
  924. | max_binlog_stmt_cache_size | 18446744073709547520 |
  925. | max_connect_errors | 10 |
  926. | max_connections | 151 |
  927. | max_delayed_threads | 20 |
  928. | max_error_count | 64 |
  929. | max_heap_table_size | 16777216 |
  930. | max_insert_delayed_threads | 20 |
  931. | max_join_size | 18446744073709551615 |
  932. | max_length_for_sort_data | 1024 |
  933. | max_long_data_size | 1048576 |
  934. | max_prepared_stmt_count | 16382 |
  935. | max_relay_log_size | 0 |
  936. | max_seeks_for_key | 18446744073709551615 |
  937. | max_sort_length | 1024 |
  938. | max_sp_recursion_depth | 0 |
  939. | max_tmp_tables | 32 |
  940. | max_user_connections | 0 |
  941. | max_write_lock_count | 18446744073709551615 |
  942. | metadata_locks_cache_size | 1024 |
  943. | min_examined_row_limit | 0 |
  944. | multi_range_count | 256 |
  945. | myisam_data_pointer_size | 6 |
  946. | myisam_max_sort_file_size | 9223372036853727232 |
  947. | myisam_mmap_size | 18446744073709551615 |
  948. | myisam_recover_options | OFF |
  949. | myisam_repair_threads | 1 |
  950. | myisam_sort_buffer_size | 8388608 |
  951. | myisam_stats_method | nulls_unequal |
  952. | myisam_use_mmap | OFF |
  953. | net_buffer_length | 16384 |
  954. | net_read_timeout | 30 |
  955. | net_retry_count | 10 |
  956. | net_write_timeout | 60 |
  957. | new | OFF |
  958. | old | OFF |
  959. | old_alter_table | OFF |
  960. | old_passwords | OFF |
  961. | open_files_limit | 50000 |
  962. | optimizer_prune_level | 1 |
  963. | optimizer_search_depth | 62 |
  964. | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on |
  965. | performance_schema | OFF |
  966. | performance_schema_events_waits_history_long_size | 10000 |
  967. | performance_schema_events_waits_history_size | 10 |
  968. | performance_schema_max_cond_classes | 80 |
  969. | performance_schema_max_cond_instances | 1000 |
  970. | performance_schema_max_file_classes | 50 |
  971. | performance_schema_max_file_handles | 32768 |
  972. | performance_schema_max_file_instances | 10000 |
  973. | performance_schema_max_mutex_classes | 200 |
  974. | performance_schema_max_mutex_instances | 1000000 |
  975. | performance_schema_max_rwlock_classes | 30 |
  976. | performance_schema_max_rwlock_instances | 1000000 |
  977. | performance_schema_max_table_handles | 100000 |
  978. | performance_schema_max_table_instances | 50000 |
  979. | performance_schema_max_thread_classes | 50 |
  980. | performance_schema_max_thread_instances | 1000 |
  981. | pid_file | /var/lib/mysql/yourserverhostname.pid |
  982. | plugin_dir | /usr/lib64/mysql/plugin/ |
  983. | port | 3306 |
  984. | preload_buffer_size | 32768 |
  985. | profiling | OFF |
  986. | profiling_history_size | 15 |
  987. | protocol_version | 10 |
  988. | query_alloc_block_size | 8192 |
  989. | query_cache_limit | 1048576 |
  990. | query_cache_min_res_unit | 4096 |
  991. | query_cache_size | 0 |
  992. | query_cache_type | ON |
  993. | query_cache_wlock_invalidate | OFF |
  994. | query_prealloc_size | 8192 |
  995. | range_alloc_block_size | 4096 |
  996. | read_buffer_size | 131072 |
  997. | read_only | OFF |
  998. | read_rnd_buffer_size | 262144 |
  999. | relay_log | |
  1000. | relay_log_index | |
  1001. | relay_log_info_file | relay-log.info |
  1002. | relay_log_purge | ON |
  1003. | relay_log_recovery | OFF |
  1004. | relay_log_space_limit | 0 |
  1005. | report_host | |
  1006. | report_password | |
  1007. | report_port | 3306 |
  1008. | report_user | |
  1009. | rpl_recovery_rank | 0 |
  1010. | secure_auth | OFF |
  1011. | secure_file_priv | |
  1012. | server_id | 0 |
  1013. | skip_external_locking | ON |
  1014. | skip_name_resolve | OFF |
  1015. | skip_networking | OFF |
  1016. | skip_show_database | OFF |
  1017. | slave_compressed_protocol | OFF |
  1018. | slave_exec_mode | STRICT |
  1019. | slave_load_tmpdir | /tmp |
  1020. | slave_max_allowed_packet | 1073741824 |
  1021. | slave_net_timeout | 3600 |
  1022. | slave_skip_errors | OFF |
  1023. | slave_transaction_retries | 10 |
  1024. | slave_type_conversions | |
  1025. | slow_launch_time | 2 |
  1026. | slow_query_log | OFF |
  1027. | slow_query_log_file | /var/lib/mysql/fr1-slow.log |
  1028. | socket | /var/lib/mysql/mysql.sock |
  1029. | sort_buffer_size | 2097152 |
  1030. | sql_auto_is_null | OFF |
  1031. | sql_big_selects | ON |
  1032. | sql_big_tables | OFF |
  1033. | sql_buffer_result | OFF |
  1034. | sql_log_bin | ON |
  1035. | sql_log_off | OFF |
  1036. | sql_low_priority_updates | OFF |
  1037. | sql_max_join_size | 18446744073709551615 |
  1038. | sql_mode | |
  1039. | sql_notes | ON |
  1040. | sql_quote_show_create | ON |
  1041. | sql_safe_updates | OFF |
  1042. | sql_select_limit | 18446744073709551615 |
  1043. | sql_slave_skip_counter | 0 |
  1044. | sql_warnings | OFF |
  1045. | ssl_ca | |
  1046. | ssl_capath | |
  1047. | ssl_cert | |
  1048. | ssl_cipher | |
  1049. | ssl_key | |
  1050. | storage_engine | InnoDB |
  1051. | stored_program_cache | 256 |
  1052. | sync_binlog | 0 |
  1053. | sync_frm | ON |
  1054. | sync_master_info | 0 |
  1055. | sync_relay_log | 0 |
  1056. | sync_relay_log_info | 0 |
  1057. | system_time_zone | CET |
  1058. | table_definition_cache | 400 |
  1059. | table_open_cache | 400 |
  1060. | thread_cache_size | 0 |
  1061. | thread_concurrency | 10 |
  1062. | thread_handling | one-thread-per-connection |
  1063. | thread_stack | 262144 |
  1064. | thread_statistics | OFF |
  1065. | time_format | %H:%i:%s |
  1066. | time_zone | SYSTEM |
  1067. | timed_mutexes | OFF |
  1068. | tmp_table_size | 16777216 |
  1069. | tmpdir | /tmp |
  1070. | transaction_alloc_block_size | 8192 |
  1071. | transaction_prealloc_size | 4096 |
  1072. | tx_isolation | REPEATABLE-READ |
  1073. | unique_checks | ON |
  1074. | updatable_views_with_limit | YES |
  1075. | userstat | OFF |
  1076. | version | 5.5.34-cll |
  1077. | version_comment | MySQL Community Server (GPL) |
  1078. | version_compile_machine | x86_64 |
  1079. | version_compile_os | Linux |
  1080. | wait_timeout | 28800 |
  1081. +---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
  1082. +------------------------------------------+--------------+
  1083. | Variable_name | Value |
  1084. +------------------------------------------+--------------+
  1085. | Aborted_clients | 248 |
  1086. | Aborted_connects | 53310 |
  1087. | Binlog_cache_disk_use | 0 |
  1088. | Binlog_cache_use | 0 |
  1089. | Binlog_stmt_cache_disk_use | 0 |
  1090. | Binlog_stmt_cache_use | 0 |
  1091. | Bytes_received | 2186985489 |
  1092. | Bytes_sent | 106729882414 |
  1093. | Com_admin_commands | 9419 |
  1094. | Com_assign_to_keycache | 0 |
  1095. | Com_alter_db | 74 |
  1096. | Com_alter_db_upgrade | 0 |
  1097. | Com_alter_event | 0 |
  1098. | Com_alter_function | 0 |
  1099. | Com_alter_procedure | 0 |
  1100. | Com_alter_server | 0 |
  1101. | Com_alter_table | 22397 |
  1102. | Com_alter_tablespace | 0 |
  1103. | Com_analyze | 0 |
  1104. | Com_begin | 15 |
  1105. | Com_binlog | 0 |
  1106. | Com_call_procedure | 0 |
  1107. | Com_change_db | 315485 |
  1108. | Com_change_master | 0 |
  1109. | Com_check | 15 |
  1110. | Com_checksum | 0 |
  1111. | Com_commit | 15 |
  1112. | Com_create_db | 182 |
  1113. | Com_create_event | 0 |
  1114. | Com_create_function | 0 |
  1115. | Com_create_index | 0 |
  1116. | Com_create_procedure | 2 |
  1117. | Com_create_server | 0 |
  1118. | Com_create_table | 11116 |
  1119. | Com_create_trigger | 0 |
  1120. | Com_create_udf | 0 |
  1121. | Com_create_user | 0 |
  1122. | Com_create_view | 0 |
  1123. | Com_dealloc_sql | 0 |
  1124. | Com_delete | 193123 |
  1125. | Com_delete_multi | 11 |
  1126. | Com_do | 0 |
  1127. | Com_drop_db | 64 |
  1128. | Com_drop_event | 0 |
  1129. | Com_drop_function | 0 |
  1130. | Com_drop_index | 0 |
  1131. | Com_drop_procedure | 2 |
  1132. | Com_drop_server | 0 |
  1133. | Com_drop_table | 9859 |
  1134. | Com_drop_trigger | 0 |
  1135. | Com_drop_user | 2 |
  1136. | Com_drop_view | 0 |
  1137. | Com_empty_query | 0 |
  1138. | Com_execute_sql | 0 |
  1139. | Com_flush | 862 |
  1140. | Com_grant | 6308 |
  1141. | Com_ha_close | 0 |
  1142. | Com_ha_open | 0 |
  1143. | Com_ha_read | 0 |
  1144. | Com_help | 0 |
  1145. | Com_insert | 321161 |
  1146. | Com_insert_select | 96 |
  1147. | Com_install_plugin | 0 |
  1148. | Com_kill | 0 |
  1149. | Com_load | 0 |
  1150. | Com_lock_tables | 19126 |
  1151. | Com_optimize | 8 |
  1152. | Com_preload_keys | 0 |
  1153. | Com_prepare_sql | 0 |
  1154. | Com_purge | 0 |
  1155. | Com_purge_before_date | 0 |
  1156. | Com_release_savepoint | 0 |
  1157. | Com_rename_table | 0 |
  1158. | Com_rename_user | 0 |
  1159. | Com_repair | 0 |
  1160. | Com_replace | 57214 |
  1161. | Com_replace_select | 1 |
  1162. | Com_reset | 0 |
  1163. | Com_resignal | 0 |
  1164. | Com_revoke | 0 |
  1165. | Com_revoke_all | 0 |
  1166. | Com_rollback | 0 |
  1167. | Com_rollback_to_savepoint | 0 |
  1168. | Com_savepoint | 0 |
  1169. | Com_select | 9867696 |
  1170. | Com_set_option | 497168 |
  1171. | Com_signal | 0 |
  1172. | Com_show_authors | 0 |
  1173. | Com_show_binlog_events | 0 |
  1174. | Com_show_binlogs | 39 |
  1175. | Com_show_charsets | 0 |
  1176. | Com_show_client_statistics | 0 |
  1177. | Com_show_collations | 0 |
  1178. | Com_show_contributors | 0 |
  1179. | Com_show_create_db | 453 |
  1180. | Com_show_create_event | 0 |
  1181. | Com_show_create_func | 0 |
  1182. | Com_show_create_proc | 1 |
  1183. | Com_show_create_table | 21714 |
  1184. | Com_show_create_trigger | 26 |
  1185. | Com_show_databases | 195 |
  1186. | Com_show_engine_logs | 0 |
  1187. | Com_show_engine_mutex | 0 |
  1188. | Com_show_engine_status | 0 |
  1189. | Com_show_events | 15 |
  1190. | Com_show_errors | 0 |
  1191. | Com_show_fields | 49834 |
  1192. | Com_show_function_status | 4219 |
  1193. | Com_show_grants | 4697 |
  1194. | Com_show_index_statistics | 0 |
  1195. | Com_show_keys | 154 |
  1196. | Com_show_master_status | 10 |
  1197. | Com_show_open_tables | 0 |
  1198. | Com_show_plugins | 0 |
  1199. | Com_show_privileges | 0 |
  1200. | Com_show_procedure_status | 4219 |
  1201. | Com_show_processlist | 184 |
  1202. | Com_show_profile | 0 |
  1203. | Com_show_profiles | 4 |
  1204. | Com_show_relaylog_events | 0 |
  1205. | Com_show_slave_hosts | 0 |
  1206. | Com_show_slave_status | 10 |
  1207. | Com_show_status | 1646 |
  1208. | Com_show_storage_engines | 0 |
  1209. | Com_show_table_statistics | 0 |
  1210. | Com_show_table_status | 46053 |
  1211. | Com_show_tables | 11337 |
  1212. | Com_show_thread_statistics | 0 |
  1213. | Com_show_triggers | 43612 |
  1214. | Com_show_user_statistics | 0 |
  1215. | Com_show_variables | 261 |
  1216. | Com_show_warnings | 39 |
  1217. | Com_slave_start | 0 |
  1218. | Com_slave_stop | 0 |
  1219. | Com_stmt_close | 53303 |
  1220. | Com_stmt_execute | 53303 |
  1221. | Com_stmt_fetch | 0 |
  1222. | Com_stmt_prepare | 53303 |
  1223. | Com_stmt_reprepare | 0 |
  1224. | Com_stmt_reset | 0 |
  1225. | Com_stmt_send_long_data | 0 |
  1226. | Com_truncate | 323 |
  1227. | Com_uninstall_plugin | 0 |
  1228. | Com_unlock_tables | 19220 |
  1229. | Com_update | 407721 |
  1230. | Com_update_multi | 4148 |
  1231. | Com_xa_commit | 0 |
  1232. | Com_xa_end | 0 |
  1233. | Com_xa_prepare | 0 |
  1234. | Com_xa_recover | 0 |
  1235. | Com_xa_rollback | 0 |
  1236. | Com_xa_start | 0 |
  1237. | Compression | OFF |
  1238. | Connections | 292722 |
  1239. | Created_tmp_disk_tables | 175425 |
  1240. | Created_tmp_files | 2570 |
  1241. | Created_tmp_tables | 352064 |
  1242. | Delayed_errors | 0 |
  1243. | Delayed_insert_threads | 1 |
  1244. | Delayed_writes | 868 |
  1245. | Flush_commands | 1 |
  1246. | Handler_commit | 2185411 |
  1247. | Handler_delete | 116178 |
  1248. | Handler_discover | 0 |
  1249. | Handler_prepare | 0 |
  1250. | Handler_read_first | 803599 |
  1251. | Handler_read_key | 159210441 |
  1252. | Handler_read_last | 82920 |
  1253. | Handler_read_next | 3938938489 |
  1254. | Handler_read_prev | 7082048 |
  1255. | Handler_read_rnd | 99297839 |
  1256. | Handler_read_rnd_next | 3683610774 |
  1257. | Handler_rollback | 5 |
  1258. | Handler_savepoint | 0 |
  1259. | Handler_savepoint_rollback | 0 |
  1260. | Handler_update | 4323651 |
  1261. | Handler_write | 207662598 |
  1262. | Innodb_buffer_pool_pages_data | 8180 |
  1263. | Innodb_buffer_pool_bytes_data | 134021120 |
  1264. | Innodb_buffer_pool_pages_dirty | 83 |
  1265. | Innodb_buffer_pool_bytes_dirty | 1359872 |
  1266. | Innodb_buffer_pool_pages_flushed | 512701 |
  1267. | Innodb_buffer_pool_pages_free | 0 |
  1268. | Innodb_buffer_pool_pages_misc | 11 |
  1269. | Innodb_buffer_pool_pages_total | 8191 |
  1270. | Innodb_buffer_pool_read_ahead_rnd | 0 |
  1271. | Innodb_buffer_pool_read_ahead | 14581 |
  1272. | Innodb_buffer_pool_read_ahead_evicted | 253 |
  1273. | Innodb_buffer_pool_read_requests | 337881640 |
  1274. | Innodb_buffer_pool_reads | 16635307 |
  1275. | Innodb_buffer_pool_wait_free | 0 |
  1276. | Innodb_buffer_pool_write_requests | 3090483 |
  1277. | Innodb_data_fsyncs | 314717 |
  1278. | Innodb_data_pending_fsyncs | 1 |
  1279. | Innodb_data_pending_reads | 0 |
  1280. | Innodb_data_pending_writes | 0 |
  1281. | Innodb_data_read | 272834547712 |
  1282. | Innodb_data_reads | 16667682 |
  1283. | Innodb_data_writes | 797287 |
  1284. | Innodb_data_written | 17168151552 |
  1285. | Innodb_dblwr_pages_written | 512701 |
  1286. | Innodb_dblwr_writes | 9799 |
  1287. | Innodb_have_atomic_builtins | ON |
  1288. | Innodb_log_waits | 0 |
  1289. | Innodb_log_write_requests | 592731 |
  1290. | Innodb_log_writes | 253921 |
  1291. | Innodb_os_log_fsyncs | 260400 |
  1292. | Innodb_os_log_pending_fsyncs | 1 |
  1293. | Innodb_os_log_pending_writes | 0 |
  1294. | Innodb_os_log_written | 365658624 |
  1295. | Innodb_page_size | 16384 |
  1296. | Innodb_pages_created | 24589 |
  1297. | Innodb_pages_read | 16652365 |
  1298. | Innodb_pages_written | 512701 |
  1299. | Innodb_row_lock_current_waits | 0 |
  1300. | Innodb_row_lock_time | 154308 |
  1301. | Innodb_row_lock_time_avg | 31 |
  1302. | Innodb_row_lock_time_max | 13214 |
  1303. | Innodb_row_lock_waits | 4940 |
  1304. | Innodb_rows_deleted | 84788 |
  1305. | Innodb_rows_inserted | 454116 |
  1306. | Innodb_rows_read | 342461085 |
  1307. | Innodb_rows_updated | 162401 |
  1308. | Innodb_truncated_status_writes | 0 |
  1309. | Key_blocks_not_flushed | 0 |
  1310. | Key_blocks_unused | 5398 |
  1311. | Key_blocks_used | 6698 |
  1312. | Key_read_requests | 729095477 |
  1313. | Key_reads | 1076574 |
  1314. | Key_write_requests | 74558545 |
  1315. | Key_writes | 421893 |
  1316. | Last_query_cost | 0.000000 |
  1317. | Max_used_connections | 47 |
  1318. | Not_flushed_delayed_rows | 0 |
  1319. | Open_files | 314 |
  1320. | Open_streams | 0 |
  1321. | Open_table_definitions | 400 |
  1322. | Open_tables | 400 |
  1323. | Opened_files | 29086578 |
  1324. | Opened_table_definitions | 16967865 |
  1325. | Opened_tables | 17085728 |
  1326. | Performance_schema_cond_classes_lost | 0 |
  1327. | Performance_schema_cond_instances_lost | 0 |
  1328. | Performance_schema_file_classes_lost | 0 |
  1329. | Performance_schema_file_handles_lost | 0 |
  1330. | Performance_schema_file_instances_lost | 0 |
  1331. | Performance_schema_locker_lost | 0 |
  1332. | Performance_schema_mutex_classes_lost | 0 |
  1333. | Performance_schema_mutex_instances_lost | 0 |
  1334. | Performance_schema_rwlock_classes_lost | 0 |
  1335. | Performance_schema_rwlock_instances_lost | 0 |
  1336. | Performance_schema_table_handles_lost | 0 |
  1337. | Performance_schema_table_instances_lost | 0 |
  1338. | Performance_schema_thread_classes_lost | 0 |
  1339. | Performance_schema_thread_instances_lost | 0 |
  1340. | Prepared_stmt_count | 0 |
  1341. | Qcache_free_blocks | 0 |
  1342. | Qcache_free_memory | 0 |
  1343. | Qcache_hits | 0 |
  1344. | Qcache_inserts | 0 |
  1345. | Qcache_lowmem_prunes | 0 |
  1346. | Qcache_not_cached | 0 |
  1347. | Qcache_queries_in_cache | 0 |
  1348. | Qcache_total_blocks | 0 |
  1349. | Queries | 12287493 |
  1350. | Questions | 12180887 |
  1351. | Rpl_status | AUTH_MASTER |
  1352. | Select_full_join | 1832 |
  1353. | Select_full_range_join | 32 |
  1354. | Select_range | 162096 |
  1355. | Select_range_check | 106 |
  1356. | Select_scan | 2351142 |
  1357. | Slave_heartbeat_period | 0.000 |
  1358. | Slave_open_temp_tables | 0 |
  1359. | Slave_received_heartbeats | 0 |
  1360. | Slave_retried_transactions | 0 |
  1361. | Slave_running | OFF |
  1362. | Slow_launch_threads | 0 |
  1363. | Slow_queries | 220 |
  1364. | Sort_merge_passes | 1235 |
  1365. | Sort_range | 419949 |
  1366. | Sort_rows | 130900397 |
  1367. | Sort_scan | 1193552 |
  1368. | Ssl_accept_renegotiates | 0 |
  1369. | Ssl_accepts | 0 |
  1370. | Ssl_callback_cache_hits | 0 |
  1371. | Ssl_cipher | |
  1372. | Ssl_cipher_list | |
  1373. | Ssl_client_connects | 0 |
  1374. | Ssl_connect_renegotiates | 0 |
  1375. | Ssl_ctx_verify_depth | 0 |
  1376. | Ssl_ctx_verify_mode | 0 |
  1377. | Ssl_default_timeout | 0 |
  1378. | Ssl_finished_accepts | 0 |
  1379. | Ssl_finished_connects | 0 |
  1380. | Ssl_session_cache_hits | 0 |
  1381. | Ssl_session_cache_misses | 0 |
  1382. | Ssl_session_cache_mode | NONE |
  1383. | Ssl_session_cache_overflows | 0 |
  1384. | Ssl_session_cache_size | 0 |
  1385. | Ssl_session_cache_timeouts | 0 |
  1386. | Ssl_sessions_reused | 0 |
  1387. | Ssl_used_session_cache_entries | 0 |
  1388. | Ssl_verify_depth | 0 |
  1389. | Ssl_verify_mode | 0 |
  1390. | Ssl_version | |
  1391. | Table_locks_immediate | 12479287 |
  1392. | Table_locks_waited | 4507 |
  1393. | Tc_log_max_pages_used | 0 |
  1394. | Tc_log_page_size | 0 |
  1395. | Tc_log_page_waits | 0 |
  1396. | Threads_cached | 0 |
  1397. | Threads_connected | 8 |
  1398. | Threads_created | 292627 |
  1399. | Threads_running | 4 |
  1400. | Uptime | 54850 |
  1401. | Uptime_since_flush_status | 54850 |
  1402. +------------------------------------------+--------------+
  1403. +--------+---------------+-----------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
  1404. | Id | User | Host | db | Command | Time | State | Info |
  1405. +--------+---------------+-----------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
  1406. | 75 | eximstats | localhost | eximstats | Sleep | 72 | | |
  1407. | 282769 | DELAYED | localhost | eximstats | Delayed insert | 72 | Waiting for INSERT | |
  1408. | 290066 | terrahar_matt | localhost | terrahar_wp | Sleep | 4 | | |
  1409. | 290261 | leechprotect | localhost | leechprotect | Sleep | 281 | | |
  1410. | 290496 | babilosa_db | localhost | babilosa_wp | Sleep | 0 | | |
  1411. | 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 |
  1412. | 292699 | terrahar_matt | localhost | terrahar_wp | Query | 0 | query end | update oqms0w9y2_wfFileMods set oldMD5 = newMD5 where filenameMD5='????j?J?w?HQ?N?' |
  1413. | 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 |
  1414. | 292721 | root | localhost | | Query | 0 | | show processlist |
  1415. +--------+---------------+-----------+--------------+----------------+------+--------------------+------------------------------------------------------------------------------------------------------+
  1416.  
  1417. ------------------------------------
  1418. INNODB Buffer Pool Stats
  1419. ------------------------------------
  1420. *************************** 1. row ***************************
  1421. POOL_ID: 0
  1422. POOL_SIZE: 8191
  1423. FREE_BUFFERS: 0
  1424. DATABASE_PAGES: 8180
  1425. OLD_DATABASE_PAGES: 2999
  1426. MODIFIED_DATABASE_PAGES: 83
  1427. PENDING_DECOMPRESS: 0
  1428. PENDING_READS: 0
  1429. PENDING_FLUSH_LRU: 0
  1430. PENDING_FLUSH_LIST: 0
  1431. PAGES_MADE_YOUNG: 16683363
  1432. PAGES_NOT_MADE_YOUNG: 0
  1433. PAGES_MADE_YOUNG_RATE: 6144.87279191201
  1434. PAGES_MADE_NOT_YOUNG_RATE: 0
  1435. NUMBER_PAGES_READ: 16652365
  1436. NUMBER_PAGES_CREATED: 24589
  1437. NUMBER_PAGES_WRITTEN: 512701
  1438. PAGES_READ_RATE: 6104.432840795467
  1439. PAGES_CREATE_RATE: 0.6665926008221309
  1440. PAGES_WRITTEN_RATE: 20.886568159093436
  1441. NUMBER_PAGES_GET: 337881640
  1442. HIT_RATE: 849
  1443. YOUNG_MAKE_PER_THOUSAND_GETS: 152
  1444. NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0
  1445. NUMBER_PAGES_READ_AHEAD: 14581
  1446. NUMBER_READ_AHEAD_EVICTED: 253
  1447. READ_AHEAD_RATE: 0
  1448. READ_AHEAD_EVICTED_RATE: 0
  1449. LRU_IO_TOTAL: 94758
  1450. LRU_IO_CURRENT: 3557
  1451. UNCOMPRESS_TOTAL: 0
  1452. UNCOMPRESS_CURRENT: 0
  1453.  
  1454. ----------------------------
  1455. INNODB Status
  1456. ----------------------------
  1457. *************************** 1. row ***************************
  1458. Type: InnoDB
  1459. Name:
  1460. Status:
  1461. =====================================
  1462. 140103 17:46:25 INNODB MONITOR OUTPUT
  1463. =====================================
  1464. Per second averages calculated from the last 9 seconds
  1465. -----------------
  1466. BACKGROUND THREAD
  1467. -----------------
  1468. srv_master_thread loops: 46411 1_second, 46064 sleeps, 4608 10_second, 349 background, 348 flush
  1469. srv_master_thread log flush and writes: 49587
  1470. ----------
  1471. SEMAPHORES
  1472. ----------
  1473. OS WAIT ARRAY INFO: reservation count 19384, signal count 17490
  1474. Mutex spin waits 213335, rounds 932730, OS waits 7677
  1475. RW-shared spins 8802, rounds 234550, OS waits 6919
  1476. RW-excl spins 715, rounds 142743, OS waits 4447
  1477. Spin rounds per wait: 4.37 mutex, 26.65 RW-shared, 199.64 RW-excl
  1478. ------------------------
  1479. LATEST FOREIGN KEY ERROR
  1480. ------------------------
  1481. 140103 14:05:19 Error in foreign key constraint of table cptmpdb_webodevi_x69kvpu69dDgw4T3/cache_messages:
  1482. FOREIGN KEY (`user_id`)
  1483. REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1484. INDEX `changed_index` (`changed`),
  1485. PRIMARY KEY (`user_id`, `mailbox`, `uid`)
  1486. ) :
  1487. Cannot resolve table name close to:
  1488. (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  1489. INDEX `changed_index` (`changed`),
  1490. PRIMARY KEY (`user_id`, `mailbox`, `uid`)
  1491. )
  1492. ------------
  1493. TRANSACTIONS
  1494. ------------
  1495. Trx id counter 3CE58AC6
  1496. Purge done for trx's n:o < 3CE57B03 undo n:o < 0
  1497. History list length 3433
  1498. LIST OF TRANSACTIONS FOR EACH SESSION:
  1499. ---TRANSACTION 0, not started
  1500. MySQL thread id 292723, OS thread handle 0x7fb636292700, query id 12287500 localhost root
  1501. show engine innodb status
  1502. ---TRANSACTION 3CE58AC4, not started flushing log
  1503. mysql tables in use 1, locked 1
  1504. MySQL thread id 292715, OS thread handle 0x7fb633548700, query id 12287490 localhost babilosa_db query end
  1505. 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
  1506. ---TRANSACTION 3CE58ABE, not started flushing log
  1507. mysql tables in use 1, locked 1
  1508. MySQL thread id 292699, OS thread handle 0x7fb633750700, query id 12287412 localhost terrahar_matt query end
  1509. update oqms0w9y2_wfFileMods set oldMD5 = newMD5 where filenameMD5='????j?J?w?HQ?N?'
  1510. ---TRANSACTION 3CE58AC2, not started flushing log
  1511. mysql tables in use 1, locked 1
  1512. MySQL thread id 292686, OS thread handle 0x7fb633444700, query id 12287489 localhost babilosa_db query end
  1513. 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
  1514. ---TRANSACTION 3CE539F0, not started
  1515. MySQL thread id 290496, OS thread handle 0x7fb63608a700, query id 12287376 localhost babilosa_db
  1516. ---TRANSACTION 3CE57B28, not started
  1517. MySQL thread id 290066, OS thread handle 0x7fb635f45700, query id 12282966 localhost terrahar_matt
  1518. --------
  1519. FILE I/O
  1520. --------
  1521. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  1522. I/O thread 1 state: waiting for completed aio requests (log thread)
  1523. I/O thread 2 state: waiting for completed aio requests (read thread)
  1524. I/O thread 3 state: waiting for completed aio requests (read thread)
  1525. I/O thread 4 state: waiting for completed aio requests (read thread)
  1526. I/O thread 5 state: waiting for completed aio requests (read thread)
  1527. I/O thread 6 state: waiting for completed aio requests (write thread)
  1528. I/O thread 7 state: waiting for completed aio requests (write thread)
  1529. I/O thread 8 state: waiting for completed aio requests (write thread)
  1530. I/O thread 9 state: waiting for completed aio requests (write thread)
  1531. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  1532. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  1533. Pending flushes (fsync) log: 1; buffer pool: 0
  1534. 16667682 OS file reads, 797287 OS file writes, 314717 OS fsyncs
  1535. 6104.43 reads/s, 16384 avg bytes/read, 27.55 writes/s, 8.44 fsyncs/s
  1536. -------------------------------------
  1537. INSERT BUFFER AND ADAPTIVE HASH INDEX
  1538. -------------------------------------
  1539. Ibuf: size 1, free list len 6152, seg size 6154, 2627 merges
  1540. merged operations:
  1541. insert 13194, delete mark 200, delete 4
  1542. discarded operations:
  1543. insert 0, delete mark 0, delete 0
  1544. Hash table size 276671, node heap has 11 buffer(s)
  1545. 4469.73 hash searches/s, 1833.80 non-hash searches/s
  1546. ---
  1547. LOG
  1548. ---
  1549. Log sequence number 42677122851
  1550. Log flushed up to 42677114301
  1551. Last checkpoint at 42676986276
  1552. 1 pending log writes, 0 pending chkp writes
  1553. 258532 log i/o's done, 6.11 log i/o's/second
  1554. ----------------------
  1555. BUFFER POOL AND MEMORY
  1556. ----------------------
  1557. Total memory allocated 137363456; in additional pool allocated 0
  1558. Dictionary memory allocated 112191421
  1559. Buffer pool size 8191
  1560. Free buffers 0
  1561. Database pages 8180
  1562. Old database pages 2999
  1563. Modified db pages 83
  1564. Pending reads 0
  1565. Pending writes: LRU 0, flush list 0, single page 0
  1566. Pages made young 16683363, not young 0
  1567. 0.00 youngs/s, 0.00 non-youngs/s
  1568. Pages read 16652365, created 24589, written 512701
  1569. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1570. No buffer pool page gets since the last printout
  1571. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1572. LRU len: 8180, unzip_LRU len: 0
  1573. I/O sum[94758]:cur[3557], unzip sum[0]:cur[0]
  1574. --------------
  1575. ROW OPERATIONS
  1576. --------------
  1577. 0 queries inside InnoDB, 0 queries in queue
  1578. 1 read views open inside InnoDB
  1579. Main thread process no. 18929, id 140420562712320, state: sleeping
  1580. Number of rows inserted 454116, updated 162401, deleted 84788, read 342461085
  1581. 1.22 inserts/s, 6.67 updates/s, 0.11 deletes/s, 28420.51 reads/s
  1582. ----------------------------
  1583. END OF INNODB MONITOR OUTPUT
  1584. ============================
  1585.  
  1586.  
  1587. ----------------------------
  1588. MySQL Error Log
  1589. ----------------------------
  1590.  
  1591. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_TMW@yourserverhostname'; Ignoring user
  1592. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_nodead@yourserverIP'; Ignoring user
  1593. 140103 14:05:23 [Warning] Found invalid password for user: 'user2_tmw@localhost'; Ignoring user
  1594. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_new@localhost'; Ignoring user
  1595. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_nodead@localhost'; Ignoring user
  1596. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_new@yourserverIP'; Ignoring user
  1597. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_TMW@localhost'; Ignoring user
  1598. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_TMW@yourserverIP'; Ignoring user
  1599. 140103 14:05:23 [Warning] Found invalid password for user: 'user2_tmw@yourserverhostname'; Ignoring user
  1600. 140103 14:05:23 [Warning] Found invalid password for user: 'user2_tmw@yourserverIP'; Ignoring user
  1601. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_nodead@yourserverhostname'; Ignoring user
  1602. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_new@yourserverhostname'; Ignoring user
  1603. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_TMW@yourserverhostname'; Ignoring user
  1604. 140103 14:05:23 [Warning] Found invalid password for user: 'user1_nodead@yourserverIP'; Ignoring user
  1605. 140103 14:05:23 [Warning] Found invalid password for user: 'user2_tmw@localhost'; Ignoring user
  1606.  
  1607. Report Complete:
  1608. Fri Jan 3 17:46:25 CET 2014
  1609. ----------------------------
RAW Paste Data