API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 16th, 2018
245
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.98 KB | None | 0 0
raw download clone embed print report
  1. | InnoDB | |
  2. =====================================
  3. 2018-08-16 14:35:30 7f3330084700 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 42 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 44105 srv_active, 0 srv_shutdown, 215330 srv_idle
  10. srv_master_thread log flush and writes: 259425
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 131020
  15. --Thread 139868031977216 has waited at lock0lock.cc line 4864 for 0.0000 seconds the semaphore:
  16. Mutex at 0x7f3580042078 '&lock_sys->mutex', lock var 1
  17. waiters flag 1
  18. --Thread 139857836291840 has waited at trx0trx.cc line 332 for 15.000 seconds the semaphore:
  19. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  20. waiters flag 0
  21. --Thread 139857833895680 has waited at trx0trx.cc line 332 for 20.000 seconds the semaphore:
  22. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  23. waiters flag 0
  24. --Thread 139857843214080 has waited at trx0trx.cc line 332 for 13.000 seconds the semaphore:
  25. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  26. waiters flag 0
  27. --Thread 139857828837120 has waited at trx0trx.cc line 332 for 13.000 seconds the semaphore:
  28. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  29. waiters flag 0
  30. --Thread 139857834960640 has waited at trx0trx.cc line 332 for 11.000 seconds the semaphore:
  31. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  32. waiters flag 0
  33. --Thread 139857833363200 has waited at trx0trx.cc line 332 for 11.000 seconds the semaphore:
  34. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  35. waiters flag 0
  36. --Thread 139857833629440 has waited at trx0trx.cc line 332 for 11.000 seconds the semaphore:
  37. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  38. waiters flag 0
  39. --Thread 139857831233280 has waited at trx0trx.cc line 332 for 11.000 seconds the semaphore:
  40. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  41. waiters flag 0
  42. --Thread 139857844279040 has waited at trx0trx.cc line 332 for 10.000 seconds the semaphore:
  43. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  44. waiters flag 0
  45. --Thread 139857842149120 has waited at trx0trx.cc line 332 for 10.000 seconds the semaphore:
  46. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  47. waiters flag 0
  48. --Thread 139857835493120 has waited at trx0trx.cc line 332 for 9.0000 seconds the semaphore:
  49. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  50. waiters flag 0
  51. --Thread 139857829902080 has waited at trx0trx.cc line 332 for 9.0000 seconds the semaphore:
  52. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  53. waiters flag 0
  54. --Thread 139857840019200 has waited at trx0trx.cc line 332 for 9.0000 seconds the semaphore:
  55. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  56. waiters flag 0
  57. --Thread 139857834161920 has waited at trx0trx.cc line 332 for 9.0000 seconds the semaphore:
  58. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  59. waiters flag 0
  60. --Thread 139857832298240 has waited at trx0trx.cc line 332 for 9.0000 seconds the semaphore:
  61. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  62. waiters flag 0
  63. --Thread 139857825642240 has waited at lock0lock.cc line 7388 for 2.0000 seconds the semaphore:
  64. Mutex at 0x5598adbab9f8 '&trx_sys->mutex', lock var 0
  65. waiters flag 0
  66. --Thread 139857921410816 has waited at log0log.cc line 2273 for 0.0000 seconds the semaphore:
  67. S-lock on RW-latch at 0x5598adba1488 '&log_sys->checkpoint_lock'
  68. a writer (thread id 139857921410816) has reserved it in mode exclusive
  69. number of readers 0, waiters flag 1, lock_word: 0
  70. Last time read locked in file log0log.cc line 2273
  71. Last time write locked in file /mnt/workspace/percona-xtradb-cluster-5.6-debian-binary-combined/label_exp/ubuntu-yakkety-64bit/percona-xtradb-cluster-5.6-5.6.37-26.21/storage/innobase/log/log0log.cc line 2056
  72. OS WAIT ARRAY INFO: signal count 2337063
  73. Mutex spin waits 1724845, rounds 2241075, OS waits 37487
  74. RW-shared spins 990104, rounds 3983193, OS waits 76935
  75. RW-excl spins 140157, rounds 3332887, OS waits 15290
  76. Spin rounds per wait: 1.30 mutex, 4.02 RW-shared, 23.78 RW-excl
  77. ------------
  78. TRANSACTIONS
  79. ------------
  80. Trx id counter 1062998581
  81. Purge done for trx's n:o < 1062997832 undo n:o < 0 state: running but idle
  82. History list length 2492
  83. LIST OF TRANSACTIONS FOR EACH SESSION:
  84. ---TRANSACTION 1062998572, not started
  85. MySQL thread id 1315551, OS thread handle 0x7f3330598700, query id 14380811 10.0.0.199 myuser
  86. ---TRANSACTION 1062998563, not started
  87. MySQL thread id 1315550, OS thread handle 0x7f33307e1700, query id 14380809 10.0.0.199 myuser
  88. ---TRANSACTION 1062998555, not started
  89. MySQL thread id 1315544, OS thread handle 0x7f3331105700, query id 14380795 10.0.0.199 myuser
  90. ---TRANSACTION 0, not started
  91. MySQL thread id 1315517, OS thread handle 0x7f3330084700, query id 14380767 localhost myuser init
  92. SHOW ENGINE INNODB STATUS
  93. ---TRANSACTION 1062998291, not started
  94. MySQL thread id 1315422, OS thread handle 0x7f3330043700, query id 14380265 10.0.0.199 myuser
  95. ---TRANSACTION 0, not started
  96. MySQL thread id 1164789, OS thread handle 0x7f3330cf5700, query id 14334528 10.0.10.200 myuser
  97. ---TRANSACTION 1062236688, not started
  98. MySQL thread id 1164790, OS thread handle 0x7f333020a700, query id 14334529 10.0.10.200 myuser
  99. ---TRANSACTION 1062998571, ACTIVE 0 sec starting index read
  100. mysql tables in use 3, locked 0
  101. MySQL thread id 1315542, OS thread handle 0x7f3330a6b700, query id 14380899 10.0.0.199 myuser Sending data
  102. SELECT WLClientRate, WLHours, MovementType, TonnesClientCharge, TicketWeight, ClientIncMinTonnes, TransClientCharge, SiteID, ID, GroupID, ClientID
  103. FROM tblmovements
  104. WHERE TicketStatus=1
  105. AND IsPaid=0
  106. AND ClientID=1288
  107. Trx read view will not see trx with id >= 1062998572, sees < 1062997718
  108. ---TRANSACTION 1062998529, ACTIVE (PREPARED) 0 sec flushing log
  109. 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1
  110. MySQL thread id 2, OS thread handle 0x7f35905c8700, query id 14380696 committing 7622342
  111. ---TRANSACTION 1062997906, ACTIVE 54 sec
  112. mysql tables in use 1, locked 1
  113. 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1
  114. MySQL thread id 1315406, OS thread handle 0x7f3330002700, query id 14379833 10.0.0.199 ggdashboard wsrep in pre-commit stage
  115. UPDATE tblopsjobs SET Status=1, PickedupBy=302 WHERE ID=116460
  116. ---TRANSACTION 1062997900, ACTIVE 54 sec
  117. mysql tables in use 1, locked 1
  118. 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
  119. MySQL thread id 1315207, OS thread handle 0x7f33308a4700, query id 14379815 10.0.0.199 ggdashboard wsrep in pre-commit stage
  120. INSERT INTO `tblmessages`(`sender_user_id`,`recipient_user_id`,`subject`,`body`,`is_quote`) VALUES ('136','87','Quote has been returned for more Information','Your quote has been returned to you by a buyer so you can provide more information. Please see the buyer note against the quote for more details.<br />Quote ID: 131180<br /><a href=\"dashboard.php?p=viewquote&qid=131180\">Click Here to view this quote</a>','0')
  121. ---TRANSACTION 1062997764, ACTIVE 54 sec
  122. mysql tables in use 1, locked 1
  123. 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1
  124. MySQL thread id 1315306, OS thread handle 0x7f3331042700, query id 14379477 10.0.0.199 ggdashboard wsrep in pre-commit stage
  125. UPDATE tblmessages SET IsWarned=1,CloseTimestamp=NOW() WHERE ID=3751635
  126. ---TRANSACTION 1062997718, ACTIVE 122 sec
  127. mysql tables in use 1, locked 1
  128. 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1
  129. MySQL thread id 1315274, OS thread handle 0x7f3330967700, query id 14379384 10.0.0.199 ggdashboard wsrep in pre-commit stage
  130. UPDATE tblquotes SET NotesFromBuyers='emailed mick g' WHERE ID=137190
  131. --------
  132. FILE I/O
  133. --------
  134. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  135. I/O thread 1 state: complete io for log (log thread)
  136. I/O thread 2 state: waiting for completed aio requests (read thread)
  137. I/O thread 3 state: waiting for completed aio requests (read thread)
  138. I/O thread 4 state: waiting for completed aio requests (read thread)
  139. I/O thread 5 state: waiting for completed aio requests (read thread)
  140. I/O thread 6 state: waiting for completed aio requests (write thread)
  141. I/O thread 7 state: waiting for completed aio requests (write thread)
  142. I/O thread 8 state: waiting for completed aio requests (write thread)
  143. I/O thread 9 state: waiting for completed aio requests (write thread)
  144. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 4 [2, 0, 0, 2] ,
  145. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  146. Pending flushes (fsync) log: 1; buffer pool: 0
  147. 199273 OS file reads, 1061290 OS file writes, 224374 OS fsyncs
  148. 0 pending preads, 1 pending pwrites
  149. 0.00 reads/s, 0 avg bytes/read, 1.31 writes/s, 0.40 fsyncs/s
  150. -------------------------------------
  151. INSERT BUFFER AND ADAPTIVE HASH INDEX
  152. -------------------------------------
  153. Ibuf: size 1, free list len 926, seg size 928, 4100 merges
  154. merged operations:
  155. insert 4617, delete mark 1922, delete 861
  156. discarded operations:
  157. insert 0, delete mark 0, delete 0
  158. 197.33 hash searches/s, 24.98 non-hash searches/s
  159. ---
  160. LOG
  161. ---
  162. Log sequence number 75440906299
  163. Log flushed up to 75440905751
  164. Pages flushed up to 75440905751
  165. Last checkpoint at 75440883664
  166. Max checkpoint age 434154333
  167. Checkpoint age target 420587011
  168. Modified age 548
  169. Checkpoint age 22635
  170. 0 pending log writes, 1 pending chkp writes
  171. 284526 log i/o's done, 0.05 log i/o's/second
  172. ----------------------
  173. BUFFER POOL AND MEMORY
  174. ----------------------
  175. Total memory allocated 8942256128; in additional pool allocated 0
  176. Total memory allocated by read views 1496
  177. Internal hash tables (constant factor + variable factor)
  178. Adaptive hash index 435798368 (151384312 + 284414056)
  179. Page hash 1107208 (buffer pool 0 only)
  180. Dictionary cache 44467070 (35402768 + 9064302)
  181. File system 1604392 (812272 + 792120)
  182. Lock system 21254168 (21250568 + 3600)
  183. Recovery system 0 (0 + 0)
  184. Dictionary memory allocated 9064302
  185. Buffer pool size 524280
  186. Buffer pool size, bytes 8589803520
  187. Free buffers 67073
  188. Database pages 439827
  189. Old database pages 162514
  190. Modified db pages 71
  191. Pending reads 0
  192. Pending writes: LRU 0, flush list 1, single page 0
  193. Pages made young 400, not young 0
  194. 0.00 youngs/s, 0.00 non-youngs/s
  195. Pages read 198428, created 241399, written 733388
  196. 0.02 reads/s, 0.00 creates/s, 1.28 writes/s
  197. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  198. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  199. LRU len: 439827, unzip_LRU len: 41
  200. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  201. ----------------------
  202. INDIVIDUAL BUFFER POOL INFO
  203. ----------------------
  204. ---BUFFER POOL 0
  205. Buffer pool size 65535
  206. Buffer pool size, bytes 1073725440
  207. Free buffers 7927
  208. Database pages 55436
  209. Old database pages 20483
  210. Modified db pages 2
  211. Pending reads 0
  212. Pending writes: LRU 0, flush list 0, single page 0
  213. Pages made young 45, not young 0
  214. 0.00 youngs/s, 0.00 non-youngs/s
  215. Pages read 25310, created 30126, written 133609
  216. 0.00 reads/s, 0.00 creates/s, 0.02 writes/s
  217. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  218. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  219. LRU len: 55436, unzip_LRU len: 0
  220. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  221. ---BUFFER POOL 1
  222. Buffer pool size 65535
  223. Buffer pool size, bytes 1073725440
  224. Free buffers 7231
  225. Database pages 56144
  226. Old database pages 20745
  227. Modified db pages 1
  228. Pending reads 0
  229. Pending writes: LRU 0, flush list 0, single page 0
  230. Pages made young 49, not young 0
  231. 0.00 youngs/s, 0.00 non-youngs/s
  232. Pages read 25581, created 30563, written 60789
  233. 0.00 reads/s, 0.00 creates/s, 0.02 writes/s
  234. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  235. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  236. LRU len: 56144, unzip_LRU len: 0
  237. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  238. ---BUFFER POOL 2
  239. Buffer pool size 65535
  240. Buffer pool size, bytes 1073725440
  241. Free buffers 8440
  242. Database pages 54927
  243. Old database pages 20295
  244. Modified db pages 1
  245. Pending reads 0
  246. Pending writes: LRU 0, flush list 0, single page 0
  247. Pages made young 48, not young 0
  248. 0.00 youngs/s, 0.00 non-youngs/s
  249. Pages read 24685, created 30242, written 98954
  250. 0.00 reads/s, 0.00 creates/s, 0.40 writes/s
  251. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  252. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  253. LRU len: 54927, unzip_LRU len: 0
  254. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  255. ---BUFFER POOL 3
  256. Buffer pool size 65535
  257. Buffer pool size, bytes 1073725440
  258. Free buffers 7718
  259. Database pages 55625
  260. Old database pages 20553
  261. Modified db pages 0
  262. Pending reads 0
  263. Pending writes: LRU 0, flush list 1, single page 0
  264. Pages made young 40, not young 0
  265. 0.00 youngs/s, 0.00 non-youngs/s
  266. Pages read 25492, created 30133, written 88475
  267. 0.00 reads/s, 0.00 creates/s, 0.05 writes/s
  268. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  269. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  270. LRU len: 55625, unzip_LRU len: 8
  271. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  272. ---BUFFER POOL 4
  273. Buffer pool size 65535
  274. Buffer pool size, bytes 1073725440
  275. Free buffers 8594
  276. Database pages 54768
  277. Old database pages 20237
  278. Modified db pages 24
  279. Pending reads 0
  280. Pending writes: LRU 0, flush list 0, single page 0
  281. Pages made young 56, not young 0
  282. 0.00 youngs/s, 0.00 non-youngs/s
  283. Pages read 24648, created 30120, written 106671
  284. 0.00 reads/s, 0.00 creates/s, 0.19 writes/s
  285. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  286. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  287. LRU len: 54768, unzip_LRU len: 0
  288. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  289. ---BUFFER POOL 5
  290. Buffer pool size 65535
  291. Buffer pool size, bytes 1073725440
  292. Free buffers 8998
  293. Database pages 54362
  294. Old database pages 20086
  295. Modified db pages 19
  296. Pending reads 0
  297. Pending writes: LRU 0, flush list 0, single page 0
  298. Pages made young 53, not young 0
  299. 0.00 youngs/s, 0.00 non-youngs/s
  300. Pages read 24174, created 30188, written 90000
  301. 0.00 reads/s, 0.00 creates/s, 0.07 writes/s
  302. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  303. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  304. LRU len: 54362, unzip_LRU len: 33
  305. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  306. ---BUFFER POOL 6
  307. Buffer pool size 65535
  308. Buffer pool size, bytes 1073725440
  309. Free buffers 8464
  310. Database pages 54896
  311. Old database pages 20284
  312. Modified db pages 9
  313. Pending reads 0
  314. Pending writes: LRU 0, flush list 0, single page 0
  315. Pages made young 44, not young 0
  316. 0.00 youngs/s, 0.00 non-youngs/s
  317. Pages read 24829, created 30067, written 74680
  318. 0.02 reads/s, 0.00 creates/s, 0.23 writes/s
  319. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  320. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  321. LRU len: 54896, unzip_LRU len: 0
  322. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  323. ---BUFFER POOL 7
  324. Buffer pool size 65535
  325. Buffer pool size, bytes 1073725440
  326. Free buffers 9701
  327. Database pages 53669
  328. Old database pages 19831
  329. Modified db pages 15
  330. Pending reads 0
  331. Pending writes: LRU 0, flush list 0, single page 0
  332. Pages made young 65, not young 0
  333. 0.00 youngs/s, 0.00 non-youngs/s
  334. Pages read 23709, created 29960, written 80210
  335. 0.00 reads/s, 0.00 creates/s, 0.30 writes/s
  336. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  337. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  338. LRU len: 53669, unzip_LRU len: 0
  339. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  340. --------------
  341. ROW OPERATIONS
  342. --------------
  343. 0 queries inside InnoDB, 0 queries in queue
  344. 2 read views open inside InnoDB
  345. 3 RW transactions active inside InnoDB
  346. 0 RO transactions active inside InnoDB
  347. 3 out of 1000 descriptors used
  348. ---OLDEST VIEW---
  349. Normal read view
  350. Read view low limit trx n:o 1062998794
  351. Read view up limit trx id 1062998761
  352. Read view low limit trx id 1062998794
  353. Read view individually stored trx ids:
  354. Read view trx id 1062998761
  355. Read view trx id 1062998791
  356. -----------------
  357. Main thread process no. 74272, id 139857921410816, state: making checkpoint
  358. Number of rows inserted 12306622, updated 75973, deleted 4943, read 62930576163
  359. 0.45 inserts/s, 0.40 updates/s, 0.00 deletes/s, 74599.03 reads/s
  360. ----------------------------
  361. END OF INNODB MONITOR OUTPUT
  362. ============================
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!