SHARE
TWEET

Untitled

a guest Mar 2nd, 2012 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. ============================
RAW Paste Data
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
 
Top