Pastebin is 300% more awesome when you are logged in. Sign Up, it's FREE!
Guest

SHOW ENGINE INNODB STATUS

By: a guest on Oct 23rd, 2011  |  syntax: None  |  size: 10.62 KB  |  hits: 107  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. =====================================
  2. 111023 23:37:58 INNODB MONITOR OUTPUT
  3. =====================================
  4. Per second averages calculated from the last 15 seconds
  5. ----------
  6. SEMAPHORES
  7. ----------
  8. OS WAIT ARRAY INFO: reservation count 5255, signal count 4845
  9. Mutex spin waits 0, rounds 362238, OS waits 1191
  10. RW-shared spins 7797, OS waits 3759; RW-excl spins 178, OS waits 47
  11. ------------
  12. TRANSACTIONS
  13. ------------
  14. Trx id counter 0 1595880532
  15. Purge done for trx's n:o < 0 1595879650 undo n:o < 0 0
  16. History list length 30
  17. Total number of lock structs in row lock hash table 0
  18. LIST OF TRANSACTIONS FOR EACH SESSION:
  19. ---TRANSACTION 0 0, not started, process no 19333, OS thread id 565387
  20. MySQL thread id 1918, query id 7654430 localhost root
  21. SHOW ENGINE INNODB STATUS
  22. ---TRANSACTION 0 1595880531, not started, process no 19374, OS thread id 733364
  23. MySQL thread id 741, query id 7654401 72.232.195.234 supreme
  24. ---TRANSACTION 0 1595833332, not started, process no 19261, OS thread id 270403
  25. MySQL thread id 57, query id 7653444 72.232.228.242 of
  26. ---TRANSACTION 0 1595767986, not started, process no 19258, OS thread id 258112
  27. MySQL thread id 54, query id 7654402 72.232.228.242 of
  28. ---TRANSACTION 0 1595847080, not started, process no 19255, OS thread id 245821
  29. MySQL thread id 51, query id 7654382 72.232.228.242 of
  30. ---TRANSACTION 0 1595866800, not started, process no 19257, OS thread id 254015
  31. MySQL thread id 53, query id 7654402 72.232.228.242 of
  32. ---TRANSACTION 0 1595826151, not started, process no 19263, OS thread id 278597
  33. MySQL thread id 59, query id 7653444 72.232.228.242 of
  34. ---TRANSACTION 0 1595874074, not started, process no 19262, OS thread id 274500
  35. MySQL thread id 58, query id 7653444 72.232.228.242 of
  36. ---TRANSACTION 0 1595874024, not started, process no 19260, OS thread id 266306
  37. MySQL thread id 56, query id 7653443 72.232.228.242 of
  38. ---TRANSACTION 0 1595833610, not started, process no 19259, OS thread id 262209
  39. MySQL thread id 55, query id 7654429 72.232.228.242 of
  40. ---TRANSACTION 0 1595818021, not started, process no 19256, OS thread id 249918
  41. MySQL thread id 52, query id 7654382 72.232.228.242 of
  42. ---TRANSACTION 0 1595880225, not started, process no 19252, OS thread id 233530
  43. MySQL thread id 48, query id 7652986 72.232.195.234 supreme
  44. ---TRANSACTION 0 1595880105, not started, process no 19249, OS thread id 221239
  45. MySQL thread id 45, query id 7652737 72.232.195.234 supreme
  46. ---TRANSACTION 0 1595880344, not started, process no 19250, OS thread id 225336
  47. MySQL thread id 46, query id 7654261 72.232.195.234 supreme
  48. ---TRANSACTION 0 1595880489, not started, process no 19248, OS thread id 217142
  49. MySQL thread id 44, query id 7651303 72.232.195.234 supreme
  50. ---TRANSACTION 0 1595880230, not started, process no 19247, OS thread id 213045
  51. MySQL thread id 43, query id 7653064 72.232.195.234 supreme
  52. ---TRANSACTION 0 1595880215, not started, process no 19246, OS thread id 208948
  53. MySQL thread id 42, query id 7652980 72.232.195.234 supreme
  54. ---TRANSACTION 0 1595880360, not started, process no 19254, OS thread id 241724
  55. MySQL thread id 50, query id 7653030 72.232.195.234 supreme
  56. ---TRANSACTION 0 1595880356, not started, process no 19245, OS thread id 204851
  57. MySQL thread id 41, query id 7651894 72.232.195.234 supreme
  58. ---TRANSACTION 0 1595880270, not started, process no 19253, OS thread id 237627
  59. MySQL thread id 49, query id 7653644 72.232.195.234 supreme
  60. ---TRANSACTION 0 1595880260, not started, process no 19251, OS thread id 229433
  61. MySQL thread id 47, query id 7652972 72.232.195.234 supreme
  62. ---TRANSACTION 0 1595880403, not started, process no 19243, OS thread id 200754
  63. MySQL thread id 40, query id 7652919 72.232.195.234 supreme
  64. ---TRANSACTION 0 1595880372, not started, process no 19242, OS thread id 196657
  65. MySQL thread id 39, query id 7653977 72.232.195.234 supreme
  66. ---TRANSACTION 0 1595880379, not started, process no 19241, OS thread id 192560
  67. MySQL thread id 38, query id 7654349 72.232.195.234 supreme
  68. ---TRANSACTION 0 1595880377, not started, process no 19224, OS thread id 122911
  69. MySQL thread id 21, query id 7654305 72.232.195.234 supreme
  70. ---TRANSACTION 0 1595880527, not started, process no 19239, OS thread id 184366
  71. MySQL thread id 36, query id 7653951 72.232.195.234 supreme
  72. ---TRANSACTION 0 1595879963, not started, process no 19240, OS thread id 188463
  73. MySQL thread id 37, query id 7652948 72.232.195.234 supreme
  74. ---TRANSACTION 0 1595880125, not started, process no 19222, OS thread id 114717
  75. MySQL thread id 19, query id 7653151 72.232.195.234 supreme
  76. ---TRANSACTION 0 1595880473, not started, process no 19238, OS thread id 180269
  77. MySQL thread id 35, query id 7653361 72.232.195.234 supreme
  78. ---TRANSACTION 0 1595879454, not started, process no 19228, OS thread id 139299
  79. MySQL thread id 25, query id 7653146 72.232.195.234 supreme
  80. ---TRANSACTION 0 1595880452, not started, process no 19223, OS thread id 118814
  81. MySQL thread id 20, query id 7652756 72.232.195.234 supreme
  82. ---TRANSACTION 0 1595880264, not started, process no 19225, OS thread id 127008
  83. MySQL thread id 22, query id 7653058 72.232.195.234 supreme
  84. ---TRANSACTION 0 1595880158, not started, process no 19208, OS thread id 57359
  85. MySQL thread id 5, query id 7652914 72.232.195.234 supreme
  86. ---TRANSACTION 0 1595880249, not started, process no 19236, OS thread id 172075
  87. MySQL thread id 33, query id 7654361 72.232.195.234 supreme
  88. ---TRANSACTION 0 1595880223, not started, process no 19206, OS thread id 49165
  89. MySQL thread id 3, query id 7649726 72.232.195.234 supreme
  90. ---TRANSACTION 0 1595880188, not started, process no 19231, OS thread id 151590
  91. MySQL thread id 28, query id 7652658 72.232.195.234 supreme
  92. ---TRANSACTION 0 1595880509, not started, process no 19214, OS thread id 81941
  93. MySQL thread id 11, query id 7653520 72.232.195.234 supreme
  94. ---TRANSACTION 0 1595880434, not started, process no 19234, OS thread id 163881
  95. MySQL thread id 31, query id 7652691 72.232.195.234 supreme
  96. ---TRANSACTION 0 1595880501, not started, process no 19216, OS thread id 90135
  97. MySQL thread id 13, query id 7652875 72.232.195.234 supreme
  98. ---TRANSACTION 0 1595880183, not started, process no 19217, OS thread id 94232
  99. MySQL thread id 14, query id 7654416 72.232.195.234 supreme
  100. ---TRANSACTION 0 1595880140, not started, process no 19218, OS thread id 98329
  101. MySQL thread id 15, query id 7653639 72.232.195.234 supreme
  102. ---TRANSACTION 0 1595880254, not started, process no 19212, OS thread id 73747
  103. MySQL thread id 9, query id 7651272 72.232.195.234 supreme
  104. ---TRANSACTION 0 1595880428, not started, process no 19237, OS thread id 176172
  105. MySQL thread id 34, query id 7654400 72.232.195.234 supreme
  106. ---TRANSACTION 0 1595879804, not started, process no 19235, OS thread id 167978
  107. MySQL thread id 32, query id 7651736 72.232.195.234 supreme
  108. ---TRANSACTION 0 1595879999, not started, process no 19210, OS thread id 65553
  109. MySQL thread id 7, query id 7653559 72.232.195.234 supreme
  110. ---TRANSACTION 0 1595880485, not started, process no 19220, OS thread id 106523
  111. MySQL thread id 17, query id 7654429 72.232.195.234 supreme
  112. ---TRANSACTION 0 1595880496, not started, process no 19211, OS thread id 69650
  113. MySQL thread id 8, query id 7652752 72.232.195.234 supreme
  114. ---TRANSACTION 0 1595880178, not started, process no 19233, OS thread id 159784
  115. MySQL thread id 30, query id 7653938 72.232.195.234 supreme
  116. ---TRANSACTION 0 1595880267, not started, process no 19213, OS thread id 77844
  117. MySQL thread id 10, query id 7653495 72.232.195.234 supreme
  118. ---TRANSACTION 0 1595880227, not started, process no 19227, OS thread id 135202
  119. MySQL thread id 24, query id 7653095 72.232.195.234 supreme
  120. ---TRANSACTION 0 1595880056, not started, process no 19219, OS thread id 102426
  121. MySQL thread id 16, query id 7653113 72.232.195.234 supreme
  122. ---TRANSACTION 0 1595880321, not started, process no 19215, OS thread id 86038
  123. MySQL thread id 12, query id 7652844 72.232.195.234 supreme
  124. ---TRANSACTION 0 1595880470, not started, process no 19209, OS thread id 61456
  125. MySQL thread id 6, query id 7653246 72.232.195.234 supreme
  126. ---TRANSACTION 0 1595880015, not started, process no 19205, OS thread id 45068
  127. MySQL thread id 2, query id 7654223 72.232.195.234 supreme
  128. ---TRANSACTION 0 1595880326, not started, process no 19221, OS thread id 110620
  129. MySQL thread id 18, query id 7651810 72.232.195.234 supreme
  130. ---TRANSACTION 0 1595880437, not started, process no 19232, OS thread id 155687
  131. MySQL thread id 29, query id 7651667 72.232.195.234 supreme
  132. ---TRANSACTION 0 1595880511, not started, process no 19226, OS thread id 131105
  133. MySQL thread id 23, query id 7653649 72.232.195.234 supreme
  134. ---TRANSACTION 0 1595880337, not started, process no 19230, OS thread id 147493
  135. MySQL thread id 27, query id 7654005 72.232.195.234 supreme
  136. ---TRANSACTION 0 1595880516, not started, process no 19204, OS thread id 40971
  137. MySQL thread id 1, query id 7652760 72.232.195.234 supreme
  138. --------
  139. FILE I/O
  140. --------
  141. I/O thread 0 state: waiting for i/o request (insert buffer thread)
  142. I/O thread 1 state: waiting for i/o request (log thread)
  143. I/O thread 2 state: waiting for i/o request (read thread)
  144. I/O thread 3 state: waiting for i/o request (write thread)
  145. Pending normal aio reads: 0, aio writes: 0,
  146.  ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  147. Pending flushes (fsync) log: 0; buffer pool: 0
  148. 3130 OS file reads, 62457 OS file writes, 38371 OS fsyncs
  149. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  150. -------------------------------------
  151. INSERT BUFFER AND ADAPTIVE HASH INDEX
  152. -------------------------------------
  153. Ibuf: size 1, free list len 5, seg size 7,
  154. 16 inserts, 16 merged recs, 9 merges
  155. Hash table size 1106407, used cells 247138, node heap has 275 buffer(s)
  156. 0.00 hash searches/s, 0.00 non-hash searches/s
  157. ---
  158. LOG
  159. ---
  160. Log sequence number 2 278129312
  161. Log flushed up to   2 278129312
  162. Last checkpoint at  2 278129312
  163. 0 pending log writes, 0 pending chkp writes
  164. 26646 log i/o's done, 0.00 log i/o's/second
  165. ----------------------
  166. BUFFER POOL AND MEMORY
  167. ----------------------
  168. Total memory allocated 313289658; in additional pool allocated 5353984
  169. Buffer pool size   16384
  170. Free buffers       4711
  171. Database pages     11398
  172. Modified db pages  0
  173. Pending reads 0
  174. Pending writes: LRU 0, flush list 0, single page 0
  175. Pages read 5993, created 5405, written 66972
  176. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  177. Buffer pool hit rate 1000 / 1000
  178. --------------
  179. ROW OPERATIONS
  180. --------------
  181. 0 queries inside InnoDB, 0 queries in queue
  182. 1 read views open inside InnoDB
  183. Main thread process no. 19202, id 32777, state: sleeping
  184. Number of rows inserted 554047, updated 9445, deleted 5277, read 1310769557
  185. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  186. ----------------------------
  187. END OF INNODB MONITOR OUTPUT
  188. ============================
  189.