API tools faq
paste
Advertisement
alvise72

Untitled

alvise72
Jun 17th, 2014
965
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 12.95 KB | None | 0 0
raw download clone embed print report
  1. mysql> SHOW ENGINE INNODB STATUS\G
  2. *************************** 1. row ***************************
  3.   Type: InnoDB
  4.   Name:
  5. Status:
  6. =====================================
  7. 140617  9:11:02 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 21 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 427084 1_second, 426869 sleeps, 42635 10_second, 842 background, 842 flush
  14. srv_master_thread log flush and writes: 430529
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 127346, signal count 201499
  19. Mutex spin waits 421520, rounds 1599258, OS waits 34700
  20. RW-shared spins 189608, rounds 2851179, OS waits 78612
  21. RW-excl spins 11754, rounds 686272, OS waits 12384
  22. Spin rounds per wait: 3.79 mutex, 15.04 RW-shared, 58.39 RW-excl
  23. --------
  24. FILE I/O
  25. --------
  26. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  27. I/O thread 1 state: waiting for completed aio requests (log thread)
  28. I/O thread 2 state: waiting for completed aio requests (read thread)
  29. I/O thread 3 state: waiting for completed aio requests (read thread)
  30. I/O thread 4 state: waiting for completed aio requests (read thread)
  31. I/O thread 5 state: waiting for completed aio requests (read thread)
  32. I/O thread 6 state: waiting for completed aio requests (write thread)
  33. I/O thread 7 state: waiting for completed aio requests (write thread)
  34. I/O thread 8 state: waiting for completed aio requests (write thread)
  35. I/O thread 9 state: waiting for completed aio requests (write thread)
  36. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  37.  ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  38. Pending flushes (fsync) log: 0; buffer pool: 0
  39. 14601788 OS file reads, 14976421 OS file writes, 3257588 OS fsyncs
  40. 1 pending preads, 0 pending pwrites
  41. 1303.65 reads/s, 16384 avg bytes/read, 642.97 writes/s, 20.90 fsyncs/s
  42. -------------------------------------
  43. INSERT BUFFER AND ADAPTIVE HASH INDEX
  44. -------------------------------------
  45. Ibuf: size 1, free list len 8, seg size 10, 22860 merges
  46. merged operations:
  47.  insert 6296, delete mark 2514408, delete 15
  48. discarded operations:
  49.  insert 0, delete mark 0, delete 0
  50. Hash table size 276671, node heap has 74 buffer(s)
  51. 985.29 hash searches/s, 2155.04 non-hash searches/s
  52. ---
  53. LOG
  54. ---
  55. Log sequence number 39031646132
  56. Log flushed up to   39031617616
  57. Last checkpoint at  39028989211
  58. Max checkpoint age    7782360
  59. Checkpoint age target 7539162
  60. Modified age          1846637
  61. Checkpoint age        2656921
  62. 0 pending log writes, 0 pending chkp writes
  63. 2749625 log i/o's done, 7.81 log i/o's/second
  64. ----------------------
  65. BUFFER POOL AND MEMORY
  66. ----------------------
  67. Total memory allocated 137756672; in additional pool allocated 0
  68. Total memory allocated by read views 4312
  69. Internal hash tables (constant factor + variable factor)
  70.     Adaptive hash index 3430000     (2213368 + 1216632)
  71.     Page hash           139112 (buffer pool 0 only)
  72.     Dictionary cache    5616480     (554768 + 5061712)
  73.     File system         395440  (82672 + 312768)
  74.     Lock system         3032528     (332872 + 2699656)
  75.     Recovery system     0   (0 + 0)
  76. Dictionary memory allocated 5061712
  77. Buffer pool size        8191
  78. Buffer pool size, bytes 134201344
  79. Free buffers            0
  80. Database pages          7954
  81. Old database pages      2916
  82. Modified db pages       3621
  83. Pending reads 1
  84. Pending writes: LRU 0, flush list 0, single page 0
  85. Pages made young 15290863, not young 0
  86. 1328.22 youngs/s, 0.00 non-youngs/s
  87. Pages read 14601056, created 144666, written 11986160
  88. 1303.65 reads/s, 4.52 creates/s, 624.45 writes/s
  89. Buffer pool hit rate 897 / 1000, young-making rate 105 / 1000 not 0 / 1000
  90. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  91. LRU len: 7954, unzip_LRU len: 0
  92. I/O sum[80814]:cur[288], unzip sum[0]:cur[0]
  93. --------------
  94. ROW OPERATIONS
  95. --------------
  96. 0 queries inside InnoDB, 0 queries in queue
  97. 1 read views open inside InnoDB
  98. 1 transactions active inside InnoDB
  99. 1 out of 1000 descriptors used
  100. ---OLDEST VIEW---
  101. Normal read view
  102. Read view low limit trx n:o 580559E
  103. Read view up limit trx id 580529C
  104. Read view low limit trx id 580559E
  105. Read view individually stored trx ids:
  106. Read view trx id 580529C
  107. -----------------
  108. Main thread process no. 1362, id 140642055214848, state: sleeping
  109. Number of rows inserted 87495, updated 1256002, deleted 5020594, read 146788271
  110. 0.00 inserts/s, 3.10 updates/s, 683.97 deletes/s, 720.39 reads/s
  111. ------------
  112. TRANSACTIONS
  113. ------------
  114. Trx id counter 58055A9
  115. Purge done for trx's n:o < 580559E undo n:o < 0
  116. History list length 3214
  117. LIST OF TRANSACTIONS FOR EACH SESSION:
  118. ---TRANSACTION 580559F, not started
  119. MySQL thread id 356056, OS thread handle 0x7fe9cc16f700, query id 19584778 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  120. ---TRANSACTION 580559C, not started
  121. MySQL thread id 356055, OS thread handle 0x7fe9b725d700, query id 19584768 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  122. ---TRANSACTION 5805598, not started
  123. MySQL thread id 356054, OS thread handle 0x7fe9cc0ac700, query id 19584753 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  124. ---TRANSACTION 5805596, not started
  125. MySQL thread id 356053, OS thread handle 0x7fe9c4403700, query id 19584748 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  126. ---TRANSACTION 5805591, not started
  127. MySQL thread id 356052, OS thread handle 0x7fe9c4485700, query id 19584730 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  128. ---TRANSACTION 580558F, not started
  129. MySQL thread id 356051, OS thread handle 0x7fe9b719a700, query id 19584725 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  130. ---TRANSACTION 5805588, not started
  131. MySQL thread id 356050, OS thread handle 0x7fe9b7096700, query id 19584705 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  132. ---TRANSACTION 5805580, not started
  133. MySQL thread id 356049, OS thread handle 0x7fe9c7fbe700, query id 19584683 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  134. ---TRANSACTION 5805571, not started
  135. MySQL thread id 356048, OS thread handle 0x7fe9cc336700, query id 19584650 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 cinder_pp sleeping
  136. ---TRANSACTION 5805558, not started
  137. MySQL thread id 356044, OS thread handle 0x7fe9cc3b8700, query id 19584568 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  138. ---TRANSACTION 580556D, not started
  139. MySQL thread id 356043, OS thread handle 0x7fe9c4507700, query id 19584647 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 cinder sleeping
  140. ---TRANSACTION 580556A, not started
  141. MySQL thread id 356042, OS thread handle 0x7fe9cc377700, query id 19584643 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 cinder sleeping
  142. ---TRANSACTION 580558D, not started
  143. MySQL thread id 356041, OS thread handle 0x7fe9c4340700, query id 19584721 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  144. ---TRANSACTION 580558C, not started
  145. MySQL thread id 356040, OS thread handle 0x7fe9c468d700, query id 19584713 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  146. ---TRANSACTION 5805562, not started
  147. MySQL thread id 356039, OS thread handle 0x7fe9cc1f1700, query id 19584593 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  148. ---TRANSACTION 580554F, not started
  149. MySQL thread id 356038, OS thread handle 0x7fe9cc1b0700, query id 19584546 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  150. ---TRANSACTION 580554C, not started
  151. MySQL thread id 356037, OS thread handle 0x7fe9b70d7700, query id 19584536 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  152. ---TRANSACTION 5805545, not started
  153. MySQL thread id 356036, OS thread handle 0x7fe9b7055700, query id 19584516 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  154. ---TRANSACTION 5805544, not started
  155. MySQL thread id 356032, OS thread handle 0x7fe9b71db700, query id 19584513 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  156. ---TRANSACTION 58055A8, not started
  157. MySQL thread id 356031, OS thread handle 0x7fe9c40f7700, query id 19584807 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  158. ---TRANSACTION 58054F0, not started
  159. MySQL thread id 356030, OS thread handle 0x7fe9cc2b4700, query id 19584257 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 glance_pp sleeping
  160. ---TRANSACTION 58055A1, not started
  161. MySQL thread id 356029, OS thread handle 0x7fe9c427d700, query id 19584781 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  162. ---TRANSACTION 5805572, not started
  163. MySQL thread id 356028, OS thread handle 0x7fe9c460b700, query id 19584651 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 cinder_pp sleeping
  164. ---TRANSACTION 580559B, not started
  165. MySQL thread id 356027, OS thread handle 0x7fe9c41ba700, query id 19584761 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  166. ---TRANSACTION 580541B, not started
  167. MySQL thread id 356007, OS thread handle 0x7fe9b6f10700, query id 19583650 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 nova_pp sleeping
  168. ---TRANSACTION 0, not started
  169. MySQL thread id 355862, OS thread handle 0x7fe9c4075700, query id 19584794 localhost root sleeping
  170. SHOW ENGINE INNODB STATUS
  171. ---TRANSACTION 0, not started
  172. MySQL thread id 355959, OS thread handle 0x7fe9c40b6700, query id 19582454 localhost root sleeping
  173. ---TRANSACTION 58054ED, not started
  174. MySQL thread id 355890, OS thread handle 0x7fe9c7f3c700, query id 19584246 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 keystone_pp sleeping
  175. ---TRANSACTION 580559E, not started
  176. MySQL thread id 355568, OS thread handle 0x7fe9c4138700, query id 19584771 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  177. ---TRANSACTION 58055A6, not started
  178. MySQL thread id 355564, OS thread handle 0x7fe9c7e79700, query id 19584800 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  179. ---TRANSACTION 5805592, not started
  180. MySQL thread id 355557, OS thread handle 0x7fe9b6fd3700, query id 19584735 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  181. ---TRANSACTION 5805594, not started
  182. MySQL thread id 355556, OS thread handle 0x7fe9cc0ed700, query id 19584740 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  183. ---TRANSACTION 58055A5, not started
  184. MySQL thread id 355551, OS thread handle 0x7fe9c46ce700, query id 19584797 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  185. ---TRANSACTION 58055A3, not started
  186. MySQL thread id 355549, OS thread handle 0x7fe9c44c6700, query id 19584790 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  187. ---TRANSACTION 58055A7, not started
  188. MySQL thread id 355420, OS thread handle 0x7fe9c4791700, query id 19584803 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  189. ---TRANSACTION 58055A4, not started
  190. MySQL thread id 354281, OS thread handle 0x7fe9b721c700, query id 19584793 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  191. ---TRANSACTION 58055A2, not started
  192. MySQL thread id 354279, OS thread handle 0x7fe9c42be700, query id 19584787 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  193. ---TRANSACTION 5805599, not started
  194. MySQL thread id 354269, OS thread handle 0x7fe9c7fff700, query id 19584758 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 neutron_pp sleeping
  195. ---TRANSACTION 580529C, ACTIVE 101 sec fetching rows
  196. mysql tables in use 1, locked 1
  197. 29964 lock struct(s), heap size 2685368, 130276 row lock(s), undo log entries 65137
  198. MySQL thread id 355965, OS thread handle 0x7fe9d40a7700, query id 19582525 ha-proxy-01.cloud.pd.infn.it 192.168.60.21 keystone_pp updating
  199. DELETE FROM token WHERE token.expires < '2014-06-17 07:09:21'
  200. TABLE LOCK table `keystone_pp`.`token` trx id 580529C lock mode IX
  201. RECORD LOCKS space id 594 page no 3300 n bits 416 index `ix_token_expires` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  202. RECORD LOCKS space id 594 page no 82436 n bits 88 index `PRIMARY` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  203. RECORD LOCKS space id 594 page no 206519 n bits 88 index `PRIMARY` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  204. RECORD LOCKS space id 594 page no 277184 n bits 88 index `PRIMARY` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  205. RECORD LOCKS space id 594 page no 179700 n bits 88 index `PRIMARY` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  206. RECORD LOCKS space id 594 page no 123124 n bits 88 index `PRIMARY` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  207. RECORD LOCKS space id 594 page no 27999 n bits 88 index `PRIMARY` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  208. RECORD LOCKS space id 594 page no 92897 n bits 88 index `PRIMARY` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  209. RECORD LOCKS space id 594 page no 276611 n bits 88 index `PRIMARY` of table `keystone_pp`.`token` trx id 580529C lock_mode X locks rec but not gap
  210. TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS
  211. ----------------------------
  212. END OF INNODB MONITOR OUTPUT
  213. ============================
  214.  
  215. 1 row in set (0.39 sec)
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!