API tools faq
paste
Guest User

Untitled

a guest
Jun 15th, 2016
165
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 10.65 KB | None | 0 0
raw download clone embed print report
  1. MariaDB [(none)]> show engine innodb status\G
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 2016-06-16 00:15:54 7f496a16b700 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 31 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 150 srv_active, 0 srv_shutdown, 259 srv_idle
  14. srv_master_thread log flush and writes: 409
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 345
  19. --Thread 139951417046784 has waited at log0log.cc line 2317 for 2.0000 seconds the semaphore:
  20. S-lock on RW-latch at 0x7f496804ae58 '&log_sys->checkpoint_lock'
  21. a writer (thread id 139951417046784) has reserved it in mode  exclusive
  22. number of readers 0, waiters flag 1, lock_word: 0
  23. Last time read locked in file log0log.cc line 2317
  24. Last time write locked in file /build/mariadb-10.0-oPbJVK/mariadb-10.0-10.0.23/storage/xtradb/log/log0log.cc line 2086
  25. --Thread 139951400261376 has waited at buf0flu.cc line 1850 for 1.0000 seconds the semaphore:
  26. Mutex at 0x7f495bf08de8 '&buf_pool->flush_state_mutex', lock var 1
  27. waiters flag 1
  28. OS WAIT ARRAY INFO: signal count 319
  29. Mutex spin waits 239, rounds 6188, OS waits 204
  30. RW-shared spins 125, rounds 3693, OS waits 122
  31. RW-excl spins 21, rounds 602, OS waits 6
  32. Spin rounds per wait: 25.89 mutex, 29.54 RW-shared, 28.67 RW-excl
  33. ------------
  34. TRANSACTIONS
  35. ------------
  36. Trx id counter 3758801
  37. Purge done for trx's n:o < 3758587 undo n:o < 0 state: running but idle
  38. History list length 628
  39. LIST OF TRANSACTIONS FOR EACH SESSION:
  40. ---TRANSACTION 3756724, not started
  41. MySQL thread id 42, OS thread handle 0x7f496a16b700, query id 83165 localhost root init
  42. show engine innodb status
  43. ---TRANSACTION 3755553, not started
  44. MySQL thread id 7, OS thread handle 0x7f496a1cd700, query id 75446 85.223.151.22 ulet_crm_user cleaning up
  45. ---TRANSACTION 3755551, not started
  46. MySQL thread id 6, OS thread handle 0x7f496a1fe700, query id 75439 85.223.151.22 ulet_crm_user cleaning up
  47. ---TRANSACTION 3755549, not started
  48. MySQL thread id 5, OS thread handle 0x7f496a22f700, query id 75413 85.223.151.22 ulet_crm_user cleaning up
  49. ---TRANSACTION 3758253, not started
  50. MySQL thread id 4, OS thread handle 0x7f496a260700, query id 75455 85.223.151.22 ulet_crm_user cleaning up
  51. ---TRANSACTION 3758767, not started
  52. MySQL thread id 3, OS thread handle 0x7f496a291700, query id 75632 85.223.151.22 ulet_crm_user cleaning up
  53. ---TRANSACTION 3758799, ACTIVE 3 sec starting index read
  54. mysql tables in use 1, locked 1
  55. LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
  56. MySQL thread id 309, OS thread handle 0x7f4968836700, query id 78419 localhost uletpro updating
  57. DELETE FROM dl_commerce_ks2_semaphore
  58. WHERE  (value = '15467693335761c586ebb7f6.24090997')
  59. Trx #rec lock waits 1 #table lock waits 0
  60. Trx total rec lock wait time 0 SEC
  61. Trx total table lock wait time 0 SEC
  62. ------- TRX HAS BEEN WAITING 3 SEC FOR THIS LOCK TO BE GRANTED:
  63. RECORD LOCKS space id 2752 page no 3 n bits 112 index "PRIMARY" of table "ulet7pro"."dl_commerce_ks2_semaphore" trx table locks 1 total table locks 3  trx id 3758799 lock_mode X waiting lock hold time 3 wait time before grant 0
  64. ------------------
  65. ---TRANSACTION 3758660, ACTIVE 36 sec starting index read
  66. mysql tables in use 1, locked 1
  67. LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
  68. MySQL thread id 290, OS thread handle 0x7f496a13a700, query id 31390 localhost uletpro updating
  69. UPDATE dl_commerce_ks2_history SET timestamp='1466025318'
  70. WHERE ( (uid = '1') AND (nid = '54') )
  71. Trx #rec lock waits 1 #table lock waits 0
  72. Trx total rec lock wait time 0 SEC
  73. Trx total table lock wait time 0 SEC
  74. ------- TRX HAS BEEN WAITING 36 SEC FOR THIS LOCK TO BE GRANTED:
  75. RECORD LOCKS space id 2751 page no 3 n bits 352 index "PRIMARY" of table "ulet7pro"."dl_commerce_ks2_history" trx table locks 1 total table locks 2  trx id 3758660 lock_mode X locks rec but not gap waiting lock hold time 36 wait time before grant 0
  76. ------------------
  77. ---TRANSACTION 3758638, ACTIVE 42 sec fetching rows
  78. mysql tables in use 1, locked 1
  79. LOCK WAIT 12 lock struct(s), heap size 2936, 24 row lock(s), undo log entries 36
  80. MySQL thread id 287, OS thread handle 0x7f49675c2700, query id 22498 localhost uletpro updating
  81. DELETE FROM dl_commerce_ks2_semaphore
  82. WHERE  (value = '836222875761c55fc29d35.43314915')
  83. Trx read view will not see trx with id >= 3758639, sees < 3758562
  84. Trx #rec lock waits 1 #table lock waits 0
  85. Trx total rec lock wait time 0 SEC
  86. Trx total table lock wait time 0 SEC
  87. ------- TRX HAS BEEN WAITING 42 SEC FOR THIS LOCK TO BE GRANTED:
  88. RECORD LOCKS space id 2752 page no 3 n bits 104 index "PRIMARY" of table "ulet7pro"."dl_commerce_ks2_semaphore" trx table locks 4 total table locks 3  trx id 3758638 lock_mode X waiting lock hold time 42 wait time before grant 0
  89. ------------------
  90. ---TRANSACTION 3758562, ACTIVE 52 sec
  91. 146 lock struct(s), heap size 30248, 4158 row lock(s), undo log entries 40262
  92. MySQL thread id 279, OS thread handle 0x7f496a19c700, query id 83164 localhost uletpro cleaning up
  93. Trx read view will not see trx with id >= 3758563, sees < 3758532
  94. Trx #rec lock waits 0 #table lock waits 0
  95. Trx total rec lock wait time 0 SEC
  96. Trx total table lock wait time 0 SEC
  97. --------
  98. FILE I/O
  99. --------
  100. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  101. I/O thread 1 state: complete io for log (log thread)
  102. I/O thread 2 state: waiting for completed aio requests (read thread)
  103. I/O thread 3 state: waiting for completed aio requests (read thread)
  104. I/O thread 4 state: waiting for completed aio requests (read thread)
  105. I/O thread 5 state: waiting for completed aio requests (read thread)
  106. I/O thread 6 state: waiting for completed aio requests (write thread)
  107. I/O thread 7 state: waiting for completed aio requests (write thread)
  108. I/O thread 8 state: complete io for buf page (write thread)
  109. I/O thread 9 state: waiting for completed aio requests (write thread)
  110. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  111. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  112. Pending flushes (fsync) log: 1; buffer pool: 1
  113. 2371 OS file reads, 2448 OS file writes, 649 OS fsyncs
  114. 0.13 reads/s, 16384 avg bytes/read, 2.84 writes/s, 1.68 fsyncs/s
  115. -------------------------------------
  116. INSERT BUFFER AND ADAPTIVE HASH INDEX
  117. -------------------------------------
  118. Ibuf: size 1, free list len 98, seg size 100, 64 merges
  119. merged operations:
  120. insert 329, delete mark 2535, delete 1
  121. discarded operations:
  122. insert 0, delete mark 0, delete 0
  123. 2817.62 hash searches/s, 1709.30 non-hash searches/s
  124. ---
  125. LOG
  126. ---
  127. Log sequence number 5659004955
  128. Log flushed up to   5658859903
  129. Pages flushed up to 5646062688
  130. Last checkpoint at  5646048241
  131. Max checkpoint age    434154333
  132. Checkpoint age target 420587011
  133. Modified age          12942267
  134. Checkpoint age        12956714
  135. 0 pending log writes, 1 pending chkp writes
  136. 712 log i/o's done, 1.65 log i/o's/second
  137. ----------------------
  138. BUFFER POOL AND MEMORY
  139. ----------------------
  140. Total memory allocated 1373634560; in additional pool allocated 0
  141. Total memory allocated by read views 1248
  142. Internal hash tables (constant factor + variable factor)
  143.    Adaptive hash index 22319248        (21250088 + 1069160)
  144.    Page hash           664936 (buffer pool 0 only)
  145.    Dictionary cache    6742113         (5314352 + 1427761)
  146.    File system         1083592         (812272 + 271320)
  147.    Lock system         3357192         (3321128 + 36064)
  148.    Recovery system     0       (0 + 0)
  149. Dictionary memory allocated 1427761
  150. Buffer pool size        81918
  151. Buffer pool size, bytes 1342144512
  152. Free buffers            79026
  153. Database pages          2826
  154. Old database pages      1003
  155. Modified db pages       999
  156. Percent of dirty pages(LRU & free pages): 1.220
  157. Max dirty pages percent: 75.000
  158. Pending reads 0
  159. Pending writes: LRU 0, flush list 2, single page 0
  160. Pages made young 1, not young 0
  161. 0.03 youngs/s, 0.00 non-youngs/s
  162. Pages read 2208, created 618, written 1640
  163. 0.13 reads/s, 8.97 creates/s, 0.84 writes/s
  164. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  165. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  166. LRU len: 2826, unzip_LRU len: 0
  167. I/O sum[0]:cur[4], unzip sum[0]:cur[0]
  168. ----------------------
  169. INDIVIDUAL BUFFER POOL INFO
  170. ----------------------
  171. ---BUFFER POOL 0
  172. Buffer pool size        40959
  173. Buffer pool size, bytes 671072256
  174. Free buffers            39575
  175. Database pages          1351
  176. Old database pages      478
  177. Modified db pages       536
  178. Percent of dirty pages(LRU & free pages): 1.310
  179. Max dirty pages percent: 75.000
  180. Pending reads 0
  181. Pending writes: LRU 0, flush list 0, single page 0
  182. Pages made young 1, not young 0
  183. 0.03 youngs/s, 0.00 non-youngs/s
  184. Pages read 1035, created 316, written 970
  185. 0.03 reads/s, 4.39 creates/s, 0.39 writes/s
  186. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  187. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  188. LRU len: 1351, unzip_LRU len: 0
  189. I/O sum[0]:cur[2], unzip sum[0]:cur[0]
  190. ---BUFFER POOL 1
  191. Buffer pool size        40959
  192. Buffer pool size, bytes 671072256
  193. Free buffers            39451
  194. Database pages          1475
  195. Old database pages      525
  196. Modified db pages       463
  197. Percent of dirty pages(LRU & free pages): 1.131
  198. Max dirty pages percent: 75.000
  199. Pending reads 0
  200. Pending writes: LRU 0, flush list 2, single page 0
  201. Pages made young 0, not young 0
  202. 0.00 youngs/s, 0.00 non-youngs/s
  203. Pages read 1173, created 302, written 670
  204. 0.10 reads/s, 4.58 creates/s, 0.45 writes/s
  205. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  206. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  207. LRU len: 1475, unzip_LRU len: 0
  208. I/O sum[0]:cur[2], unzip sum[0]:cur[0]
  209. --------------
  210. ROW OPERATIONS
  211. --------------
  212. 0 queries inside InnoDB, 0 queries in queue
  213. 2 read views open inside InnoDB
  214. 4 RW transactions active inside InnoDB
  215. 0 RO transactions active inside InnoDB
  216. 4 out of 1000 descriptors used
  217. ---OLDEST VIEW---
  218. Normal read view
  219. Read view low limit trx n:o 3758563
  220. Read view up limit trx id 3758532
  221. Read view low limit trx id 3758563
  222. Read view individually stored trx ids:
  223. Read view trx id 3758532
  224. -----------------
  225. Main thread process no. 5625, id 139951417046784, state: sleeping
  226. Number of rows inserted 8309, updated 24378, deleted 8244, read 385399
  227. 130.77 inserts/s, 479.92 updates/s, 130.45 deletes/s, 2652.95 reads/s
  228. Number of system rows inserted 0, updated 0, deleted 0, read 0
  229. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  230. ----------------------------
  231. END OF INNODB MONITOR OUTPUT
  232. ============================
  233.  
  234. 1 row in set (0.22 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!