API tools faq
paste
Advertisement
Guest User

innodb status

a guest
Dec 17th, 2012
248
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.82 KB | None | 0 0
raw download clone embed print report
  1. | InnoDB | |
  2. =====================================
  3. 121216 20:22:24 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 21 seconds
  6. ----------
  7. SEMAPHORES
  8. ----------
  9. OS WAIT ARRAY INFO: reservation count 85803, signal count 80866
  10. Mutex spin waits 0, rounds 2139716, OS waits 39508
  11. RW-shared spins 49212, OS waits 23137; RW-excl spins 55770, OS waits 16604
  12. ------------
  13. TRANSACTIONS
  14. ------------
  15. Trx id counter 0 1269637851
  16. Purge done for trx's n:o < 0 1269637543 undo n:o < 0 0
  17. History list length 98
  18. LIST OF TRANSACTIONS FOR EACH SESSION:
  19. ---TRANSACTION 0 1269637764, not started, process no 32716, OS thread id 140692651054848
  20. MySQL thread id 455514, query id 10724306 ***.***.*** root
  21. ---TRANSACTION 0 1269637755, not started, process no 32716, OS thread id 140692709361408
  22. MySQL thread id 455513, query id 10724294 ***.***.*** root
  23. ---TRANSACTION 0 1269637747, not started, process no 32716, OS thread id 140692682204928
  24. MySQL thread id 455512, query id 10724283 ***.***.*** root
  25. ---TRANSACTION 0 1269637665, not started, process no 32716, OS thread id 140692645730048
  26. MySQL thread id 455511, query id 10724275 ***.***.*** root
  27. ---TRANSACTION 0 1269637806, not started, process no 32716, OS thread id 140692729063168
  28. MySQL thread id 455510, query id 10724375 ***.***.*** root
  29. ---TRANSACTION 0 1269637633, not started, process no 32716, OS thread id 140692631086848
  30. MySQL thread id 455509, query id 10724089 ***.***.*** root
  31. ---TRANSACTION 0 1269637608, not started, process no 32716, OS thread id 140692686464768
  32. MySQL thread id 455508, query id 10724061 ***.***.*** root
  33. ---TRANSACTION 0 1269637576, not started, process no 32716, OS thread id 140692716017408
  34. MySQL thread id 455507, query id 10724011 ***.***.*** root
  35. ---TRANSACTION 0 1269637569, not started, process no 32716, OS thread id 140692642535168
  36. MySQL thread id 455506, query id 10724005 ***.***.*** root
  37. ---TRANSACTION 0 1269637544, not started, process no 32716, OS thread id 140692698179328
  38. MySQL thread id 455505, query id 10723966 ***.***.*** root
  39. ---TRANSACTION 0 1269637688, not started, process no 32716, OS thread id 140692732790528
  40. MySQL thread id 455504, query id 10724175 ***.***.*** root
  41. ---TRANSACTION 0 1269637495, not started, process no 32716, OS thread id 140692704302848
  42. MySQL thread id 455503, query id 10723911 ***.***.*** root
  43. ---TRANSACTION 0 1269637550, not started, process no 32716, OS thread id 140692633216768
  44. MySQL thread id 455502, query id 10723978 ***.***.*** root
  45. ---TRANSACTION 0 1269637432, not started, process no 32716, OS thread id 140692677412608
  46. MySQL thread id 455501, query id 10723832 ***.***.*** root
  47. ---TRANSACTION 0 1269637577, not started, process no 32716, OS thread id 140692635346688
  48. MySQL thread id 455500, query id 10724022 ***.***.*** root
  49. ---TRANSACTION 0 1269637802, not started, process no 32716, OS thread id 140692690990848
  50. MySQL thread id 455499, query id 10724367 ***.***.*** root
  51. ---TRANSACTION 0 1269637117, not started, process no 32716, OS thread id 140692653184768
  52. MySQL thread id 455498, query id 10723379 ***.***.*** root
  53. ---TRANSACTION 0 1269636912, not started, process no 32716, OS thread id 140692704569088
  54. MySQL thread id 455497, query id 10723090 ***.***.*** root
  55. ---TRANSACTION 0 1269637139, not started, process no 32716, OS thread id 140692705367808
  56. MySQL thread id 455475, query id 10723428 ***.***.*** root
  57. ---TRANSACTION 0 0, not started, process no 32716, OS thread id 140692666496768
  58. MySQL thread id 455397, query id 10724433 localhost root
  59. show engine innodb status
  60. ---TRANSACTION 0 1269266844, not started, process no 32716, OS thread id 140692718413568
  61. MySQL thread id 446111, query id 10241062 ***.***.***.***6 rem
  62. ---TRANSACTION 0 1269637744, not started, process no 32716, OS thread id 140692722673408
  63. MySQL thread id 441383, query id 10724280 ***.***.***.*** root
  64. ---TRANSACTION 0 1269637687, not started, process no 32716, OS thread id 140692694718208
  65. MySQL thread id 441421, query id 10724341 ***.***.***.*** root
  66. ---TRANSACTION 0 1269637735, not started, process no 32716, OS thread id 140692733323008
  67. MySQL thread id 441420, query id 10724267 ***.***.***.*** root
  68. ---TRANSACTION 0 1269637748, not started, process no 32716, OS thread id 140692631885568
  69. MySQL thread id 441419, query id 10724287 ***.***.***.*** root
  70. ---TRANSACTION 0 1269637838, not started, process no 32716, OS thread id 140692676081408
  71. MySQL thread id 441418, query id 10724416 ***.***.***.*** root
  72. ---TRANSACTION 0 1269637801, not started, process no 32716, OS thread id 140692728530688
  73. MySQL thread id 441417, query id 10724365 ***.***.***.*** root
  74. ---TRANSACTION 0 1269637763, not started, process no 32716, OS thread id 140692713088768
  75. MySQL thread id 441416, query id 10724305 ***.***.***.*** root
  76. ---TRANSACTION 0 1269637774, not started, process no 32716, OS thread id 140692674750208
  77. MySQL thread id 441415, query id 10724324 ***.***.***.*** root
  78. ---TRANSACTION 0 1269637822, not started, process no 32716, OS thread id 140692708562688
  79. MySQL thread id 441414, query id 10724395 ***.***.***.*** root
  80. ---TRANSACTION 0 1269637779, not started, process no 32716, OS thread id 140692706965248
  81. MySQL thread id 441413, query id 10724334 ***.***.***.*** root
  82. ---TRANSACTION 0 1269637849, not started, process no 32716, OS thread id 140692701107968
  83. MySQL thread id 441408, query id 10724432 ***.***.***.*** root
  84. ---TRANSACTION 0 1269637799, not started, process no 32716, OS thread id 140692737582848
  85. MySQL thread id 441406, query id 10724363 ***.***.***.*** root
  86. ---TRANSACTION 0 1269637771, not started, process no 32716, OS thread id 140692717082368
  87. MySQL thread id 441401, query id 10724318 ***.***.***.*** root
  88. ---TRANSACTION 0 1269637830, not started, process no 32716, OS thread id 140692647327488
  89. MySQL thread id 441400, query id 10724406 ***.***.***.*** root
  90. ---TRANSACTION 0 1269637717, not started, process no 32716, OS thread id 140692697913088
  91. MySQL thread id 441399, query id 10724396 ***.***.***.*** root
  92. ---TRANSACTION 0 1269637825, not started, process no 32716, OS thread id 140707488118528
  93. MySQL thread id 441398, query id 10724400 ***.***.***.*** root
  94. ---TRANSACTION 0 1269637794, not started, process no 32716, OS thread id 140692628956928
  95. MySQL thread id 441395, query id 10724356 ***.***.***.*** root
  96. ---TRANSACTION 0 1269637773, not started, process no 32716, OS thread id 140692708296448
  97. MySQL thread id 441394, query id 10724322 ***.***.***.*** root
  98. ---TRANSACTION 0 1269637827, not started, process no 32716, OS thread id 140692683269888
  99. MySQL thread id 441393, query id 10724402 ***.***.***.*** root
  100. ---TRANSACTION 0 1269637820, not started, process no 32716, OS thread id 140692672087808
  101. MySQL thread id 441392, query id 10724391 ***.***.***.*** root
  102. ---TRANSACTION 0 1269637745, not started, process no 32716, OS thread id 140692696315648
  103. MySQL thread id 441390, query id 10724282 ***.***.***.*** root
  104. ---TRANSACTION 0 1269637839, not started, process no 32716, OS thread id 140692708828928
  105. MySQL thread id 441389, query id 10724419 ***.***.***.*** root
  106. ---TRANSACTION 0 1269637738, not started, process no 32716, OS thread id 140692660905728
  107. MySQL thread id 441388, query id 10724271 ***.***.***.*** root
  108. ---TRANSACTION 0 1269637781, not started, process no 32716, OS thread id 140692646262528
  109. MySQL thread id 441387, query id 10724336 ***.***.***.*** root
  110. ---TRANSACTION 0 1269637756, not started, process no 32716, OS thread id 140692726400768
  111. MySQL thread id 441382, query id 10724296 ***.***.***.*** root
  112. ---TRANSACTION 0 1269637768, not started, process no 32716, OS thread id 140692674217728
  113. MySQL thread id 441381, query id 10724314 ***.***.***.*** root
  114. ---TRANSACTION 0 1269637749, not started, process no 32716, OS thread id 140692689925888
  115. MySQL thread id 441380, query id 10724286 ***.***.***.*** root
  116. ---TRANSACTION 0 1269637847, not started, process no 32716, OS thread id 140692655314688
  117. MySQL thread id 441372, query id 10724430 ***.***.***.*** root
  118. ---TRANSACTION 0 1269637811, not started, process no 32716, OS thread id 140692634814208
  119. MySQL thread id 441371, query id 10724381 ***.***.***.*** root
  120. ---TRANSACTION 0 1269637804, not started, process no 32716, OS thread id 140692732258048
  121. MySQL thread id 441370, query id 10724372 ***.***.***.*** root
  122. ---TRANSACTION 0 1269637814, not started, process no 32716, OS thread id 140692675548928
  123. MySQL thread id 441369, query id 10724385 ***.***.***.*** root
  124. ---TRANSACTION 0 1269637758, not started, process no 32716, OS thread id 140692665165568
  125. MySQL thread id 441368, query id 10724298 ***.***.***.*** root
  126. ---TRANSACTION 0 1269637776, not started, process no 32716, OS thread id 140692717881088
  127. MySQL thread id 441354, query id 10724328 ***.***.***.*** root
  128. ---TRANSACTION 0 1269637837, not started, process no 32716, OS thread id 140692632684288
  129. MySQL thread id 441353, query id 10724414 ***.***.***.*** root
  130. ---TRANSACTION 0 1269637737, not started, process no 32716, OS thread id 140692641736448
  131. MySQL thread id 441352, query id 10724269 ***.***.***.*** root
  132. ---TRANSACTION 0 1269637816, not started, process no 32716, OS thread id 140692723205888
  133. MySQL thread id 441351, query id 10724387 ***.***.***.*** root
  134. ---TRANSACTION 0 1269637700, not started, process no 32716, OS thread id 140692681406208
  135. MySQL thread id 441350, query id 10724366 ***.***.***.*** root
  136. ---TRANSACTION 0 1269637775, not started, process no 32716, OS thread id 140692715218688
  137. MySQL thread id 441349, query id 10724326 ***.***.***.*** root
  138. ---TRANSACTION 0 1269637818, not started, process no 32716, OS thread id 140692726134528
  139. MySQL thread id 441272, query id 10724389 ***.***.***.*** root
  140. ---TRANSACTION 0 1269637824, not started, process no 32716, OS thread id 140692629223168
  141. MySQL thread id 441270, query id 10724398 ***.***.***.*** root
  142. ---TRANSACTION 0 1269637734, not started, process no 32716, OS thread id 140692732524288
  143. MySQL thread id 441267, query id 10724265 ***.***.***.*** root
  144. ---TRANSACTION 0 1269637788, not started, process no 32716, OS thread id 140692653983488
  145. MySQL thread id 441266, query id 10724348 ***.***.***.*** root
  146. ---TRANSACTION 0 1269637834, not started, process no 32716, OS thread id 140692727465728
  147. MySQL thread id 441265, query id 10724410 ***.***.***.*** root
  148. ---TRANSACTION 0 1269637778, not started, process no 32716, OS thread id 140692656645888
  149. MySQL thread id 441262, query id 10724332 ***.***.***.*** root
  150. ---TRANSACTION 0 1269637740, not started, process no 32716, OS thread id 140692636411648
  151. MySQL thread id 441251, query id 10724274 ***.***.***.*** root
  152. ---TRANSACTION 0 1269637760, not started, process no 32716, OS thread id 140692697646848
  153. MySQL thread id 441249, query id 10724301 ***.***.***.*** root
  154. ---TRANSACTION 0 1269637762, not started, process no 32716, OS thread id 140692734920448
  155. MySQL thread id 441248, query id 10724303 ***.***.***.*** root
  156. ---TRANSACTION 0 1269637797, not started, process no 32716, OS thread id 140692652119808
  157. MySQL thread id 441247, query id 10724360 ***.***.***.*** root
  158. ---TRANSACTION 0 1269637772, not started, process no 32716, OS thread id 140692721342208
  159. MySQL thread id 441246, query id 10724320 ***.***.***.*** root
  160. ---TRANSACTION 0 1269637813, not started, process no 32716, OS thread id 140692709095168
  161. MySQL thread id 441245, query id 10724384 ***.***.***.*** root
  162. ---TRANSACTION 0 1269637766, not started, process no 32716, OS thread id 140692677146368
  163. MySQL thread id 441244, query id 10724310 ***.***.***.*** root
  164. ---TRANSACTION 0 1269637782, not started, process no 32716, OS thread id 140692675282688
  165. MySQL thread id 441242, query id 10724338 ***.***.***.*** root
  166. ---TRANSACTION 0 1269637841, not started, process no 32716, OS thread id 140692710160128
  167. MySQL thread id 441241, query id 10724422 ***.***.***.*** root
  168. ---TRANSACTION 0 1269637836, not started, process no 32716, OS thread id 140692693919488
  169. MySQL thread id 441240, query id 10724412 ***.***.***.*** root
  170. ---TRANSACTION 0 1269637843, not started, process no 32716, OS thread id 140692689127168
  171. MySQL thread id 441239, query id 10724426 ***.***.***.*** root
  172. ---TRANSACTION 0 1269637752, not started, process no 32716, OS thread id 140692709893888
  173. MySQL thread id 441101, query id 10724291 ***.***.***.*** root
  174. ---TRANSACTION 0 1269637840, not started, process no 32716, OS thread id 140692697114368
  175. MySQL thread id 441089, query id 10724420 ***.***.***.*** root
  176. ---TRANSACTION 0 1269637767, not started, process no 32716, OS thread id 140692693387008
  177. MySQL thread id 441088, query id 10724312 ***.***.***.*** root
  178. ---TRANSACTION 0 1269637790, not started, process no 32716, OS thread id 140692728796928
  179. MySQL thread id 441087, query id 10724350 ***.***.***.*** root
  180. ---TRANSACTION 0 1269637792, not started, process no 32716, OS thread id 140692636145408
  181. MySQL thread id 441086, query id 10724352 ***.***.***.*** root
  182. ---TRANSACTION 0 1269637798, not started, process no 32716, OS thread id 140692671821568
  183. MySQL thread id 441085, query id 10724361 ***.***.***.*** root
  184. ---TRANSACTION 0 1269637795, not started, process no 32716, OS thread id 140692637476608
  185. MySQL thread id 441084, query id 10724357 ***.***.***.*** root
  186. ---TRANSACTION 0 1269637803, not started, process no 32716, OS thread id 140692647593728
  187. MySQL thread id 441083, query id 10724369 ***.***.***.*** root
  188. ---TRANSACTION 0 1269637754, not started, process no 32716, OS thread id 140692738381568
  189. MySQL thread id 441082, query id 10724293 ***.***.***.*** root
  190. ---TRANSACTION 0 1269637807, not started, process no 32716, OS thread id 140692660639488
  191. MySQL thread id 441079, query id 10724377 ***.***.***.*** root
  192. ---TRANSACTION 0 1269637777, not started, process no 32716, OS thread id 140692675815168
  193. MySQL thread id 441077, query id 10724330 ***.***.***.*** root
  194. ---TRANSACTION 0 1269637809, not started, process no 32716, OS thread id 140692724270848
  195. MySQL thread id 441075, query id 10724379 ***.***.***.*** root
  196. ---TRANSACTION 0 1269637828, not started, process no 32716, OS thread id 140692647859968
  197. MySQL thread id 441063, query id 10724404 ***.***.***.*** root
  198. ---TRANSACTION 0 1269637769, not started, process no 32716, OS thread id 140692641203968
  199. MySQL thread id 441062, query id 10724316 ***.***.***.*** root
  200. ---TRANSACTION 0 1269637742, not started, process no 32716, OS thread id 140692688860928
  201. MySQL thread id 441060, query id 10724278 ***.***.***.*** root
  202. ---TRANSACTION 0 1269637751, not started, process no 32716, OS thread id 140692700309248
  203. MySQL thread id 441059, query id 10724290 ***.***.***.*** root
  204. ---TRANSACTION 0 1269637765, not started, process no 32716, OS thread id 140692672886528
  205. MySQL thread id 441057, query id 10724308 ***.***.***.*** root
  206. ---TRANSACTION 0 1269637845, not started, process no 32716, OS thread id 140692684068608
  207. MySQL thread id 441056, query id 10724428 ***.***.***.*** root
  208. ---TRANSACTION 0 1269637821, not started, process no 32716, OS thread id 140692686198528
  209. MySQL thread id 441055, query id 10724394 ***.***.***.*** root
  210. ---TRANSACTION 0 1269637832, not started, process no 32716, OS thread id 140692641470208
  211. MySQL thread id 441054, query id 10724408 ***.***.***.*** root
  212. ---TRANSACTION 0 1269637842, not started, process no 32716, OS thread id 140692664366848
  213. MySQL thread id 441030, query id 10724424 ***.***.***.*** root
  214. ---TRANSACTION 0 1269637783, not started, process no 32716, OS thread id 140692711757568
  215. MySQL thread id 441016, query id 10724340 ***.***.***.*** root
  216. ---TRANSACTION 0 1269637786, not started, process no 32716, OS thread id 140692705634048
  217. MySQL thread id 441012, query id 10724345 ***.***.***.*** root
  218. ---TRANSACTION 0 1269637805, not started, process no 32716, OS thread id 140692677945088
  219. MySQL thread id 440994, query id 10724374 ***.***.***.*** root
  220. ---TRANSACTION 0 1269637784, not started, process no 32716, OS thread id 140692631619328
  221. MySQL thread id 440696, query id 10724343 ***.***.***.*** root
  222. ---TRANSACTION 0 1269076065, not started, process no 32716, OS thread id 140692653451008
  223. MySQL thread id 341571, query id 9966620 ***.***.***.*** pro
  224. --------
  225. FILE I/O
  226. --------
  227. I/O thread 0 state: waiting for i/o request (insert buffer thread)
  228. I/O thread 1 state: waiting for i/o request (log thread)
  229. I/O thread 2 state: waiting for i/o request (read thread)
  230. I/O thread 3 state: waiting for i/o request (write thread)
  231. Pending normal aio reads: 0, aio writes: 0,
  232. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  233. Pending flushes (fsync) log: 0; buffer pool: 0
  234. 788930 OS file reads, 3671618 OS file writes, 80728 OS fsyncs
  235. 9.29 reads/s, 19744 avg bytes/read, 88.42 writes/s, 1.43 fsyncs/s
  236. -------------------------------------
  237. INSERT BUFFER AND ADAPTIVE HASH INDEX
  238. -------------------------------------
  239. Ibuf: size 1, free list len 454, seg size 456,
  240. 8776 inserts, 8776 merged recs, 7398 merges
  241. Hash table size 27184867, node heap has 110028 buffer(s)
  242. 5725.39 hash searches/s, 819.87 non-hash searches/s
  243. ---
  244. LOG
  245. ---
  246. Log sequence number 683 694603753
  247. Log flushed up to 683 694589934
  248. Last checkpoint at 683 324465560
  249. 0 pending log writes, 0 pending chkp writes
  250. 3460999 log i/o's done, 84.85 log i/o's/second
  251. ----------------------
  252. BUFFER POOL AND MEMORY
  253. ----------------------
  254. Total memory allocated 15104127968; in additional pool allocated 8388608
  255. Dictionary memory allocated 571248
  256. Buffer pool size 838400
  257. Free buffers 0
  258. Database pages 728372
  259. Modified db pages 35717
  260. Pending reads 0
  261. Pending writes: LRU 0, flush list 0, single page 0
  262. Pages read 974709, created 29957, written 398364
  263. 11.19 reads/s, 0.38 creates/s, 7.38 writes/s
  264. Buffer pool hit rate 1000 / 1000
  265. --------------
  266. ROW OPERATIONS
  267. --------------
  268. 0 queries inside InnoDB, 0 queries in queue
  269. 1 read views open inside InnoDB
  270. Main thread process no. 32716, id 140692751636224, state: sleeping
  271. Number of rows inserted 1088632, updated 14401255, deleted 161485, read 308494691
  272. 31.71 inserts/s, 49.33 updates/s, 3.10 deletes/s, 23041.52 reads/s
  273. ----------------------------
  274. END OF INNODB MONITOR OUTPUT
  275. ============================
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!