API tools faq
paste
Advertisement
RoldanLT

Untitled

RoldanLT
Feb 19th, 2014
178
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 75.54 KB | None | 0 0
raw download clone embed print report
  1.  
  2. -------------------------------------------------------------
  3. System MySQL monitoring stats
  4. mysqlmymonlite.sh - 0.5.0 mysqlmymon.com
  5. compiled by George Liu (eva2000) vbtechsupport.com
  6. -------------------------------------------------------------
  7.  
  8. Report Generated:
  9. Wed Feb 19 23:21:52 EST 2014
  10.  
  11. ----------------------------
  12. MySQL Uptime:
  13. ----------------------------
  14. MySQL server was started 2014-02-14 12:52:41
  15. Uptime: 5 days 10 hours 29 min 11 sec
  16. Uptime 469751
  17. Uptime_since_flush_status 469751
  18.  
  19. Max Used Connections: 50/100 (50.00%)
  20. Key Buffer Used: 25.00k/64.00M (0.04%)
  21. Key Buffer Used: 1.34M/8.00M (16.70%)
  22. Current Key Buffer Usage: 11.68M (18.25%)
  23. Current Key Buffer Usage: 328.00k (4.00%)
  24. InnoDB Buffer Pool: 1.29G/4.00G (32.34%)
  25. Query Cache: 106.71M/256.00M (41.68%)
  26. Table Locks Waited: 446 Rate: 0.0/s (0.00%)
  27. --------------------
  28. Query Cache Limit (bytes): 8388608
  29. Query Cache Min Unit (bytes): 2048
  30. Query Cache Size (bytes): 268435456
  31. Query Cache Free Mem (bytes): 156547104
  32. Query Cache Used Mem (bytes): 111888352
  33. Queries in Query Cache: 1
  34. Query Cache Avg Size (bytes): 111888352
  35.  
  36. ----------------------------
  37. Hardware Info:
  38. ----------------------------
  39. Processors physical = 1, cores = 4, virtual = 4, hyperthreading = no
  40. 4 2976.000
  41. 4 Intel(R) Core(TM) i5-3570S CPU @ 3.10GHz
  42. 4 6144 KB
  43.  
  44.  
  45. ----------------------------
  46. TOP stats
  47. ----------------------------
  48.  
  49. Linux 3.10.23-xxxx-grs-ipv6-64 ((yourserverhostname)) 02/19/2014 _x86_64_ (4 CPU)
  50.  
  51. 11:21:52 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
  52. 11:21:54 PM all 3.51 0.00 0.13 0.88 0.00 0.13 0.00 0.00 95.36
  53. 11:21:54 PM 0 1.52 0.00 0.00 3.54 0.00 0.00 0.00 0.00 94.95
  54. 11:21:54 PM 1 1.50 0.00 0.00 0.00 0.00 0.50 0.00 0.00 98.00
  55. 11:21:54 PM 2 8.54 0.00 0.50 0.00 0.00 0.00 0.00 0.00 90.95
  56. 11:21:54 PM 3 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 98.00
  57.  
  58. 11:21:54 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
  59. 11:21:56 PM all 9.42 0.00 0.25 0.25 0.00 0.13 0.00 0.00 89.95
  60. 11:21:56 PM 0 4.04 0.00 0.51 0.51 0.00 0.51 0.00 0.00 94.44
  61. 11:21:56 PM 1 6.97 0.00 0.50 0.00 0.00 0.00 0.00 0.00 92.54
  62. 11:21:56 PM 2 14.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 85.86
  63. 11:21:56 PM 3 12.56 0.00 0.50 0.00 0.00 0.00 0.00 0.00 86.93
  64.  
  65. Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle
  66. Average: all 6.46 0.00 0.19 0.56 0.00 0.13 0.00 0.00 92.66
  67. Average: 0 2.78 0.00 0.25 2.02 0.00 0.25 0.00 0.00 94.70
  68. Average: 1 4.24 0.00 0.25 0.00 0.00 0.25 0.00 0.00 95.26
  69. Average: 2 11.34 0.00 0.25 0.00 0.00 0.00 0.00 0.00 88.41
  70. Average: 3 7.27 0.00 0.25 0.00 0.00 0.00 0.00 0.00 92.48
  71.  
  72. top - 23:21:57 up 5 days, 10:29, 1 user, load average: 0.29, 0.38, 0.43
  73. Tasks: 150 total, 1 running, 145 sleeping, 4 stopped, 0 zombie
  74. Cpu(s): 5.5%us, 0.4%sy, 0.0%ni, 92.8%id, 1.2%wa, 0.0%hi, 0.1%si, 0.0%st
  75. Mem: 8065608k total, 7897180k used, 168428k free, 416768k buffers
  76. Swap: 1046520k total, 8284k used, 1038236k free, 2465260k cached
  77.  
  78. PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
  79. 10533 nginx 10 -10 56096 10m 2004 S 4.0 0.1 1:12.57 nginx
  80. 1 root 20 0 19280 1400 1228 S 0.0 0.0 0:00.48 init
  81. 2 root 20 0 0 0 0 S 0.0 0.0 0:00.03 kthreadd
  82. 3 root 20 0 0 0 0 S 0.0 0.0 0:10.14 ksoftirqd/0
  83. 5 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0H
  84. 7 root RT 0 0 0 0 S 0.0 0.0 0:00.12 migration/0
  85. 8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh
  86. 9 root 20 0 0 0 0 S 0.0 0.0 2:51.26 rcu_sched
  87. 10 root RT 0 0 0 0 S 0.0 0.0 0:00.12 migration/1
  88. 11 root 20 0 0 0 0 S 0.0 0.0 0:01.00 ksoftirqd/1
  89. 13 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1:0H
  90. 14 root RT 0 0 0 0 S 0.0 0.0 0:00.12 migration/2
  91. 15 root 20 0 0 0 0 S 0.0 0.0 0:00.78 ksoftirqd/2
  92. 17 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/2:0H
  93. 18 root RT 0 0 0 0 S 0.0 0.0 0:00.12 migration/3
  94. 19 root 20 0 0 0 0 S 0.0 0.0 0:00.76 ksoftirqd/3
  95. 21 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/3:0H
  96. 22 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 khelper
  97. 23 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs
  98. 24 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns
  99. 502 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 writeback
  100. 504 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd
  101. 505 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
  102. 507 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kblockd
  103. 624 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ata_sff
  104. 634 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khubd
  105. 644 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 md
  106. 647 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 edac-poller
  107. 750 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 rpciod
  108. 752 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kvm-irqfd-clean
  109. 753 root 20 0 0 0 0 S 0.0 0.0 0:06.30 kworker/3:1
  110. 855 root 20 0 0 0 0 S 0.0 0.0 0:03.05 kswapd0
  111. 856 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd
  112. 979 root 20 0 0 0 0 S 0.0 0.0 0:00.00 fsnotify_mark
  113. 1019 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 nfsiod
  114. 1032 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 cifsiod
  115. 1053 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsIO
  116. 1054 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
  117. 1055 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
  118. 1056 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
  119. 1057 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsCommit
  120. 1058 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jfsSync
  121. 1072 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xfsalloc
  122. 1074 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xfs_mru_cache
  123. 1077 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xfslogd
  124. 1084 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ocfs2_wq
  125. 1087 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 user_dlm
  126. 1102 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
  127. 1112 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 glock_workqueue
  128. 1113 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 delete_workqueu
  129. 1121 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 gfs_recovery
  130. 1126 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 crypto
  131. 1158 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kthrotld
  132. 1801 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
  133. 1802 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 drbd-reissue
  134. 1834 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 iscsi_eh
  135. 1878 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
  136. 1883 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
  137. 1886 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_2
  138. 1889 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_3
  139. 1892 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_4
  140. 1914 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bond0
  141. 1955 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bnx2x
  142. 1971 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 mlx4
  143. 1989 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 vfio-irqfd-clea
  144. 2024 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kpsmoused
  145. 2051 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 dm_bufio_cache
  146. 2054 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdelayd
  147. 2057 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kmpathd
  148. 2058 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kmpath_handlerd
  149. 2139 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 deferwq
  150. 2169 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
  151. 2170 root 20 0 0 0 0 S 0.0 0.0 25:56.08 md3_raid1
  152. 2174 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset
  153. 2175 root 20 0 0 0 0 S 0.0 0.0 1:33.06 md1_raid1
  154. 2177 root 20 0 0 0 0 S 0.0 0.0 0:17.38 kjournald
  155. 2234 root 16 -4 10824 388 320 S 0.0 0.0 0:00.04 udevd
  156. 2293 root 0 -20 0 0 0 S 0.0 0.0 0:04.96 kworker/1:1H
  157. 2297 root 0 -20 0 0 0 S 0.0 0.0 0:01.33 kworker/3:1H
  158. 2306 root 0 -20 0 0 0 S 0.0 0.0 3:46.27 kworker/0:1H
  159. 2500 root 18 -2 10820 348 340 S 0.0 0.0 0:00.00 udevd
  160. 2527 root 20 0 0 0 0 S 0.0 0.0 0:11.52 kjournald
  161. 2766 root 20 0 237m 2104 1004 S 0.0 0.0 0:04.94 rsyslogd
  162. 2806 named 20 0 373m 26m 3076 S 0.0 0.3 0:32.18 named
  163. 2846 root 20 0 4736 568 496 S 0.0 0.0 0:00.08 mdadm
  164. 2893 root 20 0 0 0 0 S 0.0 0.0 0:03.34 kworker/1:1
  165. 2930 root 20 0 111m 884 804 S 0.0 0.0 3:02.62 elasticsearch-l
  166. 2932 root 20 0 3035m 614m 27m S 0.0 7.8 33:41.60 java
  167. 2939 root 0 -20 0 0 0 S 0.0 0.0 0:01.84 kworker/2:1H
  168. 3021 dbus 20 0 21448 704 432 S 0.0 0.0 0:00.00 dbus-daemon
  169. 3059 root 20 0 66656 1192 468 S 0.0 0.0 0:00.00 sshd
  170. 3066 ntp 20 0 30768 2120 1508 S 0.0 0.0 0:00.53 ntpd
  171. 3079 root 20 0 105m 1616 1304 S 0.0 0.0 0:00.04 mysqld_safe
  172. 3495 root 20 0 0 0 0 S 0.0 0.0 0:00.37 kworker/u8:2
  173. 4136 mysql 20 0 5294m 3.2g 9216 S 0.0 41.3 279:08.61 mysqld
  174. 4183 nobody 20 0 679m 357m 516 S 0.0 4.5 34:21.33 memcached
  175. 4264 root 20 0 81752 3396 2512 S 0.0 0.0 0:01.62 master
  176. 4274 postfix 20 0 82000 3480 2536 S 0.0 0.0 0:00.48 qmgr
  177. 4289 root 20 0 114m 1340 648 S 0.0 0.0 0:02.60 crond
  178. 4299 root 20 0 21588 400 220 S 0.0 0.0 0:00.00 atd
  179. 4344 root 20 0 4108 548 472 S 0.0 0.0 0:00.00 mingetty
  180. 4346 root 20 0 4108 548 472 S 0.0 0.0 0:00.00 mingetty
  181. 4348 root 20 0 4112 548 468 S 0.0 0.0 0:00.00 mingetty
  182. 4350 root 20 0 4108 548 472 S 0.0 0.0 0:00.00 mingetty
  183. 4351 root 18 -2 10820 368 320 S 0.0 0.0 0:00.00 udevd
  184. 4353 root 20 0 4108 548 472 S 0.0 0.0 0:00.00 mingetty
  185. 4355 root 20 0 4108 548 472 S 0.0 0.0 0:00.00 mingetty
  186. 7250 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/3:2
  187. 10140 root 20 0 0 0 0 S 0.0 0.0 0:08.10 kworker/0:1
  188. 10307 root 20 0 0 0 0 S 0.0 0.0 0:02.78 kworker/2:0
  189. 10530 root 20 0 48412 1416 268 S 0.0 0.0 0:00.00 nginx
  190. 10531 nginx 10 -10 70252 24m 2008 S 0.0 0.3 2:28.26 nginx
  191. 10532 nginx 10 -10 62188 16m 2012 S 0.0 0.2 3:25.73 nginx
  192. 10534 nginx 10 -10 59108 14m 2016 S 0.0 0.2 1:17.03 nginx
  193. 10548 root 20 0 479m 6568 1476 S 0.0 0.1 0:04.43 php-fpm
  194. 13162 postfix 20 0 81832 3332 2476 S 0.0 0.0 0:00.00 pickup
  195. 13901 root 20 0 99.5m 5280 3156 S 0.0 0.1 0:00.34 sshd
  196. 13912 root 20 0 57868 2328 1624 S 0.0 0.0 0:00.08 sftp-server
  197. 14583 root 20 0 98.1m 4140 3172 S 0.0 0.1 0:00.33 sshd
  198. 14585 root 20 0 105m 2048 1556 S 0.0 0.0 0:00.02 bash
  199. 14651 root 20 0 110m 2336 1276 T 0.0 0.0 0:21.08 htop
  200. 14660 root 20 0 98.1m 4028 3060 S 0.0 0.0 0:00.02 sshd
  201. 14705 root 20 0 57728 2256 1620 S 0.0 0.0 0:00.00 sftp-server
  202. 14935 root 20 0 98.1m 4024 3056 S 0.0 0.0 0:00.02 sshd
  203. 14937 root 20 0 57728 2252 1616 S 0.0 0.0 0:00.00 sftp-server
  204. 15157 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1:2
  205. 15948 root 20 0 0 0 0 S 0.0 0.0 0:00.18 kworker/u8:1
  206. 16321 root 20 0 110m 2348 1272 T 0.0 0.0 0:00.52 htop
  207. 17299 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/0:0
  208. 17833 root 20 0 110m 2344 1272 T 0.0 0.0 0:00.60 htop
  209. 18206 root 20 0 110m 2344 1272 T 0.0 0.0 0:09.95 htop
  210. 18301 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/2:2
  211. 18465 nginx 20 0 483m 35m 27m S 0.0 0.5 0:06.83 php-fpm
  212. 18466 nginx 20 0 484m 35m 26m S 0.0 0.4 0:06.15 php-fpm
  213. 18467 nginx 20 0 483m 36m 27m S 0.0 0.5 0:06.65 php-fpm
  214. 18468 nginx 20 0 480m 31m 24m S 0.0 0.4 0:08.09 php-fpm
  215. 18469 nginx 20 0 480m 31m 24m S 0.0 0.4 0:07.82 php-fpm
  216. 18470 nginx 20 0 480m 32m 25m S 0.0 0.4 0:07.20 php-fpm
  217. 18471 nginx 20 0 480m 33m 26m S 0.0 0.4 0:07.35 php-fpm
  218. 18515 nginx 20 0 483m 33m 25m S 0.0 0.4 0:06.83 php-fpm
  219. 18516 nginx 20 0 480m 33m 25m S 0.0 0.4 0:05.89 php-fpm
  220. 18524 nginx 20 0 485m 36m 27m S 0.0 0.5 0:06.21 php-fpm
  221. 18525 nginx 20 0 483m 35m 26m S 0.0 0.4 0:06.33 php-fpm
  222. 18526 nginx 20 0 480m 34m 27m S 0.0 0.4 0:07.65 php-fpm
  223. 18620 root 20 0 98.1m 4160 3156 S 0.0 0.1 0:00.02 sshd
  224. 18629 root 20 0 57728 2312 1624 S 0.0 0.0 0:00.00 sftp-server
  225. 18795 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/u8:0
  226. 19009 root 20 0 104m 1936 1220 S 0.0 0.0 0:00.01 mysqlmymonlite.
  227. 19146 root 20 0 15072 1220 876 R 0.0 0.0 0:00.00 top
  228. 31495 root 20 0 150m 14m 1504 S 0.0 0.2 0:11.01 lfd
  229.  
  230.  
  231. total used free shared buffers cached
  232. Mem: 7876 7712 164 0 407 2407
  233. Low: 7876 7712 164
  234. High: 0 0 0
  235. -/+ buffers/cache: 4897 2978
  236. Swap: 1021 8 1013
  237.  
  238. MemTotal: 8065608 kB
  239. MemFree: 168072 kB
  240. Buffers: 416768 kB
  241. Cached: 2465260 kB
  242. SwapCached: 156 kB
  243. Active: 5399216 kB
  244. Inactive: 1955996 kB
  245. Active(anon): 3541456 kB
  246. Inactive(anon): 1053032 kB
  247. Active(file): 1857760 kB
  248. Inactive(file): 902964 kB
  249. Unevictable: 0 kB
  250. Mlocked: 0 kB
  251. SwapTotal: 1046520 kB
  252. SwapFree: 1038236 kB
  253. Dirty: 200 kB
  254. Writeback: 0 kB
  255. AnonPages: 4472868 kB
  256. Mapped: 88700 kB
  257. Shmem: 121304 kB
  258. Slab: 413524 kB
  259. SReclaimable: 376604 kB
  260. SUnreclaim: 36920 kB
  261. KernelStack: 2544 kB
  262. PageTables: 23344 kB
  263. NFS_Unstable: 0 kB
  264. Bounce: 0 kB
  265. WritebackTmp: 0 kB
  266. CommitLimit: 5079324 kB
  267. Committed_AS: 7154096 kB
  268. VmallocTotal: 34359738367 kB
  269. VmallocUsed: 89236 kB
  270. VmallocChunk: 34359561088 kB
  271. HardwareCorrupted: 0 kB
  272. DirectMap4k: 5820 kB
  273. DirectMap2M: 8280064 kB
  274.  
  275. --------------------------
  276. ps_mem.py output:
  277. http://www.pixelbeat.org/scripts/ps_mem.py
  278. --------------------------
  279. Private + Shared = RAM used Program
  280.  
  281. 180.0 KiB + 220.0 KiB = 400.0 KiB atd
  282. 124.0 KiB + 340.0 KiB = 464.0 KiB udevd (3)
  283. 72.0 KiB + 496.0 KiB = 568.0 KiB mdadm
  284. 272.0 KiB + 432.0 KiB = 704.0 KiB dbus-daemon
  285. 80.0 KiB + 804.0 KiB = 884.0 KiB elasticsearch-linux-x86-64
  286. 460.0 KiB + 472.0 KiB = 932.0 KiB mingetty (6)
  287. 692.0 KiB + 648.0 KiB = 1.3 MiB crond
  288. 172.0 KiB + 1.2 MiB = 1.4 MiB init
  289. 312.0 KiB + 1.3 MiB = 1.6 MiB mysqld_safe
  290. 716.0 KiB + 1.2 MiB = 1.9 MiB mysqlmymonlite.
  291. 492.0 KiB + 1.5 MiB = 2.0 MiB bash
  292. 1.1 MiB + 1.0 MiB = 2.1 MiB rsyslogd
  293. 612.0 KiB + 1.5 MiB = 2.1 MiB ntpd
  294. 856.0 KiB + 2.4 MiB = 3.3 MiB pickup
  295. 884.0 KiB + 2.5 MiB = 3.3 MiB master
  296. 944.0 KiB + 2.5 MiB = 3.4 MiB qmgr
  297. 2.6 MiB + 1.6 MiB = 4.2 MiB sftp-server (4)
  298. 4.2 MiB + 1.2 MiB = 5.4 MiB htop (4)
  299. 6.6 MiB + 3.1 MiB = 9.7 MiB sshd (6)
  300. 13.0 MiB + 1.5 MiB = 14.5 MiB lfd
  301. 23.4 MiB + 3.0 MiB = 26.4 MiB named
  302. 60.0 MiB + 2.0 MiB = 62.0 MiB nginx (5)
  303. 100.1 MiB + 27.6 MiB = 127.8 MiB php-fpm (13)
  304. 357.3 MiB + 516.0 KiB = 357.8 MiB memcached
  305. 586.5 MiB + 27.6 MiB = 614.1 MiB java
  306. 3.2 GiB + 9.0 MiB = 3.2 GiB mysqld
  307.  
  308. Private + Shared = RAM used Program
  309.  
  310.  
  311. ----------------------------
  312. Server Disk Usage
  313. ----------------------------
  314. Filesystem Type Size Used Avail Use% Mounted on
  315. rootfs rootfs 20G 14G 4.5G 77% /
  316. /dev/root ext3 20G 14G 4.5G 77% /
  317. devtmpfs devtmpfs 3.9G 424K 3.9G 1% /dev
  318. /dev/md3 ext3 905G 14G 846G 2% /home
  319. tmpfs tmpfs 3.9G 0 3.9G 0% /dev/shm
  320. tmpfs tmpfs 3.9G 40K 3.9G 1% /tmp
  321. /dev/root ext3 20G 14G 4.5G 77% /var/named/chroot/etc/named
  322. /dev/root ext3 20G 14G 4.5G 77% /var/named/chroot/var/named
  323. /dev/root ext3 20G 14G 4.5G 77% /var/named/chroot/etc/named.conf
  324. /dev/root ext3 20G 14G 4.5G 77% /var/named/chroot/etc/named.rfc1912.zones
  325. /dev/root ext3 20G 14G 4.5G 77% /var/named/chroot/etc/rndc.key
  326. /dev/root ext3 20G 14G 4.5G 77% /var/named/chroot/usr/lib64/bind
  327. /dev/root ext3 20G 14G 4.5G 77% /var/named/chroot/etc/named.iscdlv.key
  328. /dev/root ext3 20G 14G 4.5G 77% /var/named/chroot/etc/named.root.key
  329.  
  330. ----------------------------
  331. MySQL datadir disk usage
  332. ----------------------------
  333. /var/lib/mysql/ uses 2513004 kilobytes of disk space
  334.  
  335. ----------------------------
  336. ulimit -aH
  337. ----------------------------
  338. core file size (blocks, -c) unlimited
  339. data seg size (kbytes, -d) unlimited
  340. scheduling priority (-e) 0
  341. file size (blocks, -f) unlimited
  342. pending signals (-i) 63004
  343. max locked memory (kbytes, -l) 64
  344. max memory size (kbytes, -m) unlimited
  345. open files (-n) 65536
  346. pipe size (512 bytes, -p) 8
  347. POSIX message queues (bytes, -q) 819200
  348. real-time priority (-r) 0
  349. stack size (kbytes, -s) unlimited
  350. cpu time (seconds, -t) unlimited
  351. max user processes (-u) 63004
  352. virtual memory (kbytes, -v) unlimited
  353. file locks (-x) unlimited
  354.  
  355. ----------------------------------------------------------
  356. tail -15 /etc/security/limits.conf
  357. ----------------------------------------------------------
  358. #
  359.  
  360. #* soft core 0
  361. #* hard rss 10000
  362. #@student hard nproc 20
  363. #@faculty soft nproc 20
  364. #@faculty hard nproc 50
  365. #ftp hard nproc 0
  366. #@student - maxlogins 4
  367.  
  368. # End of file
  369. * soft nofile 65536
  370. * hard nofile 65536
  371. nginx soft nofile 65536
  372. nginx hard nofile 65536
  373.  
  374. ----------------------------------------------------------
  375. mysqld process limits:
  376. cat /proc/4136/limits
  377. ----------------------------------------------------------
  378. Limit Soft Limit Hard Limit Units
  379. Max cpu time unlimited unlimited seconds
  380. Max file size unlimited unlimited bytes
  381. Max data size unlimited unlimited bytes
  382. Max stack size 8388608 unlimited bytes
  383. Max core file size 0 unlimited bytes
  384. Max resident set unlimited unlimited bytes
  385. Max processes 63004 63004 processes
  386. Max open files 16495 16495 files
  387. Max locked memory 65536 65536 bytes
  388. Max address space unlimited unlimited bytes
  389. Max file locks unlimited unlimited locks
  390. Max pending signals 63004 63004 signals
  391. Max msgqueue size 819200 819200 bytes
  392. Max nice priority 0 0
  393. Max realtime priority 0 0
  394. Max realtime timeout unlimited unlimited us
  395.  
  396. ----------------------------------
  397. WEB SERVER & PHP Info:
  398. ----------------------------------
  399. PHP 5.5.9 (cli) (built: Feb 7 2014 08:53:18)
  400. Copyright (c) 1997-2014 The PHP Group
  401. Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
  402. with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies
  403.  
  404. System => Linux yourserverhostname 3.10.23-xxxx-grs-ipv6-64 #1 SMP Mon Dec 9 19:06:18 CET 2013 x86_64
  405. Build Date => Feb 7 2014 08:52:43
  406.  
  407. Configure Command => '../configure' '--enable-cgi' '--enable-fpm' '--enable-pcntl' '--with-mcrypt' '--with-mhash' '--with-zlib' '--with-gettext' '--enable-exif' '--enable-zip' '--with-bz2' '--enable-soap' '--enable-sockets' '--enable-sysvmsg' '--enable-sysvsem' '--enable-sysvshm' '--enable-shmop' '--with-pear' '--enable-mbstring' '--with-openssl' '--with-mysql=mysqlnd' '--with-libdir=lib64' '--with-mysqli=mysqlnd' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-curl' '--with-gd' '--with-xmlrpc' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-gd-native-ttf' '--with-freetype-dir=lib64' '--with-jpeg-dir=lib64' '--with-png-dir=lib64' '--with-xpm-dir=lib64' '--enable-pdo' '--with-pdo-sqlite' '--with-pdo-mysql=mysqlnd' '--enable-inline-optimization' '--with-imap' '--with-imap-ssl' '--with-kerberos' '--with-readline' '--with-libedit' '--with-fpm-user=nginx' '--with-fpm-group=nginx' '--with-config-file-scan-dir=/root/centminmod/php.d'
  408.  
  409. Server API | Command Line Interface
  410. Configuration File (php.ini) Path | /usr/local/lib
  411. Loaded Configuration File | /usr/local/lib/php.ini
  412. PHP API | 20121113
  413. Zend Extension Build | API220121212,NTS
  414. PHP Extension Build | API20121212,NTS
  415. DOM/XML API Version | 20031129
  416. MHASH API Version | Emulated Support
  417. Client API version | mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
  418. Client API library version | mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
  419. API Extensions | mysqli,mysql,pdo_mysql
  420. Client API version | mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
  421. Phar API version | 1.1.1
  422.  
  423. display_errors | Off | Off
  424. error_log | no value | no value
  425. extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20121212 | /usr/local/lib/php/extensions/no-debug-non-zts-20121212
  426. file_uploads | On | On
  427. log_errors | On | On
  428. log_errors_max_len | 1024 | 1024
  429. max_execution_time | 0 | 0
  430. max_file_uploads | 20 | 20
  431. memory_limit | 128M | 128M
  432. open_basedir | no value | no value
  433. post_max_size | 15M | 15M
  434. realpath_cache_size | 4096k | 4096k
  435. realpath_cache_ttl | 360 | 360
  436. sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
  437. sql.safe_mode | Off | Off
  438. upload_max_filesize | 15M | 15M
  439. upload_tmp_dir | no value | no value
  440. sqlite3.extension_dir | no value | no value
  441. opcache.error_log | /var/log/php_opcache_error.log | /var/log/php_opcache_error.log
  442.  
  443. cURL support | enabled
  444. cURL Information | 7.19.7
  445. ZLib Version | 1.2.3
  446. GD Support | enabled
  447. GD Version | bundled (2.1.0 compatible)
  448. FreeType Support | enabled
  449. FreeType Linkage | with freetype
  450. FreeType Version | 2.3.11
  451. GIF Read Support | enabled
  452. GIF Create Support | enabled
  453. JPEG Support | enabled
  454. libJPEG Version | 6b
  455. PNG Support | enabled
  456. libPNG Version | 1.2.49
  457. WBMP Support | enabled
  458. libXML support | active
  459. libXML Compiled Version | 2.7.6
  460. libXML Loaded Version | 20706
  461. libXML streams | enabled
  462. PCRE (Perl Compatible Regular Expressions) Support | enabled
  463. PCRE Library Version | 8.32 2012-11-30
  464. Soap Client | enabled
  465. Soap Server | enabled
  466. ZLib Support | enabled
  467.  
  468. /root/centminmod/php.d/memcache.ini,
  469. /root/centminmod/php.d/memcached.ini,
  470. igbinary APC serializer ABI | 0
  471. memcache
  472. memcache support | enabled
  473. memcache.allow_failover | 1 | 1
  474. memcache.chunk_size | 32768 | 32768
  475. memcache.compress_threshold | 20000 | 20000
  476. memcache.default_port | 11211 | 11211
  477. memcache.hash_function | crc32 | crc32
  478. memcache.hash_strategy | consistent | consistent
  479. memcache.lock_timeout | 15 | 15
  480. memcache.max_failover_attempts | 20 | 20
  481. memcache.protocol | ascii | ascii
  482. memcache.redundancy | 1 | 1
  483. memcache.session_redundancy | 2 | 2
  484. memcached
  485. memcached support | enabled
  486. libmemcached version | 1.0.16
  487. memcached.compression_factor | 1.3 | 1.3
  488. memcached.compression_threshold | 2000 | 2000
  489. memcached.compression_type | fastlz | fastlz
  490. memcached.serializer | igbinary | igbinary
  491. memcached.sess_binary | 0 | 0
  492. memcached.sess_lock_wait | 150000 | 150000
  493. memcached.sess_locking | 1 | 1
  494. memcached.sess_prefix | memc.sess.key. | memc.sess.key.
  495. Registered save handlers | files user memcache memcached
  496.  
  497.  
  498.  
  499.  
  500. ---------------
  501. You are running Nginx
  502. ---------------
  503.  
  504.  
  505. user nginx nginx;
  506. worker_processes 4;
  507. worker_rlimit_nofile 51200;
  508. worker_connections 2048;
  509. use epoll;
  510. log_format main '$remote_addr - $remote_user [$time_local] $request '
  511. '"$http_user_agent" "$http_x_forwarded_for" "$gzip_ratio"'
  512. sendfile on;
  513. #sendfile_max_chunk 1m;
  514. keepalive_timeout 10;
  515. gzip on;
  516. gzip_vary on;
  517. gzip_disable "MSIE [1-6]\.";
  518. gzip_static on;
  519. gzip_min_length 1400;
  520. gzip_buffers 32 8k;
  521. gzip_http_version 1.0;
  522. gzip_comp_level 5;
  523. gzip_proxied any;
  524. gzip_types text/plain text/css text/xml application/javascript application/x-javascript application/xml application/xml+rss application/ecmascript application/json image/svg+xml;
  525. client_body_buffer_size 256k;
  526. client_body_in_file_only off;
  527. client_body_timeout 60s;
  528. client_header_buffer_size 64k;
  529. client_header_timeout 20s;
  530. client_max_body_size 5m;
  531. large_client_header_buffers 8 64k;
  532. proxy_temp_path /tmp/nginx_proxy/;
  533. # for nginx proxy backends to prevent redirects to backend port
  534.  
  535. ----------------------------
  536. mysqlreport output
  537. ----------------------------
  538.  
  539. MariaDB 5.5.35-MariaDB uptime 5 10:29:16 Wed Feb 19 23:21:57 2014
  540.  
  541. __ Key _________________________________________________________________
  542. Buffer used 25.00k of 64.00M %Used: 0.04
  543. Current 11.68M %Usage: 18.25
  544. Write hit 90.55%
  545. Read hit 99.95%
  546.  
  547. __ Questions ___________________________________________________________
  548. Total 11.76M 25.0/s
  549. Com_ 27.41M 58.4/s %Total: 233.08
  550. -Unknown 26.71M 56.9/s 227.09
  551. DMS 7.51M 16.0/s 63.86
  552. QC Hits 2.25M 4.8/s 19.13
  553. COM_QUIT 1.30M 2.8/s 11.02
  554. Slow 1 s 186 0.0/s 0.00 %DMS: 0.00 Log: OFF
  555. DMS 7.51M 16.0/s 63.86
  556. SELECT 5.13M 10.9/s 43.62 68.30
  557. INSERT 1.92M 4.1/s 16.36 25.62
  558. UPDATE 244.96k 0.5/s 2.08 3.26
  559. REPLACE 118.80k 0.3/s 1.01 1.58
  560. DELETE 92.89k 0.2/s 0.79 1.24
  561. Com_ 27.41M 58.4/s 233.08
  562. stmt_prepar 7.51M 16.0/s 63.86
  563. stmt_execut 7.51M 16.0/s 63.86
  564. stmt_close 6.40M 13.6/s 54.44
  565.  
  566. __ Rows ________________________________________________________________
  567. Rows 8.72G 18.6k/s
  568. Using idx 7.70G 16.4k/s %Index: 88.38
  569. Rows/question 741.13
  570.  
  571. __ SELECT and Sort _____________________________________________________
  572. Scan 601.48k 1.3/s %SELECT: 11.72
  573. Range 544.89k 1.2/s 10.62
  574. Full join 291 0.0/s 0.01
  575. Range check 0 0/s 0.00
  576. Full rng join 0 0/s 0.00
  577. Sort scan 287.33k 0.6/s
  578. Sort range 268.52k 0.6/s
  579. Sort mrg pass 111 0.0/s
  580.  
  581. __ Query Cache _________________________________________________________
  582. Memory usage 105.54M of 256.00M %Usage: 41.23
  583. Block Fragmnt 4.12%
  584. Hits 2.25M 4.8/s
  585. Inserts 2.72M 5.8/s
  586. Insrt:Prune 2.72M:1 5.8/s
  587. Hit:Insert 0.83:1
  588.  
  589. __ Table Locks _________________________________________________________
  590. Waited 446 0.0/s %Total: 0.00
  591. Immediate 10.38M 22.1/s
  592.  
  593. __ Tables ______________________________________________________________
  594. Open 722 of 8192 %Cache: 8.81
  595. Opened 4.59k 0.0/s
  596.  
  597. __ Connections _________________________________________________________
  598. Max used 50 of 100 %Max: 50.00
  599. Total 1.30M 2.8/s
  600.  
  601. __ Created Temp ________________________________________________________
  602. Disk table 33.16k 0.1/s %Disk: 12.69
  603. Table 261.21k 0.6/s Size: 512.0M
  604. File 230 0.0/s
  605.  
  606. __ Threads _____________________________________________________________
  607. Running 1 of 2
  608. Created 50 0.0/s
  609. Slow 0 0/s
  610. Cached 48 of 64 %Hit: 100
  611.  
  612. __ Aborted _____________________________________________________________
  613. Clients 0 0/s
  614. Connects 2 0.0/s
  615.  
  616. __ Bytes _______________________________________________________________
  617. Sent 124.66G 265.4k/s
  618. Received 7.21G 15.4k/s
  619.  
  620. __ InnoDB Buffer Pool __________________________________________________
  621. Usage 1.29G of 4.00G %Usage: 32.34
  622. Read hit 100.00%
  623. Pages
  624. Free 177.35k %Total: 67.66
  625. Data 79.96k 30.50 %Drty: 0.10
  626. Misc 4830 1.84
  627. Latched 0 0.00
  628. Reads 16.90G 36.0k/s
  629. From disk 57.61k 0.1/s %Disk: 0.00
  630. Ahead Rnd 0 0/s
  631. Writes 27.20M 57.9/s
  632. Flushes 3.66M 7.8/s
  633. Wait Free 0 0/s %Wait: 0.00
  634.  
  635. __ InnoDB Lock _________________________________________________________
  636. Waits 151 0.0/s
  637. Current 0
  638. Time acquiring
  639. Total 1148 ms
  640. Average 7 ms
  641. Max 185 ms
  642.  
  643. __ InnoDB Data, Pages, Rows ____________________________________________
  644. Data
  645. Reads 70.68k 0.2/s
  646. Writes 4.89M 10.4/s
  647. fsync 636.73k 1.4/s
  648. Pending
  649. Reads 0
  650. Writes 0
  651. fsync 0
  652.  
  653. Pages
  654. Created 15.97k 0.0/s
  655. Read 70.46k 0.2/s
  656. Written 3.66M 7.8/s
  657.  
  658. Rows
  659. Deleted 655.26k 1.4/s
  660. Inserted 1.15M 2.5/s
  661. Read 8.47G 18.0k/s
  662. Updated 911.70k 1.9/s
  663.  
  664. __ Aria Pagecache ______________________________________________________
  665. Buffer used 1.34M of 8.00M %Used: 16.70
  666. Current 328.00k %Usage: 4.00
  667. Write hit 100.00%
  668. Read hit 96.50%
  669.  
  670. ----------------------------
  671. Total Server MyISAM and InnoDB Size
  672. ----------------------------
  673. *************************** 1. row ***************************
  674. innodb_tablespace_utilization_perc: 100
  675. total_size_gb: 1.283918583765626
  676. index_size_gb: 0.2945318855345249
  677. data_size_gb: 0.989386698231101
  678. innodb_total_size_gb: 1.276824951171875
  679. innodb_data_size_gb: 0.9854583740234375
  680. innodb_index_size_gb: 0.2913665771484375
  681. myisam_total_size_gb: 0.002851216122508049
  682. myisam_data_size_gb: 0.001695362851023674
  683. myisam_index_size_gb: 0.001155853271484375
  684. perc_index: 22.9401
  685. perc_data: 77.0599
  686. innodb_perc_index: 22.8196
  687. innodb_perc_data: 77.1804
  688. myisam_perc_index: 40.5390
  689. myisam_perc_data: 59.4610
  690. innodb_perc_total_index: 98.9253
  691. innodb_perc_total_data: 99.6030
  692. myisam_perc_total_index: 0.3924
  693. myisam_perc_total_data: 0.1714
  694.  
  695. ----------------------------
  696. MySQL settings
  697. ----------------------------
  698. [mysqld]
  699. character-set-server=utf8
  700. datadir=/var/lib/mysql
  701. socket=/var/lib/mysql/mysql.sock
  702.  
  703. #bind-address=127.0.0.1
  704.  
  705. tmpdir=/home/mysqltmp
  706.  
  707. skip-federated
  708. #skip-pbxt
  709. #skip-pbxt_statistics
  710. skip-archive
  711. #skip-name-resolve
  712. #old_passwords
  713. back_log = 75
  714. max_connections = 100
  715. key_buffer_size = 64M
  716. myisam_sort_buffer_size = 32M
  717. myisam_max_sort_file_size = 2048M
  718. join_buffer_size = 256K
  719. read_buffer_size = 256K
  720. sort_buffer_size = 512K
  721. table_definition_cache = 8192
  722. table_open_cache = 8192
  723. thread_cache_size = 64
  724. wait_timeout = 120
  725. connect_timeout = 10
  726. tmp_table_size = 512M
  727. max_heap_table_size = 512M
  728. max_allowed_packet = 32M
  729. max_seeks_for_key = 1000
  730. group_concat_max_len = 102400
  731. max_length_for_sort_data = 1024
  732. net_buffer_length = 16384
  733. max_connect_errors = 100000
  734. concurrent_insert = 2
  735. read_rnd_buffer_size = 256K
  736. bulk_insert_buffer_size = 8M
  737. query_cache_limit = 8MB
  738. query_cache_size = 256M
  739. query_cache_type = 1
  740. query_cache_min_res_unit = 2K
  741. query_prealloc_size = 262144
  742. query_alloc_block_size = 65536
  743. transaction_alloc_block_size = 8192
  744. transaction_prealloc_size = 4096
  745. default-storage-engine = InnoDB
  746.  
  747. log_warnings=1
  748. slow_query_log=0
  749. long_query_time=1
  750. slow_query_log_file=/var/lib/mysql/slowq.log
  751. log-error=/var/log/mysqld.log
  752.  
  753. # innodb settings
  754. #innodb_extra_rsegments = 4
  755. innodb_purge_threads=1
  756. innodb_doublewrite = 1
  757.  
  758. innodb_file_per_table = 1
  759. innodb_open_files = 1000
  760. innodb_data_file_path= ibdata1:10M:autoextend
  761. innodb_buffer_pool_size = 4G
  762. innodb_additional_mem_pool_size = 32M
  763.  
  764. innodb_log_files_in_group = 2
  765. innodb_log_file_size = 256M
  766. innodb_log_buffer_size = 8M
  767. innodb_flush_log_at_trx_commit = 2
  768. innodb_thread_concurrency = 0
  769. innodb_lock_wait_timeout=50
  770. innodb_flush_method = O_DIRECT
  771. innodb_support_xa=1
  772.  
  773. # 200 * # DISKS
  774. innodb_io_capacity = 100
  775. innodb_read_io_threads = 2
  776. innodb_write_io_threads = 2
  777.  
  778. # mariadb settings
  779. [mariadb]
  780. #thread-handling = pool-of-threads
  781. #thread-pool-size= 20
  782. #mysql --port=3307 --protocol=tcp
  783. #extra-port=3307
  784. #extra-max-connections=1
  785.  
  786. userstat = 0
  787. key_cache_segments = 1
  788. aria_group_commit = none
  789. aria_group_commit_interval = 0
  790. aria_log_file_size = 32M
  791. aria_log_purge_type = immediate
  792. aria_pagecache_buffer_size = 8M
  793. aria_sort_buffer_size = 8M
  794.  
  795. [mariadb-5.5]
  796. #ignore_db_dirs=
  797. query_cache_strip_comments=0
  798.  
  799. #innodb_lazy_drop_table=1
  800. innodb_read_ahead = linear
  801. innodb_adaptive_flushing_method = estimate
  802. innodb_flush_neighbor_pages = 1
  803. innodb_stats_update_need_lock = 0
  804. innodb_log_block_size = 512
  805.  
  806. log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
  807.  
  808. [mysqld_safe]
  809. socket=/var/lib/mysql/mysql.sock
  810. log-error=/var/log/mysqld.log
  811. #nice = -5
  812. open-files-limit = 8192
  813.  
  814. [mysqldump]
  815. quick
  816. max_allowed_packet = 32M
  817.  
  818. [myisamchk]
  819. key_buffer = 32M
  820. sort_buffer = 16M
  821. read_buffer = 16M
  822. write_buffer = 16M
  823.  
  824. [mysqlhotcopy]
  825. interactive-timeout---
  826. +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  827. | Variable_name | Value |
  828. +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  829. | aria_block_size | 8192 |
  830. | aria_checkpoint_interval | 30 |
  831. | aria_checkpoint_log_activity | 1048576 |
  832. | aria_force_start_after_recovery_failures | 0 |
  833. | aria_group_commit | none |
  834. | aria_group_commit_interval | 0 |
  835. | aria_log_file_size | 33554432 |
  836. | aria_log_purge_type | immediate |
  837. | aria_max_sort_file_size | 9223372036853727232 |
  838. | aria_page_checksum | ON |
  839. | aria_pagecache_age_threshold | 300 |
  840. | aria_pagecache_buffer_size | 8388608 |
  841. | aria_pagecache_division_limit | 100 |
  842. | aria_recover | NORMAL |
  843. | aria_repair_threads | 1 |
  844. | aria_sort_buffer_size | 8388608 |
  845. | aria_stats_method | nulls_unequal |
  846. | aria_sync_log_dir | NEWFILE |
  847. | aria_used_for_temp_tables | ON |
  848. | auto_increment_increment | 1 |
  849. | auto_increment_offset | 1 |
  850. | autocommit | ON |
  851. | automatic_sp_privileges | ON |
  852. | back_log | 75 |
  853. | basedir | /usr |
  854. | big_tables | OFF |
  855. | binlog_annotate_row_events | OFF |
  856. | binlog_cache_size | 32768 |
  857. | binlog_checksum | NONE |
  858. | binlog_direct_non_transactional_updates | OFF |
  859. | binlog_format | STATEMENT |
  860. | binlog_optimize_thread_scheduling | ON |
  861. | binlog_stmt_cache_size | 32768 |
  862. | bulk_insert_buffer_size | 8388608 |
  863. | character_set_client | utf8 |
  864. | character_set_connection | utf8 |
  865. | character_set_database | utf8 |
  866. | character_set_filesystem | binary |
  867. | character_set_results | utf8 |
  868. | character_set_server | utf8 |
  869. | character_set_system | utf8 |
  870. | character_sets_dir | /usr/share/mysql/charsets/ |
  871. | collation_connection | utf8_general_ci |
  872. | collation_database | utf8_general_ci |
  873. | collation_server | utf8_general_ci |
  874. | completion_type | NO_CHAIN |
  875. | concurrent_insert | ALWAYS |
  876. | connect_timeout | 10 |
  877. | datadir | /var/lib/mysql/ |
  878. | date_format | %Y-%m-%d |
  879. | datetime_format | %Y-%m-%d %H:%i:%s |
  880. | deadlock_search_depth_long | 15 |
  881. | deadlock_search_depth_short | 4 |
  882. | deadlock_timeout_long | 50000000 |
  883. | deadlock_timeout_short | 10000 |
  884. | debug_no_thread_alarm | OFF |
  885. | default_storage_engine | InnoDB |
  886. | default_week_format | 0 |
  887. | delay_key_write | ON |
  888. | delayed_insert_limit | 100 |
  889. | delayed_insert_timeout | 300 |
  890. | delayed_queue_size | 1000 |
  891. | div_precision_increment | 4 |
  892. | engine_condition_pushdown | OFF |
  893. | event_scheduler | OFF |
  894. | expensive_subquery_limit | 100 |
  895. | expire_logs_days | 0 |
  896. | extra_max_connections | 1 |
  897. | extra_port | 0 |
  898. | flush | OFF |
  899. | flush_time | 0 |
  900. | foreign_key_checks | ON |
  901. | ft_boolean_syntax | + -><()~*:""&| |
  902. | ft_max_word_len | 84 |
  903. | ft_min_word_len | 4 |
  904. | ft_query_expansion_limit | 20 |
  905. | ft_stopword_file | (built-in) |
  906. | general_log | OFF |
  907. | general_log_file | server.log |
  908. | group_concat_max_len | 102400 |
  909. | have_compress | YES |
  910. | have_crypt | YES |
  911. | have_csv | YES |
  912. | have_dynamic_loading | YES |
  913. | have_geometry | YES |
  914. | have_innodb | YES |
  915. | have_ndbcluster | NO |
  916. | have_openssl | DISABLED |
  917. | have_partitioning | YES |
  918. | have_profiling | YES |
  919. | have_query_cache | YES |
  920. | have_rtree_keys | YES |
  921. | have_ssl | DISABLED |
  922. | have_symlink | YES |
  923. | hostname | yourserverhostname |
  924. | ignore_builtin_innodb | OFF |
  925. | ignore_db_dirs | |
  926. | init_connect | |
  927. | init_file | |
  928. | init_slave | |
  929. | innodb_adaptive_flushing | ON |
  930. | innodb_adaptive_flushing_method | estimate |
  931. | innodb_adaptive_hash_index | ON |
  932. | innodb_adaptive_hash_index_partitions | 1 |
  933. | innodb_additional_mem_pool_size | 33554432 |
  934. | innodb_autoextend_increment | 8 |
  935. | innodb_autoinc_lock_mode | 1 |
  936. | innodb_blocking_buffer_pool_restore | OFF |
  937. | innodb_buffer_pool_instances | 1 |
  938. | innodb_buffer_pool_populate | OFF |
  939. | innodb_buffer_pool_restore_at_startup | 0 |
  940. | innodb_buffer_pool_shm_checksum | ON |
  941. | innodb_buffer_pool_shm_key | 0 |
  942. | innodb_buffer_pool_size | 4294967296 |
  943. | innodb_change_buffering | all |
  944. | innodb_checkpoint_age_target | 0 |
  945. | innodb_checksums | ON |
  946. | innodb_commit_concurrency | 0 |
  947. | innodb_concurrency_tickets | 500 |
  948. | innodb_corrupt_table_action | assert |
  949. | innodb_data_file_path | ibdata1:10M:autoextend |
  950. | innodb_data_home_dir | |
  951. | innodb_dict_size_limit | 0 |
  952. | innodb_doublewrite | ON |
  953. | innodb_doublewrite_file | |
  954. | innodb_fake_changes | OFF |
  955. | innodb_fast_checksum | OFF |
  956. | innodb_fast_shutdown | 1 |
  957. | innodb_file_format | Antelope |
  958. | innodb_file_format_check | ON |
  959. | innodb_file_format_max | Antelope |
  960. | innodb_file_per_table | ON |
  961. | innodb_flush_log_at_trx_commit | 2 |
  962. | innodb_flush_method | O_DIRECT |
  963. | innodb_flush_neighbor_pages | area |
  964. | innodb_force_load_corrupted | OFF |
  965. | innodb_force_recovery | 0 |
  966. | innodb_ibuf_accel_rate | 100 |
  967. | innodb_ibuf_active_contract | 1 |
  968. | innodb_ibuf_max_size | 2147467264 |
  969. | innodb_import_table_from_xtrabackup | 0 |
  970. | innodb_io_capacity | 100 |
  971. | innodb_kill_idle_transaction | 0 |
  972. | innodb_large_prefix | OFF |
  973. | innodb_lazy_drop_table | 0 |
  974. | innodb_lock_wait_timeout | 50 |
  975. | innodb_locking_fake_changes | ON |
  976. | innodb_locks_unsafe_for_binlog | OFF |
  977. | innodb_log_block_size | 512 |
  978. | innodb_log_buffer_size | 8388608 |
  979. | innodb_log_file_size | 268435456 |
  980. | innodb_log_files_in_group | 2 |
  981. | innodb_log_group_home_dir | ./ |
  982. | innodb_max_bitmap_file_size | 104857600 |
  983. | innodb_max_changed_pages | 1000000 |
  984. | innodb_max_dirty_pages_pct | 75 |
  985. | innodb_max_purge_lag | 0 |
  986. | innodb_merge_sort_block_size | 1048576 |
  987. | innodb_mirrored_log_groups | 1 |
  988. | innodb_old_blocks_pct | 37 |
  989. | innodb_old_blocks_time | 0 |
  990. | innodb_open_files | 1000 |
  991. | innodb_page_size | 16384 |
  992. | innodb_print_all_deadlocks | OFF |
  993. | innodb_purge_batch_size | 20 |
  994. | innodb_purge_threads | 1 |
  995. | innodb_random_read_ahead | OFF |
  996. | innodb_read_ahead | linear |
  997. | innodb_read_ahead_threshold | 56 |
  998. | innodb_read_io_threads | 2 |
  999. | innodb_recovery_stats | OFF |
  1000. | innodb_recovery_update_relay_log | OFF |
  1001. | innodb_replication_delay | 0 |
  1002. | innodb_rollback_on_timeout | OFF |
  1003. | innodb_rollback_segments | 128 |
  1004. | innodb_show_locks_held | 10 |
  1005. | innodb_show_verbose_locks | 0 |
  1006. | innodb_spin_wait_delay | 6 |
  1007. | innodb_stats_auto_update | 1 |
  1008. | innodb_stats_method | nulls_equal |
  1009. | innodb_stats_on_metadata | ON |
  1010. | innodb_stats_sample_pages | 8 |
  1011. | innodb_stats_update_need_lock | 0 |
  1012. | innodb_strict_mode | OFF |
  1013. | innodb_support_xa | ON |
  1014. | innodb_sync_spin_loops | 30 |
  1015. | innodb_table_locks | ON |
  1016. | innodb_thread_concurrency | 0 |
  1017. | innodb_thread_concurrency_timer_based | OFF |
  1018. | innodb_thread_sleep_delay | 10000 |
  1019. | innodb_track_changed_pages | OFF |
  1020. | innodb_use_atomic_writes | OFF |
  1021. | innodb_use_fallocate | OFF |
  1022. | innodb_use_global_flush_log_at_trx_commit | ON |
  1023. | innodb_use_native_aio | ON |
  1024. | innodb_use_stacktrace | OFF |
  1025. | innodb_use_sys_malloc | ON |
  1026. | innodb_use_sys_stats_table | OFF |
  1027. | innodb_version | 5.5.35-MariaDB-33.0 |
  1028. | innodb_write_io_threads | 2 |
  1029. | interactive_timeout | 28800 |
  1030. | join_buffer_size | 262144 |
  1031. | join_buffer_space_limit | 2097152 |
  1032. | join_cache_level | 2 |
  1033. | keep_files_on_create | OFF |
  1034. | key_buffer_size | 67108864 |
  1035. | key_cache_age_threshold | 300 |
  1036. | key_cache_block_size | 1024 |
  1037. | key_cache_division_limit | 100 |
  1038. | key_cache_segments | 1 |
  1039. | large_files_support | ON |
  1040. | large_page_size | 0 |
  1041. | large_pages | OFF |
  1042. | lc_messages | en_US |
  1043. | lc_messages_dir | |
  1044. | lc_time_names | en_US |
  1045. | license | GPL |
  1046. | local_infile | ON |
  1047. | lock_wait_timeout | 31536000 |
  1048. | locked_in_memory | OFF |
  1049. | log | OFF |
  1050. | log_bin | OFF |
  1051. | log_bin_trust_function_creators | OFF |
  1052. | log_error | /var/log/mysqld.log |
  1053. | log_output | FILE |
  1054. | log_queries_not_using_indexes | OFF |
  1055. | log_slave_updates | OFF |
  1056. | log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk |
  1057. | log_slow_queries | OFF |
  1058. | log_slow_rate_limit | 1 |
  1059. | log_slow_verbosity | |
  1060. | log_warnings | 1 |
  1061. | long_query_time | 1.000000 |
  1062. | low_priority_updates | OFF |
  1063. | lower_case_file_system | OFF |
  1064. | lower_case_table_names | 0 |
  1065. | master_verify_checksum | OFF |
  1066. | max_allowed_packet | 33554432 |
  1067. | max_binlog_cache_size | 18446744073709547520 |
  1068. | max_binlog_size | 1073741824 |
  1069. | max_binlog_stmt_cache_size | 18446744073709547520 |
  1070. | max_connect_errors | 100000 |
  1071. | max_connections | 100 |
  1072. | max_delayed_threads | 20 |
  1073. | max_error_count | 64 |
  1074. | max_heap_table_size | 536870912 |
  1075. | max_insert_delayed_threads | 20 |
  1076. | max_join_size | 18446744073709551615 |
  1077. | max_length_for_sort_data | 1024 |
  1078. | max_long_data_size | 33554432 |
  1079. | max_prepared_stmt_count | 16382 |
  1080. | max_relay_log_size | 0 |
  1081. | max_seeks_for_key | 1000 |
  1082. | max_sort_length | 1024 |
  1083. | max_sp_recursion_depth | 0 |
  1084. | max_tmp_tables | 32 |
  1085. | max_user_connections | 0 |
  1086. | max_write_lock_count | 4294967295 |
  1087. | metadata_locks_cache_size | 1024 |
  1088. | min_examined_row_limit | 0 |
  1089. | mrr_buffer_size | 262144 |
  1090. | multi_range_count | 256 |
  1091. | myisam_block_size | 1024 |
  1092. | myisam_data_pointer_size | 6 |
  1093. | myisam_max_sort_file_size | 2147483648 |
  1094. | myisam_mmap_size | 18446744073709551615 |
  1095. | myisam_recover_options | DEFAULT |
  1096. | myisam_repair_threads | 1 |
  1097. | myisam_sort_buffer_size | 33554432 |
  1098. | myisam_stats_method | nulls_unequal |
  1099. | myisam_use_mmap | OFF |
  1100. | net_buffer_length | 16384 |
  1101. | net_read_timeout | 30 |
  1102. | net_retry_count | 10 |
  1103. | net_write_timeout | 60 |
  1104. | old | OFF |
  1105. | old_alter_table | OFF |
  1106. | old_mode | |
  1107. | old_passwords | OFF |
  1108. | open_files_limit | 16495 |
  1109. | optimizer_prune_level | 1 |
  1110. | optimizer_search_depth | 62 |
  1111. | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off |
  1112. | performance_schema | OFF |
  1113. | performance_schema_events_waits_history_long_size | 10000 |
  1114. | performance_schema_events_waits_history_size | 10 |
  1115. | performance_schema_max_cond_classes | 80 |
  1116. | performance_schema_max_cond_instances | 1000 |
  1117. | performance_schema_max_file_classes | 50 |
  1118. | performance_schema_max_file_handles | 32768 |
  1119. | performance_schema_max_file_instances | 10000 |
  1120. | performance_schema_max_mutex_classes | 200 |
  1121. | performance_schema_max_mutex_instances | 1000000 |
  1122. | performance_schema_max_rwlock_classes | 30 |
  1123. | performance_schema_max_rwlock_instances | 1000000 |
  1124. | performance_schema_max_table_handles | 100000 |
  1125. | performance_schema_max_table_instances | 50000 |
  1126. | performance_schema_max_thread_classes | 50 |
  1127. | performance_schema_max_thread_instances | 1000 |
  1128. | pid_file | /var/lib/mysql/yourserverhostname.pid |
  1129. | plugin_dir | /usr/lib64/mysql/plugin/ |
  1130. | plugin_maturity | unknown |
  1131. | port | 3306 |
  1132. | preload_buffer_size | 32768 |
  1133. | profiling | OFF |
  1134. | profiling_history_size | 15 |
  1135. | progress_report_time | 56 |
  1136. | protocol_version | 10 |
  1137. | query_alloc_block_size | 65536 |
  1138. | query_cache_limit | 8388608 |
  1139. | query_cache_min_res_unit | 2048 |
  1140. | query_cache_size | 268435456 |
  1141. | query_cache_strip_comments | OFF |
  1142. | query_cache_type | ON |
  1143. | query_cache_wlock_invalidate | OFF |
  1144. | query_prealloc_size | 262144 |
  1145. | range_alloc_block_size | 4096 |
  1146. | read_buffer_size | 262144 |
  1147. | read_only | OFF |
  1148. | read_rnd_buffer_size | 262144 |
  1149. | relay_log | |
  1150. | relay_log_index | |
  1151. | relay_log_info_file | relay-log.info |
  1152. | relay_log_purge | ON |
  1153. | relay_log_recovery | OFF |
  1154. | relay_log_space_limit | 0 |
  1155. | replicate_annotate_row_events | OFF |
  1156. | replicate_do_db | |
  1157. | replicate_do_table | |
  1158. | replicate_events_marked_for_skip | replicate |
  1159. | replicate_ignore_db | |
  1160. | replicate_ignore_table | |
  1161. | replicate_wild_do_table | |
  1162. | replicate_wild_ignore_table | |
  1163. | report_host | |
  1164. | report_password | |
  1165. | report_port | 3306 |
  1166. | report_user | |
  1167. | rowid_merge_buff_size | 8388608 |
  1168. | rpl_recovery_rank | 0 |
  1169. | secure_auth | OFF |
  1170. | secure_file_priv | |
  1171. | server_id | 0 |
  1172. | skip_external_locking | ON |
  1173. | skip_name_resolve | OFF |
  1174. | skip_networking | OFF |
  1175. | skip_show_database | OFF |
  1176. | slave_compressed_protocol | OFF |
  1177. | slave_exec_mode | STRICT |
  1178. | slave_load_tmpdir | /home/mysqltmp |
  1179. | slave_max_allowed_packet | 1073741824 |
  1180. | slave_net_timeout | 3600 |
  1181. | slave_skip_errors | OFF |
  1182. | slave_sql_verify_checksum | ON |
  1183. | slave_transaction_retries | 10 |
  1184. | slave_type_conversions | |
  1185. | slow_launch_time | 2 |
  1186. | slow_query_log | OFF |
  1187. | slow_query_log_file | /var/lib/mysql/slowq.log |
  1188. | socket | /var/lib/mysql/mysql.sock |
  1189. | sort_buffer_size | 524288 |
  1190. | sql_auto_is_null | OFF |
  1191. | sql_big_selects | ON |
  1192. | sql_big_tables | OFF |
  1193. | sql_buffer_result | OFF |
  1194. | sql_log_bin | ON |
  1195. | sql_log_off | OFF |
  1196. | sql_low_priority_updates | OFF |
  1197. | sql_max_join_size | 18446744073709551615 |
  1198. | sql_mode | |
  1199. | sql_notes | ON |
  1200. | sql_quote_show_create | ON |
  1201. | sql_safe_updates | OFF |
  1202. | sql_select_limit | 18446744073709551615 |
  1203. | sql_slave_skip_counter | 0 |
  1204. | sql_warnings | OFF |
  1205. | ssl_ca | |
  1206. | ssl_capath | |
  1207. | ssl_cert | |
  1208. | ssl_cipher | |
  1209. | ssl_key | |
  1210. | storage_engine | InnoDB |
  1211. | stored_program_cache | 256 |
  1212. | sync_binlog | 0 |
  1213. | sync_frm | ON |
  1214. | sync_master_info | 0 |
  1215. | sync_relay_log | 0 |
  1216. | sync_relay_log_info | 0 |
  1217. | system_time_zone | EST |
  1218. | table_definition_cache | 8192 |
  1219. | table_open_cache | 8192 |
  1220. | thread_cache_size | 64 |
  1221. | thread_concurrency | 10 |
  1222. | thread_handling | one-thread-per-connection |
  1223. | thread_pool_idle_timeout | 60 |
  1224. | thread_pool_max_threads | 500 |
  1225. | thread_pool_oversubscribe | 3 |
  1226. | thread_pool_size | 4 |
  1227. | thread_pool_stall_limit | 500 |
  1228. | thread_stack | 294912 |
  1229. | time_format | %H:%i:%s |
  1230. | time_zone | SYSTEM |
  1231. | timed_mutexes | OFF |
  1232. | tmp_table_size | 536870912 |
  1233. | tmpdir | /home/mysqltmp |
  1234. | transaction_alloc_block_size | 8192 |
  1235. | transaction_prealloc_size | 4096 |
  1236. | tx_isolation | REPEATABLE-READ |
  1237. | unique_checks | ON |
  1238. | updatable_views_with_limit | YES |
  1239. | userstat | OFF |
  1240. | version | 5.5.35-MariaDB |
  1241. | version_comment | MariaDB Server |
  1242. | version_compile_machine | x86_64 |
  1243. | version_compile_os | Linux |
  1244. | wait_timeout | 120 |
  1245. +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  1246. +------------------------------------------+--------------+
  1247. | Variable_name | Value |
  1248. +------------------------------------------+--------------+
  1249. | Aborted_clients | 0 |
  1250. | Aborted_connects | 2 |
  1251. | Access_denied_errors | 2 |
  1252. | Aria_pagecache_blocks_not_flushed | 0 |
  1253. | Aria_pagecache_blocks_unused | 983 |
  1254. | Aria_pagecache_blocks_used | 171 |
  1255. | Aria_pagecache_read_requests | 928005 |
  1256. | Aria_pagecache_reads | 32441 |
  1257. | Aria_pagecache_write_requests | 84615 |
  1258. | Aria_pagecache_writes | 0 |
  1259. | Aria_transaction_log_syncs | 0 |
  1260. | Binlog_commits | 0 |
  1261. | Binlog_group_commits | 0 |
  1262. | Binlog_snapshot_file | |
  1263. | Binlog_snapshot_position | 0 |
  1264. | Binlog_bytes_written | 0 |
  1265. | Binlog_cache_disk_use | 0 |
  1266. | Binlog_cache_use | 0 |
  1267. | Binlog_stmt_cache_disk_use | 0 |
  1268. | Binlog_stmt_cache_use | 0 |
  1269. | Busy_time | 0.000000 |
  1270. | Bytes_received | 7212100973 |
  1271. | Bytes_sent | 124660243422 |
  1272. | Com_admin_commands | 2 |
  1273. | Com_alter_db | 0 |
  1274. | Com_alter_db_upgrade | 0 |
  1275. | Com_alter_event | 0 |
  1276. | Com_alter_function | 0 |
  1277. | Com_alter_procedure | 0 |
  1278. | Com_alter_server | 0 |
  1279. | Com_alter_table | 168 |
  1280. | Com_alter_tablespace | 0 |
  1281. | Com_analyze | 0 |
  1282. | Com_assign_to_keycache | 0 |
  1283. | Com_begin | 0 |
  1284. | Com_binlog | 0 |
  1285. | Com_call_procedure | 0 |
  1286. | Com_change_db | 235 |
  1287. | Com_change_master | 0 |
  1288. | Com_check | 0 |
  1289. | Com_checksum | 0 |
  1290. | Com_commit | 73106 |
  1291. | Com_create_db | 1 |
  1292. | Com_create_event | 0 |
  1293. | Com_create_function | 0 |
  1294. | Com_create_index | 0 |
  1295. | Com_create_procedure | 0 |
  1296. | Com_create_server | 0 |
  1297. | Com_create_table | 159 |
  1298. | Com_create_trigger | 0 |
  1299. | Com_create_udf | 0 |
  1300. | Com_create_user | 0 |
  1301. | Com_create_view | 0 |
  1302. | Com_dealloc_sql | 0 |
  1303. | Com_delete | 92852 |
  1304. | Com_delete_multi | 36 |
  1305. | Com_do | 0 |
  1306. | Com_drop_db | 0 |
  1307. | Com_drop_event | 0 |
  1308. | Com_drop_function | 0 |
  1309. | Com_drop_index | 0 |
  1310. | Com_drop_procedure | 0 |
  1311. | Com_drop_server | 0 |
  1312. | Com_drop_table | 155 |
  1313. | Com_drop_trigger | 0 |
  1314. | Com_drop_user | 0 |
  1315. | Com_drop_view | 0 |
  1316. | Com_empty_query | 0 |
  1317. | Com_execute_sql | 0 |
  1318. | Com_flush | 0 |
  1319. | Com_grant | 0 |
  1320. | Com_ha_close | 0 |
  1321. | Com_ha_open | 0 |
  1322. | Com_ha_read | 0 |
  1323. | Com_help | 0 |
  1324. | Com_insert | 1924506 |
  1325. | Com_insert_select | 0 |
  1326. | Com_install_plugin | 0 |
  1327. | Com_kill | 0 |
  1328. | Com_load | 0 |
  1329. | Com_lock_tables | 1 |
  1330. | Com_optimize | 0 |
  1331. | Com_preload_keys | 0 |
  1332. | Com_prepare_sql | 0 |
  1333. | Com_purge | 0 |
  1334. | Com_purge_before_date | 0 |
  1335. | Com_release_savepoint | 72415 |
  1336. | Com_rename_table | 0 |
  1337. | Com_rename_user | 0 |
  1338. | Com_repair | 0 |
  1339. | Com_replace | 118802 |
  1340. | Com_replace_select | 0 |
  1341. | Com_reset | 0 |
  1342. | Com_resignal | 0 |
  1343. | Com_revoke | 0 |
  1344. | Com_revoke_all | 0 |
  1345. | Com_rollback | 53 |
  1346. | Com_rollback_to_savepoint | 1 |
  1347. | Com_savepoint | 72416 |
  1348. | Com_select | 5129958 |
  1349. | Com_set_option | 2735682 |
  1350. | Com_show_authors | 0 |
  1351. | Com_show_binlog_events | 0 |
  1352. | Com_show_binlogs | 8 |
  1353. | Com_show_charsets | 2 |
  1354. | Com_show_client_statistics | 0 |
  1355. | Com_show_collations | 2 |
  1356. | Com_show_contributors | 0 |
  1357. | Com_show_create_db | 0 |
  1358. | Com_show_create_event | 0 |
  1359. | Com_show_create_func | 0 |
  1360. | Com_show_create_proc | 0 |
  1361. | Com_show_create_table | 216 |
  1362. | Com_show_create_trigger | 0 |
  1363. | Com_show_databases | 10 |
  1364. | Com_show_engine_logs | 0 |
  1365. | Com_show_engine_mutex | 0 |
  1366. | Com_show_engine_status | 1 |
  1367. | Com_show_errors | 0 |
  1368. | Com_show_events | 2 |
  1369. | Com_show_fields | 372 |
  1370. | Com_show_function_status | 2 |
  1371. | Com_show_grants | 2 |
  1372. | Com_show_index_statistics | 0 |
  1373. | Com_show_keys | 2 |
  1374. | Com_show_master_status | 6 |
  1375. | Com_show_open_tables | 0 |
  1376. | Com_show_plugins | 0 |
  1377. | Com_show_privileges | 0 |
  1378. | Com_show_procedure_status | 2 |
  1379. | Com_show_processlist | 5 |
  1380. | Com_show_profile | 0 |
  1381. | Com_show_profiles | 0 |
  1382. | Com_show_relaylog_events | 0 |
  1383. | Com_show_slave_hosts | 0 |
  1384. | Com_show_slave_status | 6 |
  1385. | Com_show_status | 65 |
  1386. | Com_show_storage_engines | 1 |
  1387. | Com_show_table_statistics | 0 |
  1388. | Com_show_table_status | 219 |
  1389. | Com_show_tables | 18 |
  1390. | Com_show_triggers | 216 |
  1391. | Com_show_user_statistics | 0 |
  1392. | Com_show_variables | 99 |
  1393. | Com_show_warnings | 2 |
  1394. | Com_signal | 0 |
  1395. | Com_slave_start | 0 |
  1396. | Com_slave_stop | 0 |
  1397. | Com_stmt_close | 6403348 |
  1398. | Com_stmt_execute | 7510747 |
  1399. | Com_stmt_fetch | 0 |
  1400. | Com_stmt_prepare | 7510747 |
  1401. | Com_stmt_reprepare | 0 |
  1402. | Com_stmt_reset | 3033412 |
  1403. | Com_stmt_send_long_data | 0 |
  1404. | Com_truncate | 574 |
  1405. | Com_uninstall_plugin | 0 |
  1406. | Com_unlock_tables | 1 |
  1407. | Com_update | 244183 |
  1408. | Com_update_multi | 778 |
  1409. | Com_xa_commit | 0 |
  1410. | Com_xa_end | 0 |
  1411. | Com_xa_prepare | 0 |
  1412. | Com_xa_recover | 0 |
  1413. | Com_xa_rollback | 0 |
  1414. | Com_xa_start | 0 |
  1415. | Compression | OFF |
  1416. | Connections | 1295978 |
  1417. | Cpu_time | 0.000000 |
  1418. | Created_tmp_disk_tables | 33167 |
  1419. | Created_tmp_files | 230 |
  1420. | Created_tmp_tables | 261276 |
  1421. | Delayed_errors | 0 |
  1422. | Delayed_insert_threads | 3 |
  1423. | Delayed_writes | 200574 |
  1424. | Empty_queries | 603197 |
  1425. | Executed_events | 0 |
  1426. | Executed_triggers | 0 |
  1427. | Feature_dynamic_columns | 0 |
  1428. | Feature_fulltext | 0 |
  1429. | Feature_gis | 0 |
  1430. | Feature_locale | 0 |
  1431. | Feature_subquery | 903 |
  1432. | Feature_timezone | 1 |
  1433. | Feature_trigger | 0 |
  1434. | Feature_xml | 0 |
  1435. | Flush_commands | 2 |
  1436. | Handler_commit | 4259088 |
  1437. | Handler_delete | 710400 |
  1438. | Handler_discover | 0 |
  1439. | Handler_icp_attempts | 4968248497 |
  1440. | Handler_icp_match | 4967904497 |
  1441. | Handler_mrr_init | 0 |
  1442. | Handler_mrr_key_refills | 0 |
  1443. | Handler_mrr_rowid_refills | 0 |
  1444. | Handler_prepare | 0 |
  1445. | Handler_read_first | 44702 |
  1446. | Handler_read_key | 96117091 |
  1447. | Handler_read_last | 202081 |
  1448. | Handler_read_next | 5104097022 |
  1449. | Handler_read_prev | 2503832782 |
  1450. | Handler_read_rnd | 5437428 |
  1451. | Handler_read_rnd_deleted | 116140001 |
  1452. | Handler_read_rnd_next | 995907934 |
  1453. | Handler_rollback | 91 |
  1454. | Handler_savepoint | 72239 |
  1455. | Handler_savepoint_rollback | 0 |
  1456. | Handler_tmp_update | 190064 |
  1457. | Handler_tmp_write | 18526283 |
  1458. | Handler_update | 1563203 |
  1459. | Handler_write | 2716492 |
  1460. | Innodb_adaptive_hash_cells | 8850461 |
  1461. | Innodb_adaptive_hash_hash_searches | 4984897499 |
  1462. | Innodb_adaptive_hash_heap_buffers | 4829 |
  1463. | Innodb_adaptive_hash_non_hash_searches | 384374605 |
  1464. | Innodb_background_log_sync | 491174 |
  1465. | Innodb_buffer_pool_bytes_data | 1310638080 |
  1466. | Innodb_buffer_pool_bytes_dirty | 1277952 |
  1467. | Innodb_buffer_pool_pages_data | 79995 |
  1468. | Innodb_buffer_pool_pages_dirty | 78 |
  1469. | Innodb_buffer_pool_pages_flushed | 3655857 |
  1470. | Innodb_buffer_pool_pages_free | 177318 |
  1471. | Innodb_buffer_pool_pages_LRU_flushed | 0 |
  1472. | Innodb_buffer_pool_pages_made_not_young | 0 |
  1473. | Innodb_buffer_pool_pages_made_young | 1047 |
  1474. | Innodb_buffer_pool_pages_misc | 4830 |
  1475. | Innodb_buffer_pool_pages_old | 29549 |
  1476. | Innodb_buffer_pool_pages_total | 262143 |
  1477. | Innodb_buffer_pool_read_ahead | 10144 |
  1478. | Innodb_buffer_pool_read_ahead_evicted | 0 |
  1479. | Innodb_buffer_pool_read_ahead_rnd | 0 |
  1480. | Innodb_buffer_pool_read_requests | 16899778805 |
  1481. | Innodb_buffer_pool_reads | 57644 |
  1482. | Innodb_buffer_pool_wait_free | 0 |
  1483. | Innodb_buffer_pool_write_requests | 27201607 |
  1484. | Innodb_checkpoint_age | 59512 |
  1485. | Innodb_checkpoint_max_age | 434154333 |
  1486. | Innodb_checkpoint_target_age | 420587011 |
  1487. | Innodb_current_row_locks | 0 |
  1488. | Innodb_data_fsyncs | 636730 |
  1489. | Innodb_data_pending_fsyncs | 0 |
  1490. | Innodb_data_pending_reads | 0 |
  1491. | Innodb_data_pending_writes | 0 |
  1492. | Innodb_data_read | 1157287936 |
  1493. | Innodb_data_reads | 70716 |
  1494. | Innodb_data_writes | 4887298 |
  1495. | Innodb_data_written | 123604155904 |
  1496. | Innodb_dblwr_pages_written | 3655857 |
  1497. | Innodb_dblwr_writes | 77217 |
  1498. | Innodb_deadlocks | 0 |
  1499. | Innodb_descriptors_memory | 8000 |
  1500. | Innodb_dict_tables | 360 |
  1501. | Innodb_have_atomic_builtins | ON |
  1502. | Innodb_history_list_length | 2525 |
  1503. | Innodb_ibuf_discarded_delete_marks | 0 |
  1504. | Innodb_ibuf_discarded_deletes | 0 |
  1505. | Innodb_ibuf_discarded_inserts | 0 |
  1506. | Innodb_ibuf_free_list | 32 |
  1507. | Innodb_ibuf_merged_delete_marks | 57924 |
  1508. | Innodb_ibuf_merged_deletes | 1095 |
  1509. | Innodb_ibuf_merged_inserts | 2602 |
  1510. | Innodb_ibuf_merges | 3649 |
  1511. | Innodb_ibuf_segment_size | 34 |
  1512. | Innodb_ibuf_size | 1 |
  1513. | Innodb_log_waits | 0 |
  1514. | Innodb_log_write_requests | 6921708 |
  1515. | Innodb_log_writes | 1066891 |
  1516. | Innodb_lsn_current | 35761367903 |
  1517. | Innodb_lsn_flushed | 35761367903 |
  1518. | Innodb_lsn_last_checkpoint | 35761308391 |
  1519. | Innodb_master_thread_1_second_loops | 558435 |
  1520. | Innodb_master_thread_10_second_loops | 54558 |
  1521. | Innodb_master_thread_background_loops | 16048 |
  1522. | Innodb_master_thread_main_flush_loops | 16048 |
  1523. | Innodb_master_thread_sleeps | 558288 |
  1524. | Innodb_max_trx_id | 32653398 |
  1525. | Innodb_mem_adaptive_hash | 149942624 |
  1526. | Innodb_mem_dictionary | 20236985 |
  1527. | Innodb_mem_total | 4408213504 |
  1528. | Innodb_mutex_os_waits | 7730 |
  1529. | Innodb_mutex_spin_rounds | 1576538 |
  1530. | Innodb_mutex_spin_waits | 4062663 |
  1531. | Innodb_oldest_view_low_limit_trx_id | 32653398 |
  1532. | Innodb_os_log_fsyncs | 260569 |
  1533. | Innodb_os_log_pending_fsyncs | 0 |
  1534. | Innodb_os_log_pending_writes | 0 |
  1535. | Innodb_os_log_written | 3780146176 |
  1536. | Innodb_page_size | 16384 |
  1537. | Innodb_pages_created | 15972 |
  1538. | Innodb_pages_read | 70501 |
  1539. | Innodb_pages_written | 3655857 |
  1540. | Innodb_purge_trx_id | 32653375 |
  1541. | Innodb_purge_undo_no | 0 |
  1542. | Innodb_read_views_memory | 152 |
  1543. | Innodb_row_lock_current_waits | 0 |
  1544. | Innodb_row_lock_time | 1148 |
  1545. | Innodb_row_lock_time_avg | 7 |
  1546. | Innodb_row_lock_time_max | 185 |
  1547. | Innodb_row_lock_waits | 151 |
  1548. | Innodb_rows_deleted | 655264 |
  1549. | Innodb_rows_inserted | 1151664 |
  1550. | Innodb_rows_read | 8468905269 |
  1551. | Innodb_rows_updated | 911699 |
  1552. | Innodb_s_lock_os_waits | 59251 |
  1553. | Innodb_s_lock_spin_rounds | 1838030 |
  1554. | Innodb_s_lock_spin_waits | 77710 |
  1555. | Innodb_truncated_status_writes | 0 |
  1556. | Innodb_x_lock_os_waits | 7314 |
  1557. | Innodb_x_lock_spin_rounds | 486465 |
  1558. | Innodb_x_lock_spin_waits | 34469 |
  1559. | Key_blocks_not_flushed | 0 |
  1560. | Key_blocks_unused | 53577 |
  1561. | Key_blocks_used | 25 |
  1562. | Key_blocks_warm | 0 |
  1563. | Key_read_requests | 16719 |
  1564. | Key_reads | 9 |
  1565. | Key_write_requests | 3164 |
  1566. | Key_writes | 299 |
  1567. | Last_query_cost | 0.000000 |
  1568. | Max_used_connections | 50 |
  1569. | Not_flushed_delayed_rows | 0 |
  1570. | Open_files | 72 |
  1571. | Open_streams | 0 |
  1572. | Open_table_definitions | 411 |
  1573. | Open_tables | 723 |
  1574. | Opened_files | 135739 |
  1575. | Opened_table_definitions | 1798 |
  1576. | Opened_tables | 4588 |
  1577. | Opened_views | 0 |
  1578. | Performance_schema_cond_classes_lost | 0 |
  1579. | Performance_schema_cond_instances_lost | 0 |
  1580. | Performance_schema_file_classes_lost | 0 |
  1581. | Performance_schema_file_handles_lost | 0 |
  1582. | Performance_schema_file_instances_lost | 0 |
  1583. | Performance_schema_locker_lost | 0 |
  1584. | Performance_schema_mutex_classes_lost | 0 |
  1585. | Performance_schema_mutex_instances_lost | 0 |
  1586. | Performance_schema_rwlock_classes_lost | 0 |
  1587. | Performance_schema_rwlock_instances_lost | 0 |
  1588. | Performance_schema_table_handles_lost | 0 |
  1589. | Performance_schema_table_instances_lost | 0 |
  1590. | Performance_schema_thread_classes_lost | 0 |
  1591. | Performance_schema_thread_instances_lost | 0 |
  1592. | Prepared_stmt_count | 0 |
  1593. | Qcache_free_blocks | 3945 |
  1594. | Qcache_free_memory | 157766520 |
  1595. | Qcache_hits | 2249473 |
  1596. | Qcache_inserts | 2721538 |
  1597. | Qcache_lowmem_prunes | 0 |
  1598. | Qcache_not_cached | 23278 |
  1599. | Qcache_queries_in_cache | 45515 |
  1600. | Qcache_total_blocks | 95780 |
  1601. | Queries | 28709261 |
  1602. | Questions | 11761754 |
  1603. | Rows_read | 8635000881 |
  1604. | Rows_sent | 153694926 |
  1605. | Rows_tmp_read | 19586882 |
  1606. | Rpl_status | AUTH_MASTER |
  1607. | Select_full_join | 291 |
  1608. | Select_full_range_join | 0 |
  1609. | Select_range | 544890 |
  1610. | Select_range_check | 0 |
  1611. | Select_scan | 601488 |
  1612. | Slave_heartbeat_period | 0.000 |
  1613. | Slave_open_temp_tables | 0 |
  1614. | Slave_received_heartbeats | 0 |
  1615. | Slave_retried_transactions | 0 |
  1616. | Slave_running | OFF |
  1617. | Slow_launch_threads | 0 |
  1618. | Slow_queries | 186 |
  1619. | Sort_merge_passes | 111 |
  1620. | Sort_range | 268517 |
  1621. | Sort_rows | 11552166 |
  1622. | Sort_scan | 287332 |
  1623. | Ssl_accept_renegotiates | 0 |
  1624. | Ssl_accepts | 0 |
  1625. | Ssl_callback_cache_hits | 0 |
  1626. | Ssl_cipher | |
  1627. | Ssl_cipher_list | |
  1628. | Ssl_client_connects | 0 |
  1629. | Ssl_connect_renegotiates | 0 |
  1630. | Ssl_ctx_verify_depth | 0 |
  1631. | Ssl_ctx_verify_mode | 0 |
  1632. | Ssl_default_timeout | 0 |
  1633. | Ssl_finished_accepts | 0 |
  1634. | Ssl_finished_connects | 0 |
  1635. | Ssl_session_cache_hits | 0 |
  1636. | Ssl_session_cache_misses | 0 |
  1637. | Ssl_session_cache_mode | NONE |
  1638. | Ssl_session_cache_overflows | 0 |
  1639. | Ssl_session_cache_size | 0 |
  1640. | Ssl_session_cache_timeouts | 0 |
  1641. | Ssl_sessions_reused | 0 |
  1642. | Ssl_used_session_cache_entries | 0 |
  1643. | Ssl_verify_depth | 0 |
  1644. | Ssl_verify_mode | 0 |
  1645. | Ssl_version | |
  1646. | Subquery_cache_hit | 0 |
  1647. | Subquery_cache_miss | 0 |
  1648. | Syncs | 316 |
  1649. | Table_locks_immediate | 10376642 |
  1650. | Table_locks_waited | 446 |
  1651. | Tc_log_max_pages_used | 0 |
  1652. | Tc_log_page_size | 0 |
  1653. | Tc_log_page_waits | 0 |
  1654. | Threadpool_idle_threads | 0 |
  1655. | Threadpool_threads | 0 |
  1656. | Threads_cached | 49 |
  1657. | Threads_connected | 1 |
  1658. | Threads_created | 50 |
  1659. | Threads_running | 1 |
  1660. | Uptime | 469757 |
  1661. | Uptime_since_flush_status | 469757 |
  1662. +------------------------------------------+--------------+
  1663. +---------+---------+-----------+-----------------+----------------+------+--------------------+------------------+----------+
  1664. | Id | User | Host | db | Command | Time | State | Info | Progress |
  1665. +---------+---------+-----------+-----------------+----------------+------+--------------------+------------------+----------+
  1666. | 1286383 | DELAYED | localhost | phc_net_live_db | Delayed insert | 1 | Waiting for INSERT | | 0.000 |
  1667. | 1295144 | DELAYED | localhost | phc_net_live_db | Delayed insert | 281 | Waiting for INSERT | | 0.000 |
  1668. | 1295585 | DELAYED | localhost | phc_net_live_db | Delayed insert | 114 | Waiting for INSERT | | 0.000 |
  1669. | 1295977 | root | localhost | | Query | 0 | | show processlist | 0.000 |
  1670. +---------+---------+-----------+-----------------+----------------+------+--------------------+------------------+----------+
  1671.  
  1672. ------------------------------------
  1673. INNODB Buffer Pool Stats
  1674. ------------------------------------
  1675. *************************** 1. row ***************************
  1676. POOL_ID: 0
  1677. POOL_SIZE: 262143
  1678. FREE_BUFFERS: 177318
  1679. DATABASE_PAGES: 79995
  1680. OLD_DATABASE_PAGES: 29549
  1681. MODIFIED_DATABASE_PAGES: 78
  1682. PENDING_DECOMPRESS: 0
  1683. PENDING_READS: 0
  1684. PENDING_FLUSH_LRU: 0
  1685. PENDING_FLUSH_LIST: 0
  1686. PAGES_MADE_YOUNG: 1047
  1687. PAGES_NOT_MADE_YOUNG: 0
  1688. PAGES_MADE_YOUNG_RATE: 0
  1689. PAGES_MADE_NOT_YOUNG_RATE: 0
  1690. NUMBER_PAGES_READ: 70501
  1691. NUMBER_PAGES_CREATED: 15972
  1692. NUMBER_PAGES_WRITTEN: 3655857
  1693. PAGES_READ_RATE: 0.6727150415446992
  1694. PAGES_CREATE_RATE: 0.018181487609316194
  1695. PAGES_WRITTEN_RATE: 9.981636697514592
  1696. NUMBER_PAGES_GET: 16899778805
  1697. HIT_RATE: 1000
  1698. YOUNG_MAKE_PER_THOUSAND_GETS: 0
  1699. NOT_YOUNG_MAKE_PER_THOUSAND_GETS: 0
  1700. NUMBER_PAGES_READ_AHEAD: 10144
  1701. NUMBER_READ_AHEAD_EVICTED: 0
  1702. READ_AHEAD_RATE: 0
  1703. READ_AHEAD_EVICTED_RATE: 0
  1704. LRU_IO_TOTAL: 572
  1705. LRU_IO_CURRENT: 14
  1706. UNCOMPRESS_TOTAL: 0
  1707. UNCOMPRESS_CURRENT: 0
  1708.  
  1709. ----------------------------
  1710. INNODB Status
  1711. ----------------------------
  1712. *************************** 1. row ***************************
  1713. Type: InnoDB
  1714. Name:
  1715. Status:
  1716. =====================================
  1717. 140219 23:21:58 INNODB MONITOR OUTPUT
  1718. =====================================
  1719. Per second averages calculated from the last 55 seconds
  1720. -----------------
  1721. BACKGROUND THREAD
  1722. -----------------
  1723. srv_master_thread loops: 558435 1_second, 558288 sleeps, 54558 10_second, 16048 background, 16048 flush
  1724. srv_master_thread log flush and writes: 491174
  1725. ----------
  1726. SEMAPHORES
  1727. ----------
  1728. OS WAIT ARRAY INFO: reservation count 75276, signal count 195337
  1729. Mutex spin waits 4062663, rounds 1576538, OS waits 7730
  1730. RW-shared spins 77710, rounds 1838030, OS waits 59251
  1731. RW-excl spins 34469, rounds 486465, OS waits 7314
  1732. Spin rounds per wait: 0.39 mutex, 23.65 RW-shared, 14.11 RW-excl
  1733. --------
  1734. FILE I/O
  1735. --------
  1736. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  1737. I/O thread 1 state: waiting for completed aio requests (log thread)
  1738. I/O thread 2 state: waiting for completed aio requests (read thread)
  1739. I/O thread 3 state: waiting for completed aio requests (read thread)
  1740. I/O thread 4 state: waiting for completed aio requests (write thread)
  1741. I/O thread 5 state: waiting for completed aio requests (write thread)
  1742. Pending normal aio reads: 0 [0, 0] , aio writes: 0 [0, 0] ,
  1743. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  1744. Pending flushes (fsync) log: 0; buffer pool: 0
  1745. 70716 OS file reads, 4887298 OS file writes, 636730 OS fsyncs
  1746. 0.67 reads/s, 16384 avg bytes/read, 12.82 writes/s, 1.64 fsyncs/s
  1747. -------------------------------------
  1748. INSERT BUFFER AND ADAPTIVE HASH INDEX
  1749. -------------------------------------
  1750. Ibuf: size 1, free list len 32, seg size 34, 3649 merges
  1751. merged operations:
  1752. insert 2602, delete mark 57924, delete 1095
  1753. discarded operations:
  1754. insert 0, delete mark 0, delete 0
  1755. Hash table size 8850461, node heap has 4830 buffer(s)
  1756. 137.38 hash searches/s, 512.74 non-hash searches/s
  1757. ---
  1758. LOG
  1759. ---
  1760. Log sequence number 35761367903
  1761. Log flushed up to 35761367903
  1762. Last checkpoint at 35761308391
  1763. Max checkpoint age 434154333
  1764. Checkpoint age target 420587011
  1765. Modified age 59512
  1766. Checkpoint age 59512
  1767. 0 pending log writes, 0 pending chkp writes
  1768. 1123317 log i/o's done, 2.56 log i/o's/second
  1769. ----------------------
  1770. BUFFER POOL AND MEMORY
  1771. ----------------------
  1772. Total memory allocated 4408213504; in additional pool allocated 0
  1773. Total memory allocated by read views 152
  1774. Internal hash tables (constant factor + variable factor)
  1775. Adaptive hash index 149942624 (70803688 + 79138936)
  1776. Page hash 4426024 (buffer pool 0 only)
  1777. Dictionary cache 20236985 (17702416 + 2534569)
  1778. File system 235600 (82672 + 152928)
  1779. Lock system 10626080 (10625704 + 376)
  1780. Recovery system 0 (0 + 0)
  1781. Dictionary memory allocated 2534569
  1782. Buffer pool size 262143
  1783. Buffer pool size, bytes 4294950912
  1784. Free buffers 177318
  1785. Database pages 79995
  1786. Old database pages 29549
  1787. Modified db pages 78
  1788. Pending reads 0
  1789. Pending writes: LRU 0, flush list 0, single page 0
  1790. Pages made young 1047, not young 0
  1791. 0.00 youngs/s, 0.00 non-youngs/s
  1792. Pages read 70501, created 15972, written 3655857
  1793. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1794. No buffer pool page gets since the last printout
  1795. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1796. LRU len: 79995, unzip_LRU len: 0
  1797. I/O sum[572]:cur[14], unzip sum[0]:cur[0]
  1798. --------------
  1799. ROW OPERATIONS
  1800. --------------
  1801. 0 queries inside InnoDB, 0 queries in queue
  1802. 1 read views open inside InnoDB
  1803. 0 transactions active inside InnoDB
  1804. 0 out of 1000 descriptors used
  1805. ---OLDEST VIEW---
  1806. Normal read view
  1807. Read view low limit trx n:o 1F24056
  1808. Read view up limit trx id 1F24056
  1809. Read view low limit trx id 1F24056
  1810. Read view individually stored trx ids:
  1811. -----------------
  1812. Main thread process no. 4136, id 122747247249152, state: flushing log
  1813. Number of rows inserted 1151664, updated 911699, deleted 655264, read 8468905269
  1814. 0.09 inserts/s, 1.80 updates/s, 0.02 deletes/s, 9237.10 reads/s
  1815. ------------------------
  1816. LATEST DETECTED DEADLOCK
  1817. ------------------------
  1818. 140215 23:30:45
  1819. *** (1) TRANSACTION:
  1820. TRANSACTION 1C3A965, ACTIVE 0 sec starting index read
  1821. mysql tables in use 1, locked 1
  1822. LOCK WAIT 18 lock struct(s), heap size 3112, 10 row lock(s), undo log entries 12
  1823. MySQL thread id 318962, OS thread handle 0x6fa487c55700, query id 6553576 localhost root Updating
  1824. UPDATE `xf_forum` SET `discussion_count` = ?, `message_count` = ?, `last_post_date` = ?, `last_post_id` = ?, `last_post_user_id` = ?, `last_post_username` = ?, `last_thread_title` = ? WHERE (node_id = 94)
  1825. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  1826. RECORD LOCKS space id 2638 page no 5 n bits 136 index `PRIMARY` of table `phc_net_live_db`.`xf_forum` trx id 1C3A965 lock_mode X locks rec but not gap waiting
  1827. *** (2) TRANSACTION:
  1828. TRANSACTION 1C3A969, ACTIVE 0 sec fetching rows
  1829. mysql tables in use 1, locked 1
  1830. 2022 lock struct(s), heap size 244152, 476575 row lock(s), undo log entries 9
  1831. MySQL thread id 318868, OS thread handle 0x6fa347e12700, query id 6553612 localhost root Updating
  1832. UPDATE IGNORE xf_thread SET
  1833. last_post_user_id = 0,last_post_username = 'boom'
  1834. WHERE last_post_user_id = ?
  1835. *** (2) HOLDS THE LOCK(S):
  1836. RECORD LOCKS space id 2638 page no 5 n bits 136 index `PRIMARY` of table `phc_net_live_db`.`xf_forum` trx id 1C3A969 lock_mode X
  1837. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  1838. RECORD LOCKS space id 2479 page no 942 n bits 168 index `PRIMARY` of table `phc_net_live_db`.`xf_thread` trx id 1C3A969 lock_mode X waiting
  1839. *** WE ROLL BACK TRANSACTION (1)
  1840. ------------
  1841. TRANSACTIONS
  1842. ------------
  1843. Trx id counter 1F24056
  1844. Purge done for trx's n:o < 1F2403F undo n:o < 0
  1845. History list length 2525
  1846. LIST OF TRANSACTIONS FOR EACH SESSION:
  1847. ---TRANSACTION 0, not started
  1848. MySQL thread id 1295979, OS thread handle 0x6fa35b0a5700, query id 28709268 localhost root
  1849. show engine innodb status
  1850. ----------------------------
  1851. END OF INNODB MONITOR OUTPUT
  1852. ============================
  1853.  
  1854.  
  1855. ----------------------------
  1856. MySQL Error Log
  1857. ----------------------------
  1858.  
  1859. 140214 12:52:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  1860. 140214 12:52:41 InnoDB: Compressed tables use zlib 1.2.3
  1861. 140214 12:52:41 InnoDB: Using Linux native AIO
  1862. 140214 12:52:41 InnoDB: Initializing buffer pool, size = 4.0G
  1863. 140214 12:52:41 InnoDB: Completed initialization of buffer pool
  1864. 140214 12:52:41 InnoDB: highest supported file format is Barracuda.
  1865. 140214 12:52:42 InnoDB: Waiting for the background threads to start
  1866. 140214 12:52:43 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 32527463792
  1867. 140214 12:52:43 [Note] Plugin 'FEDERATED' is disabled.
  1868. 140214 12:52:43 [Note] Plugin 'ARCHIVE' is disabled.
  1869. 140214 12:52:43 [Note] Plugin 'FEEDBACK' is disabled.
  1870. 140214 12:52:43 [Note] Server socket created on IP: '0.0.0.0'.
  1871. 140214 12:52:43 [Note] Event Scheduler: Loaded 0 events
  1872. 140214 12:52:43 [Note] /usr/sbin/mysqld: ready for connections.
  1873. Version: '5.5.35-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
  1874.  
  1875. Report Complete:
  1876. Wed Feb 19 23:21:58 EST 2014
  1877. ----------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!