API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2012
173
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.04 KB | None | 0 0
raw download clone embed print report
  1.  
  2. =====================================
  3. 120302 15:41:57 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 20 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 4203 1_second, 4202 sleeps, 403 10_second, 621 background, 621 flush
  10. srv_master_thread log flush and writes: 4218
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 5857, signal count 37179
  15. Mutex spin waits 628501, rounds 602245, OS waits 4336
  16. RW-shared spins 8866, rounds 61413, OS waits 1211
  17. RW-excl spins 2796, rounds 37391, OS waits 266
  18. Spin rounds per wait: 0.96 mutex, 6.93 RW-shared, 13.37 RW-excl
  19. ------------
  20. TRANSACTIONS
  21. ------------
  22. Trx id counter 205DCB58
  23. Purge done for trx's n:o < 205ACAA2 undo n:o < 0
  24. History list length 1343
  25. LIST OF TRANSACTIONS FOR EACH SESSION:
  26. ---TRANSACTION 0, not started
  27. MySQL thread id 7940, query id 6239811 192.168.6.31 thanhnt
  28. SHOW ENGINE INNODB STATUS
  29. ---TRANSACTION 205DCABB, not started
  30. MySQL thread id 11860, query id 6236232 192.168.6.30 thanhnt
  31. ---TRANSACTION 205DCA78, not started
  32. MySQL thread id 11781, query id 6239005 192.168.3.40 khanhnq
  33. ---TRANSACTION 205DCA2B, not started
  34. MySQL thread id 11722, query id 6231696 192.168.6.31 thanhnt
  35. ---TRANSACTION 205DCAF7, not started
  36. MySQL thread id 11441, query id 6238756 192.168.6.31 thanhnt
  37. ---TRANSACTION 205DCAA9, not started
  38. MySQL thread id 11013, query id 6235204 192.168.6.31 thanhnt
  39. ---TRANSACTION 205DCB00, not started
  40. MySQL thread id 10178, query id 6238801 192.168.6.31 thanhnt
  41. ---TRANSACTION 205DC98C, not started
  42. MySQL thread id 9402, query id 6219896 192.168.6.31 thanhnt
  43. ---TRANSACTION 205DC4D0, not started
  44. MySQL thread id 8846, query id 6204842 192.168.6.31 thanhnt
  45. ---TRANSACTION 205DC9F2, not started
  46. MySQL thread id 8605, query id 6222019 192.168.6.31 thanhnt
  47. ---TRANSACTION 205DCA0C, not started
  48. MySQL thread id 8604, query id 6222263 192.168.6.31 thanhnt
  49. ---TRANSACTION 205DCAD6, not started
  50. MySQL thread id 8174, query id 6237387 192.168.6.31 thanhnt
  51. ---TRANSACTION 205D9A0C, not started
  52. MySQL thread id 7996, query id 5889284 192.168.6.31 thanhnt
  53. ---TRANSACTION 205DCB23, ACTIVE 19 sec
  54. 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
  55. MySQL thread id 11967, query id 6239755 192.168.3.40 khanhnq
  56. Trx read view will not see trx with id >= 205DCB24, sees < 205ABE4D
  57. ---TRANSACTION 205DC465, ACTIVE 471 sec
  58. MySQL thread id 8432, query id 6239035 192.168.3.40 khanhnq
  59. Trx read view will not see trx with id >= 205DC466, sees < 205ABE4D
  60. ---TRANSACTION 205ABE4D, ACTIVE 3139 sec
  61. MySQL thread id 4334, query id 5888642 192.168.6.31 thanhnt
  62. Trx read view will not see trx with id >= 205ABE4E, sees < 2058AE79
  63. --------
  64. FILE I/O
  65. --------
  66. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  67. I/O thread 1 state: waiting for completed aio requests (log thread)
  68. I/O thread 2 state: waiting for completed aio requests (read thread)
  69. I/O thread 3 state: waiting for completed aio requests (read thread)
  70. I/O thread 4 state: waiting for completed aio requests (read thread)
  71. I/O thread 5 state: waiting for completed aio requests (read thread)
  72. I/O thread 6 state: waiting for completed aio requests (write thread)
  73. I/O thread 7 state: waiting for completed aio requests (write thread)
  74. I/O thread 8 state: waiting for completed aio requests (write thread)
  75. I/O thread 9 state: waiting for completed aio requests (write thread)
  76. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  77. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  78. Pending flushes (fsync) log: 0; buffer pool: 0
  79. 61199 OS file reads, 382076 OS file writes, 23192 OS fsyncs
  80. 0.00 reads/s, 0 avg bytes/read, 1.35 writes/s, 1.15 fsyncs/s
  81. -------------------------------------
  82. INSERT BUFFER AND ADAPTIVE HASH INDEX
  83. -------------------------------------
  84. Ibuf: size 1, free list len 15260, seg size 15262, 1127 merges
  85. merged operations:
  86. insert 4346, delete mark 44540, delete 307
  87. discarded operations:
  88. insert 0, delete mark 0, delete 0
  89. Hash table size 42499381, node heap has 6247 buffer(s)
  90. 264.84 hash searches/s, 14.20 non-hash searches/s
  91. ---
  92. LOG
  93. ---
  94. Log sequence number 3269083288255
  95. Log flushed up to 3269083288255
  96. Last checkpoint at 3269083288255
  97. 0 pending log writes, 0 pending chkp writes
  98. 286222 log i/o's done, 0.20 log i/o's/second
  99. ----------------------
  100. BUFFER POOL AND MEMORY
  101. ----------------------
  102. Total memory allocated 21978152960; in additional pool allocated 0
  103. Dictionary memory allocated 1083679
  104. Buffer pool size 1310712
  105. Free buffers 1237916
  106. Database pages 66549
  107. Old database pages 24459
  108. Modified db pages 0
  109. Pending reads 0
  110. Pending writes: LRU 0, flush list 0, single page 0
  111. Pages made young 135, not young 0
  112. 0.00 youngs/s, 0.00 non-youngs/s
  113. Pages read 59365, created 30031, written 87710
  114. 0.05 reads/s, 0.00 creates/s, 0.75 writes/s
  115. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  116. Pages read ahead 0.00/s, evicted without access 0.00/s
  117. LRU len: 66549, unzip_LRU len: 0
  118. I/O sum[47904]:cur[0], unzip sum[0]:cur[0]
  119. ----------------------
  120. INDIVIDUAL BUFFER POOL INFO
  121. ----------------------
  122. ---BUFFER POOL 0
  123. Buffer pool size 163839
  124. Free buffers 153890
  125. Database pages 9162
  126. Old database pages 3383
  127. Modified db pages 0
  128. Pending reads 0
  129. Pending writes: LRU 0, flush list 0, single page 0
  130. Pages made young 11, not young 0
  131. 0.00 youngs/s, 0.00 non-youngs/s
  132. Pages read 7568, created 4152, written 10809
  133. 0.00 reads/s, 0.00 creates/s, 0.25 writes/s
  134. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  135. Pages read ahead 0.00/s, evicted without access 0.00/s
  136. LRU len: 9162, unzip_LRU len: 0
  137. I/O sum[5988]:cur[0], unzip sum[0]:cur[0]
  138. ---BUFFER POOL 1
  139. Buffer pool size 163839
  140. Free buffers 154554
  141. Database pages 8500
  142. Old database pages 3131
  143. Modified db pages 0
  144. Pending reads 0
  145. Pending writes: LRU 0, flush list 0, single page 0
  146. Pages made young 49, not young 0
  147. 0.00 youngs/s, 0.00 non-youngs/s
  148. Pages read 7800, created 3687, written 14654
  149. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  150. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  151. Pages read ahead 0.00/s, evicted without access 0.00/s
  152. LRU len: 8500, unzip_LRU len: 0
  153. I/O sum[5988]:cur[0], unzip sum[0]:cur[0]
  154. ---BUFFER POOL 2
  155. Buffer pool size 163839
  156. Free buffers 155470
  157. Database pages 7590
  158. Old database pages 2795
  159. Modified db pages 0
  160. Pending reads 0
  161. Pending writes: LRU 0, flush list 0, single page 0
  162. Pages made young 23, not young 0
  163. 0.00 youngs/s, 0.00 non-youngs/s
  164. Pages read 6995, created 3649, written 13029
  165. 0.00 reads/s, 0.00 creates/s, 0.20 writes/s
  166. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  167. Pages read ahead 0.00/s, evicted without access 0.00/s
  168. LRU len: 7590, unzip_LRU len: 0
  169. I/O sum[5988]:cur[0], unzip sum[0]:cur[0]
  170. ---BUFFER POOL 3
  171. Buffer pool size 163839
  172. Free buffers 155017
  173. Database pages 8046
  174. Old database pages 2950
  175. Modified db pages 0
  176. Pending reads 0
  177. Pending writes: LRU 0, flush list 0, single page 0
  178. Pages made young 11, not young 0
  179. 0.00 youngs/s, 0.00 non-youngs/s
  180. Pages read 7298, created 3775, written 8392
  181. 0.00 reads/s, 0.00 creates/s, 0.05 writes/s
  182. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  183. Pages read ahead 0.00/s, evicted without access 0.00/s
  184. LRU len: 8046, unzip_LRU len: 0
  185. I/O sum[5988]:cur[0], unzip sum[0]:cur[0]
  186. ---BUFFER POOL 4
  187. Buffer pool size 163839
  188. Free buffers 154664
  189. Database pages 8391
  190. Old database pages 3078
  191. Modified db pages 0
  192. Pending reads 0
  193. Pending writes: LRU 0, flush list 0, single page 0
  194. Pages made young 2, not young 0
  195. 0.00 youngs/s, 0.00 non-youngs/s
  196. Pages read 7445, created 3591, written 12360
  197. 0.00 reads/s, 0.00 creates/s, 0.10 writes/s
  198. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  199. Pages read ahead 0.00/s, evicted without access 0.00/s
  200. LRU len: 8391, unzip_LRU len: 0
  201. I/O sum[5988]:cur[0], unzip sum[0]:cur[0]
  202. ---BUFFER POOL 5
  203. Buffer pool size 163839
  204. Free buffers 154651
  205. Database pages 8407
  206. Old database pages 3083
  207. Modified db pages 0
  208. Pending reads 0
  209. Pending writes: LRU 0, flush list 0, single page 0
  210. Pages made young 23, not young 0
  211. 0.00 youngs/s, 0.00 non-youngs/s
  212. Pages read 7626, created 3796, written 8378
  213. 0.00 reads/s, 0.00 creates/s, 0.05 writes/s
  214. No buffer pool page gets since the last printout
  215. Pages read ahead 0.00/s, evicted without access 0.00/s
  216. LRU len: 8407, unzip_LRU len: 0
  217. I/O sum[5988]:cur[0], unzip sum[0]:cur[0]
  218. ---BUFFER POOL 6
  219. Buffer pool size 163839
  220. Free buffers 154761
  221. Database pages 8298
  222. Old database pages 3043
  223. Modified db pages 0
  224. Pending reads 0
  225. Pending writes: LRU 0, flush list 0, single page 0
  226. Pages made young 3, not young 0
  227. 0.00 youngs/s, 0.00 non-youngs/s
  228. Pages read 7366, created 3727, written 9528
  229. 0.05 reads/s, 0.00 creates/s, 0.10 writes/s
  230. Buffer pool hit rate 996 / 1000, young-making rate 0 / 1000 not 0 / 1000
  231. Pages read ahead 0.00/s, evicted without access 0.00/s
  232. LRU len: 8298, unzip_LRU len: 0
  233. I/O sum[5988]:cur[0], unzip sum[0]:cur[0]
  234. ---BUFFER POOL 7
  235. Buffer pool size 163839
  236. Free buffers 154909
  237. Database pages 8155
  238. Old database pages 2996
  239. Modified db pages 0
  240. Pending reads 0
  241. Pending writes: LRU 0, flush list 0, single page 0
  242. Pages made young 13, not young 0
  243. 0.00 youngs/s, 0.00 non-youngs/s
  244. Pages read 7267, created 3654, written 10560
  245. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  246. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  247. Pages read ahead 0.00/s, evicted without access 0.00/s
  248. LRU len: 8155, unzip_LRU len: 0
  249. I/O sum[5988]:cur[0], unzip sum[0]:cur[0]
  250. --------------
  251. ROW OPERATIONS
  252. --------------
  253. 0 queries inside InnoDB, 0 queries in queue
  254. 4 read views open inside InnoDB
  255. Main thread process no. 1808, id 1205074240, state: sleeping
  256. Number of rows inserted 3371189, updated 64827, deleted 317007, read 144559706
  257. 0.00 inserts/s, 0.05 updates/s, 0.00 deletes/s, 1871.61 reads/s
  258. ----------------------------
  259. END OF INNODB MONITOR OUTPUT
  260. ============================
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!