Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Aug 8th, 2012  |  syntax: None  |  size: 29.07 KB  |  hits: 7  |  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. 'InnoDB', '', '
  2. =====================================
  3. 120808 14:03:24 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 14 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 51709 1_second, 51700 sleeps, 5156 10_second, 155 background, 155 flush
  10. srv_master_thread log flush and writes: 51753
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 3533, signal count 5712
  15. Mutex spin waits 11119, rounds 23363, OS waits 253
  16. RW-shared spins 4227, rounds 99424, OS waits 3185
  17. RW-excl spins 195, rounds 6704, OS waits 82
  18. Spin rounds per wait: 2.10 mutex, 23.52 RW-shared, 34.38 RW-excl
  19. ------------------------
  20. LATEST DETECTED DEADLOCK
  21. ------------------------
  22. 120808 13:38:47
  23. *** (1) TRANSACTION:
  24. TRANSACTION 38E163, ACTIVE 0 sec starting index read
  25. mysql tables in use 1, locked 1
  26. LOCK WAIT 3 lock struct(s), heap size 1248, 182 row lock(s)
  27. MySQL thread id 25659, OS thread handle 0x112fe5000, query id 925074 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root Sending data
  28. CALL load_records_to_index(''2'',50)
  29. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  30. RECORD LOCKS space id 0 page no 1017 n bits 200 index `PRIMARY` of table `s1_cms`.`dist_reindex_journal` trx id 38E163 lock_mode X locks rec but not gap waiting
  31. Record lock, heap no 71 PHYSICAL RECORD: n_fields 10; compact format; info bits 32
  32.  0: len 8; hex 8000000000000b14; asc         ;;
  33.  1: len 6; hex 00000038e161; asc    8 a;;
  34.  2: len 7; hex 02000012580ac7; asc     X  ;;
  35.  3: len 30; hex 61313438653665342d323037612d343136372d386561632d303536616232; asc a148e6e4-207a-4167-8eac-056ab2; (total 36 bytes);
  36.  4: len 30; hex 61313438653665342d323037612d343136372d386561632d303536616232; asc a148e6e4-207a-4167-8eac-056ab2; (total 36 bytes);
  37.  5: len 1; hex 32; asc 2;;
  38.  6: len 4; hex 8000001e; asc     ;;
  39.  7: len 4; hex 5022a426; asc P" &;;
  40.  8: SQL NULL;
  41.  9: len 4; hex 80000001; asc     ;;
  42.  
  43. *** (2) TRANSACTION:
  44. TRANSACTION 38E161, ACTIVE 0 sec updating or deleting
  45. mysql tables in use 1, locked 1
  46. 3 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 1
  47. MySQL thread id 25408, OS thread handle 0x112b86000, query id 925058 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root updating
  48. DELETE FROM dist_reindex_journal where id in (2836,2837,2838,2839,2840,2841,2842,2843,2844,2845)
  49. *** (2) HOLDS THE LOCK(S):
  50. RECORD LOCKS space id 0 page no 1017 n bits 200 index `PRIMARY` of table `s1_cms`.`dist_reindex_journal` trx id 38E161 lock_mode X locks rec but not gap
  51. Record lock, heap no 71 PHYSICAL RECORD: n_fields 10; compact format; info bits 32
  52.  0: len 8; hex 8000000000000b14; asc         ;;
  53.  1: len 6; hex 00000038e161; asc    8 a;;
  54.  2: len 7; hex 02000012580ac7; asc     X  ;;
  55.  3: len 30; hex 61313438653665342d323037612d343136372d386561632d303536616232; asc a148e6e4-207a-4167-8eac-056ab2; (total 36 bytes);
  56.  4: len 30; hex 61313438653665342d323037612d343136372d386561632d303536616232; asc a148e6e4-207a-4167-8eac-056ab2; (total 36 bytes);
  57.  5: len 1; hex 32; asc 2;;
  58.  6: len 4; hex 8000001e; asc     ;;
  59.  7: len 4; hex 5022a426; asc P" &;;
  60.  8: SQL NULL;
  61.  9: len 4; hex 80000001; asc     ;;
  62.  
  63. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  64. RECORD LOCKS space id 0 page no 4724 n bits 528 index `dist_reindex_index6` of table `s1_cms`.`dist_reindex_journal` trx id 38E161 lock_mode X locks rec but not gap waiting
  65. Record lock, heap no 35 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  66.  0: len 4; hex 8000001e; asc     ;;
  67.  1: len 8; hex 8000000000000b14; asc         ;;
  68.  
  69. *** WE ROLL BACK TRANSACTION (1)
  70. ------------
  71. TRANSACTIONS
  72. ------------
  73. Trx id counter 393094
  74. Purge done for trx''s n:o < 392B92 undo n:o < 0
  75. History list length 886
  76. LIST OF TRANSACTIONS FOR EACH SESSION:
  77. ---TRANSACTION 392F35, not started
  78. MySQL thread id 26346, OS thread handle 0x116a52000, query id 968066 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  79. ---TRANSACTION 392F37, not started
  80. MySQL thread id 26345, OS thread handle 0x116a0f000, query id 968071 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  81. ---TRANSACTION 392F19, not started
  82. MySQL thread id 26335, OS thread handle 0x1169cc000, query id 967796 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  83. ---TRANSACTION 392F1F, not started
  84. MySQL thread id 26334, OS thread handle 0x116989000, query id 967846 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  85. ---TRANSACTION 392F17, not started
  86. MySQL thread id 26333, OS thread handle 0x116946000, query id 967790 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  87. ---TRANSACTION 392F1D, not started
  88. MySQL thread id 26332, OS thread handle 0x116903000, query id 967841 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  89. ---TRANSACTION 392EFE, not started
  90. MySQL thread id 26328, OS thread handle 0x1168c0000, query id 967531 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  91. ---TRANSACTION 392EFB, not started
  92. MySQL thread id 26320, OS thread handle 0x11687d000, query id 967487 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  93. ---TRANSACTION 392F01, not started
  94. MySQL thread id 26319, OS thread handle 0x11683a000, query id 967546 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  95. ---TRANSACTION 392EF9, not started
  96. MySQL thread id 26316, OS thread handle 0x1167f7000, query id 967481 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  97. ---TRANSACTION 392EDC, not started
  98. MySQL thread id 26307, OS thread handle 0x1167b4000, query id 967193 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  99. ---TRANSACTION 392EE2, not started
  100. MySQL thread id 26306, OS thread handle 0x116771000, query id 967245 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  101. ---TRANSACTION 392EDA, not started
  102. MySQL thread id 26304, OS thread handle 0x11672e000, query id 967187 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  103. ---TRANSACTION 392EDF, not started
  104. MySQL thread id 26303, OS thread handle 0x1166eb000, query id 967230 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  105. ---TRANSACTION 392EC4, not started
  106. MySQL thread id 26301, OS thread handle 0x1166a8000, query id 966947 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  107. ---TRANSACTION 392EBD, not started
  108. MySQL thread id 26292, OS thread handle 0x116665000, query id 966891 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  109. ---TRANSACTION 392EC2, not started
  110. MySQL thread id 26291, OS thread handle 0x116622000, query id 966934 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  111. ---TRANSACTION 392EBF, not started
  112. MySQL thread id 26288, OS thread handle 0x1165df000, query id 966897 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  113. ---TRANSACTION 392EA0, not started
  114. MySQL thread id 26279, OS thread handle 0x11659c000, query id 966597 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  115. ---TRANSACTION 392EA5, not started
  116. MySQL thread id 26278, OS thread handle 0x116559000, query id 966640 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  117. ---TRANSACTION 392E9D, not started
  118. MySQL thread id 26277, OS thread handle 0x116516000, query id 966584 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  119. ---TRANSACTION 392EA3, not started
  120. MySQL thread id 26276, OS thread handle 0x1164d3000, query id 966635 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  121. ---TRANSACTION 392E85, not started
  122. MySQL thread id 26272, OS thread handle 0x116490000, query id 966338 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  123. ---TRANSACTION 392E82, not started
  124. MySQL thread id 26264, OS thread handle 0x11644d000, query id 966294 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  125. ---TRANSACTION 392E87, not started
  126. MySQL thread id 26263, OS thread handle 0x11640a000, query id 966344 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  127. ---TRANSACTION 392E80, not started
  128. MySQL thread id 26260, OS thread handle 0x1163c7000, query id 966288 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  129. ---TRANSACTION 392E62, not started
  130. MySQL thread id 26251, OS thread handle 0x116384000, query id 965991 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  131. ---TRANSACTION 392E69, not started
  132. MySQL thread id 26250, OS thread handle 0x116341000, query id 966057 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  133. ---TRANSACTION 392E60, not started
  134. MySQL thread id 26249, OS thread handle 0x1161d3000, query id 965985 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  135. ---TRANSACTION 392E66, not started
  136. MySQL thread id 26248, OS thread handle 0x116190000, query id 966035 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  137. ---TRANSACTION 392E42, not started
  138. MySQL thread id 26237, OS thread handle 0x11614d000, query id 965683 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  139. ---TRANSACTION 392E47, not started
  140. MySQL thread id 26236, OS thread handle 0x11610a000, query id 965726 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  141. ---TRANSACTION 392E44, not started
  142. MySQL thread id 26234, OS thread handle 0x1160c7000, query id 965689 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  143. ---TRANSACTION 392E4A, not started
  144. MySQL thread id 26233, OS thread handle 0x116084000, query id 965741 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  145. ---TRANSACTION 392E19, not started
  146. MySQL thread id 26223, OS thread handle 0x116041000, query id 965313 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  147. ---TRANSACTION 392E1E, not started
  148. MySQL thread id 26222, OS thread handle 0x1157d3000, query id 965356 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  149. ---TRANSACTION 392E17, not started
  150. MySQL thread id 26221, OS thread handle 0x115790000, query id 965307 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  151. ---TRANSACTION 392E1C, not started
  152. MySQL thread id 26218, OS thread handle 0x11574d000, query id 965350 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  153. ---TRANSACTION 392DF9, not started
  154. MySQL thread id 26209, OS thread handle 0x11570a000, query id 965003 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  155. ---TRANSACTION 392E01, not started
  156. MySQL thread id 26208, OS thread handle 0x1156c7000, query id 965067 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  157. ---TRANSACTION 392DF7, not started
  158. MySQL thread id 26207, OS thread handle 0x115684000, query id 964997 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  159. ---TRANSACTION 392DFE, not started
  160. MySQL thread id 26206, OS thread handle 0x115641000, query id 965054 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  161. ---TRANSACTION 392DDC, not started
  162. MySQL thread id 26195, OS thread handle 0x1154d1000, query id 964712 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  163. ---TRANSACTION 392DE1, not started
  164. MySQL thread id 26194, OS thread handle 0x11548e000, query id 964755 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  165. ---TRANSACTION 392DD9, not started
  166. MySQL thread id 26193, OS thread handle 0x11544b000, query id 964699 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  167. ---TRANSACTION 392DDF, not started
  168. MySQL thread id 26192, OS thread handle 0x115408000, query id 964750 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  169. ---TRANSACTION 392DBC, not started
  170. MySQL thread id 26181, OS thread handle 0x1153c5000, query id 964400 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  171. ---TRANSACTION 392DC1, not started
  172. MySQL thread id 26180, OS thread handle 0x115382000, query id 964443 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  173. ---TRANSACTION 392DBF, not started
  174. MySQL thread id 26178, OS thread handle 0x11533f000, query id 964438 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  175. ---TRANSACTION 392DBA, not started
  176. MySQL thread id 26177, OS thread handle 0x1152fc000, query id 964394 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  177. ---TRANSACTION 392D9D, not started
  178. MySQL thread id 26167, OS thread handle 0x1152b9000, query id 964097 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  179. ---TRANSACTION 392DA3, not started
  180. MySQL thread id 26166, OS thread handle 0x115276000, query id 964147 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  181. ---TRANSACTION 392D9B, not started
  182. MySQL thread id 26165, OS thread handle 0x115233000, query id 964091 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  183. ---TRANSACTION 392DA1, not started
  184. MySQL thread id 26164, OS thread handle 0x1151f0000, query id 964142 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  185. ---TRANSACTION 392D83, not started
  186. MySQL thread id 26160, OS thread handle 0x1151ad000, query id 963839 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  187. ---TRANSACTION 392D7F, not started
  188. MySQL thread id 26152, OS thread handle 0x11516a000, query id 963788 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  189. ---TRANSACTION 392D85, not started
  190. MySQL thread id 26151, OS thread handle 0x115127000, query id 963845 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  191. ---TRANSACTION 392D7D, not started
  192. MySQL thread id 26150, OS thread handle 0x1150e4000, query id 963782 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  193. ---TRANSACTION 392D66, not started
  194. MySQL thread id 26147, OS thread handle 0x1150a1000, query id 963544 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  195. ---TRANSACTION 392D64, not started
  196. MySQL thread id 26145, OS thread handle 0x11505e000, query id 963532 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  197. ---TRANSACTION 392D61, not started
  198. MySQL thread id 26137, OS thread handle 0x11501b000, query id 963487 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  199. ---TRANSACTION 392D5F, not started
  200. MySQL thread id 26134, OS thread handle 0x114fd8000, query id 963481 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  201. ---TRANSACTION 392D41, not started
  202. MySQL thread id 26125, OS thread handle 0x114f95000, query id 963193 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  203. ---TRANSACTION 392D47, not started
  204. MySQL thread id 26124, OS thread handle 0x114f52000, query id 963252 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  205. ---TRANSACTION 392D3F, not started
  206. MySQL thread id 26123, OS thread handle 0x114f0f000, query id 963187 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  207. ---TRANSACTION 392D44, not started
  208. MySQL thread id 26122, OS thread handle 0x114ecc000, query id 963231 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  209. ---TRANSACTION 392D29, not started
  210. MySQL thread id 26119, OS thread handle 0x114e89000, query id 962943 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  211. ---TRANSACTION 392D21, not started
  212. MySQL thread id 26110, OS thread handle 0x114e46000, query id 962878 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  213. ---TRANSACTION 392D26, not started
  214. MySQL thread id 26109, OS thread handle 0x114e03000, query id 962921 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  215. ---TRANSACTION 392D23, not started
  216. MySQL thread id 26106, OS thread handle 0x114dc0000, query id 962884 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  217. ---TRANSACTION 392D05, not started
  218. MySQL thread id 26097, OS thread handle 0x114d7d000, query id 962595 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  219. ---TRANSACTION 392D0B, not started
  220. MySQL thread id 26096, OS thread handle 0x114d3a000, query id 962647 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  221. ---TRANSACTION 392D08, not started
  222. MySQL thread id 26094, OS thread handle 0x114cf7000, query id 962633 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  223. ---TRANSACTION 392D02, not started
  224. MySQL thread id 26093, OS thread handle 0x114cb4000, query id 962582 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  225. ---TRANSACTION 392CEA, not started
  226. MySQL thread id 26090, OS thread handle 0x114c71000, query id 962336 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  227. ---TRANSACTION 392CE7, not started
  228. MySQL thread id 26082, OS thread handle 0x114c2e000, query id 962292 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  229. ---TRANSACTION 392CEC, not started
  230. MySQL thread id 26081, OS thread handle 0x114beb000, query id 962342 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  231. ---TRANSACTION 392CE5, not started
  232. MySQL thread id 26080, OS thread handle 0x114ba8000, query id 962286 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  233. ---TRANSACTION 392CC8, not started
  234. MySQL thread id 26069, OS thread handle 0x114b65000, query id 961994 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  235. ---TRANSACTION 392CCD, not started
  236. MySQL thread id 26068, OS thread handle 0x114b22000, query id 962037 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  237. ---TRANSACTION 392CC5, not started
  238. MySQL thread id 26067, OS thread handle 0x114adf000, query id 961979 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  239. ---TRANSACTION 392CCB, not started
  240. MySQL thread id 26064, OS thread handle 0x114a9c000, query id 962031 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  241. ---TRANSACTION 392CA9, not started
  242. MySQL thread id 26055, OS thread handle 0x114a59000, query id 961689 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  243. ---TRANSACTION 392CA7, not started
  244. MySQL thread id 26053, OS thread handle 0x114a16000, query id 961683 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  245. ---TRANSACTION 392CAD, not started
  246. MySQL thread id 26052, OS thread handle 0x1149d3000, query id 961734 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  247. ---TRANSACTION 392CAF, not started
  248. MySQL thread id 26051, OS thread handle 0x114990000, query id 961739 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  249. ---TRANSACTION 392C8B, not started
  250. MySQL thread id 26041, OS thread handle 0x11494d000, query id 961391 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  251. ---TRANSACTION 392C90, not started
  252. MySQL thread id 26040, OS thread handle 0x11490a000, query id 961434 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  253. ---TRANSACTION 392C89, not started
  254. MySQL thread id 26039, OS thread handle 0x1148c7000, query id 961385 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  255. ---TRANSACTION 392C8E, not started
  256. MySQL thread id 26038, OS thread handle 0x114884000, query id 961428 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  257. ---TRANSACTION 392C6C, not started
  258. MySQL thread id 26027, OS thread handle 0x114841000, query id 961082 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  259. ---TRANSACTION 392C71, not started
  260. MySQL thread id 26026, OS thread handle 0x113fcc000, query id 961125 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  261. ---TRANSACTION 392C6A, not started
  262. MySQL thread id 26024, OS thread handle 0x113f89000, query id 961076 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  263. ---TRANSACTION 392C6F, not started
  264. MySQL thread id 26023, OS thread handle 0x113f46000, query id 961119 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  265. ---TRANSACTION 392C48, not started
  266. MySQL thread id 26021, OS thread handle 0x113f03000, query id 960765 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  267. ---TRANSACTION 392C45, not started
  268. MySQL thread id 26019, OS thread handle 0x113ec0000, query id 960743 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  269. ---TRANSACTION 392C42, not started
  270. MySQL thread id 26011, OS thread handle 0x113e7d000, query id 960699 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  271. ---TRANSACTION 392C40, not started
  272. MySQL thread id 26008, OS thread handle 0x113e3a000, query id 960693 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  273. ---TRANSACTION 392C23, not started
  274. MySQL thread id 25999, OS thread handle 0x113df7000, query id 960414 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  275. ---TRANSACTION 392C29, not started
  276. MySQL thread id 25998, OS thread handle 0x113db4000, query id 960473 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  277. ---TRANSACTION 392C21, not started
  278. MySQL thread id 25997, OS thread handle 0x113d71000, query id 960408 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  279. ---TRANSACTION 392C26, not started
  280. MySQL thread id 25996, OS thread handle 0x113d2e000, query id 960451 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  281. ---TRANSACTION 392C04, not started
  282. MySQL thread id 25985, OS thread handle 0x113ceb000, query id 960107 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  283. ---TRANSACTION 392C09, not started
  284. MySQL thread id 25984, OS thread handle 0x113ca8000, query id 960150 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  285. ---TRANSACTION 392C01, not started
  286. MySQL thread id 25983, OS thread handle 0x113c65000, query id 960094 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  287. ---TRANSACTION 392C07, not started
  288. MySQL thread id 25982, OS thread handle 0x113c22000, query id 960144 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  289. ---TRANSACTION 392BEB, not started
  290. MySQL thread id 25979, OS thread handle 0x113bdf000, query id 959856 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  291. ---TRANSACTION 392BE9, not started
  292. MySQL thread id 25978, OS thread handle 0x113b9c000, query id 959844 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  293. ---TRANSACTION 392BE5, not started
  294. MySQL thread id 25969, OS thread handle 0x113b59000, query id 959790 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  295. ---TRANSACTION 392BE3, not started
  296. MySQL thread id 25966, OS thread handle 0x113b16000, query id 959784 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  297. ---TRANSACTION 392BCC, not started
  298. MySQL thread id 25964, OS thread handle 0x113ad3000, query id 959555 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  299. ---TRANSACTION 392BC6, not started
  300. MySQL thread id 25956, OS thread handle 0x113a90000, query id 959496 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  301. ---TRANSACTION 392BC4, not started
  302. MySQL thread id 25954, OS thread handle 0x113a4d000, query id 959490 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  303. ---TRANSACTION 392BAE, not started
  304. MySQL thread id 25952, OS thread handle 0x113a0a000, query id 959261 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  305. ---TRANSACTION 392AEF, not started
  306. MySQL thread id 25686, OS thread handle 0x1139c7000, query id 958614 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  307. ---TRANSACTION 392B8E, not started
  308. MySQL thread id 25685, OS thread handle 0x113984000, query id 958967 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root Waiting for table metadata lock
  309. SELECT index_name,index_type FROM indicies
  310. ---TRANSACTION 392BAC, not started
  311. MySQL thread id 25659, OS thread handle 0x112fe5000, query id 959249 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  312. ---TRANSACTION 392B85, not started
  313. MySQL thread id 25567, OS thread handle 0x112eed000, query id 959016 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root Waiting for table metadata lock
  314. CALL load_records_to_index(''1'',50)
  315. ---TRANSACTION 392BCA, not started
  316. MySQL thread id 25558, OS thread handle 0x112eaa000, query id 959549 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  317. ---TRANSACTION 392BA7, not started
  318. MySQL thread id 25547, OS thread handle 0x112e67000, query id 959205 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  319. ---TRANSACTION 392B72, not started
  320. MySQL thread id 25454, OS thread handle 0x112f5f000, query id 958829 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  321. ---TRANSACTION 392AB7, not started
  322. MySQL thread id 25453, OS thread handle 0x112d9e000, query id 958462 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  323. ---TRANSACTION 392B90, not started
  324. MySQL thread id 25452, OS thread handle 0x112d5b000, query id 958974 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root Waiting for table metadata lock
  325. SELECT index_name,index_type FROM indicies
  326. ---TRANSACTION 392BA9, not started
  327. MySQL thread id 25443, OS thread handle 0x112d18000, query id 959211 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  328. ---TRANSACTION 38443C, not started
  329. MySQL thread id 25440, OS thread handle 0x112c4f000, query id 851537 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  330. ---TRANSACTION 392351, not started
  331. MySQL thread id 25408, OS thread handle 0x112b86000, query id 955479 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  332. ---TRANSACTION 387585, not started
  333. MySQL thread id 25380, OS thread handle 0x112b43000, query id 876825 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  334. ---TRANSACTION 390BC2, not started
  335. MySQL thread id 25379, OS thread handle 0x111450000, query id 944151 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  336. ---TRANSACTION 388D35, not started
  337. MySQL thread id 25375, OS thread handle 0x111344000, query id 886426 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  338. ---TRANSACTION 3888CC, not started
  339. MySQL thread id 25373, OS thread handle 0x10f7a7000, query id 884728 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  340. ---TRANSACTION 392AD7, not started
  341. MySQL thread id 25361, OS thread handle 0x10f764000, query id 958585 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  342. ---TRANSACTION 38D861, not started
  343. MySQL thread id 25299, OS thread handle 0x10cfc4000, query id 921359 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  344. ---TRANSACTION 3842A1, not started
  345. MySQL thread id 25295, OS thread handle 0x10cce5000, query id 849918 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  346. ---TRANSACTION 0, not started
  347. MySQL thread id 11745, OS thread handle 0x111387000, query id 972186 localhost 127.0.0.1 root
  348. ---TRANSACTION 37D7D5, not started
  349. MySQL thread id 24892, OS thread handle 0x112e24000, query id 783739 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  350. ---TRANSACTION 37D56C, not started
  351. MySQL thread id 24891, OS thread handle 0x112de1000, query id 782277 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  352. ---TRANSACTION 37D7D9, not started
  353. MySQL thread id 24612, OS thread handle 0x112cd5000, query id 783741 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  354. ---TRANSACTION 37D7D8, not started
  355. MySQL thread id 24517, OS thread handle 0x112c92000, query id 783744 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  356. ---TRANSACTION 37D7DC, not started
  357. MySQL thread id 24515, OS thread handle 0x112c0c000, query id 783756 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  358. ---TRANSACTION 37A34B, not started
  359. MySQL thread id 24510, OS thread handle 0x112bc9000, query id 759933 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  360. ---TRANSACTION 37D7D7, not started
  361. MySQL thread id 24253, OS thread handle 0x11140d000, query id 783735 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  362. ---TRANSACTION 37D70F, not started
  363. MySQL thread id 24251, OS thread handle 0x10f7ea000, query id 783060 p2-cmsapps101.ad.prodcc.net 10.20.124.237 root
  364. ---TRANSACTION 0, not started
  365. MySQL thread id 11746, OS thread handle 0x1113ca000, query id 974336 localhost 127.0.0.1 root
  366. SHOW ENGINE INNODB STATUS
  367. ---TRANSACTION 393092, not started
  368. MySQL thread id 197, OS thread handle 0x111301000, query id 974333 localhost 127.0.0.1 root
  369. ---TRANSACTION 373828, not started
  370. MySQL thread id 196, OS thread handle 0x1112be000, query id 614364 localhost 127.0.0.1 root
  371. ---TRANSACTION 393024, not started
  372. MySQL thread id 195, OS thread handle 0x11127b000, query id 972328 localhost 127.0.0.1 root
  373. ---TRANSACTION 37D7E9, not started
  374. MySQL thread id 194, OS thread handle 0x111238000, query id 783892 localhost 127.0.0.1 root
  375. ---TRANSACTION 37D7E7, not started
  376. MySQL thread id 50, OS thread handle 0x111141000, query id 783882 localhost 127.0.0.1 root
  377. ---TRANSACTION 39301A, not started
  378. MySQL thread id 29, OS thread handle 0x10f6e2000, query id 972290 localhost 127.0.0.1 root
  379. ---TRANSACTION 373829, not started
  380. MySQL thread id 28, OS thread handle 0x10f4c4000, query id 614365 localhost 127.0.0.1 root
  381. ---TRANSACTION 392B8B, ACTIVE 1229 sec
  382. mysql tables in use 4, locked 4
  383. 4 lock struct(s), heap size 1248, 0 row lock(s)
  384. MySQL thread id 25683, OS thread handle 0x113941000, query id 958933 p2-cmsapps102.ad.prodcc.net 10.20.124.238 root
  385. Trx read view will not see trx with id >= 392B8C, sees < 392B8C
  386. --------
  387. FILE I/O
  388. --------
  389. I/O thread 0 state: waiting for i/o request (insert buffer thread)
  390. I/O thread 1 state: waiting for i/o request (log thread)
  391. I/O thread 2 state: waiting for i/o request (read thread)
  392. I/O thread 3 state: waiting for i/o request (read thread)
  393. I/O thread 4 state: waiting for i/o request (read thread)
  394. I/O thread 5 state: waiting for i/o request (read thread)
  395. I/O thread 6 state: waiting for i/o request (write thread)
  396. I/O thread 7 state: waiting for i/o request (write thread)
  397. I/O thread 8 state: waiting for i/o request (write thread)
  398. I/O thread 9 state: waiting for i/o request (write thread)
  399. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  400.  ibuf aio reads: 0, log i/o''s: 0, sync i/o''s: 0
  401. Pending flushes (fsync) log: 0; buffer pool: 0
  402. 1774 OS file reads, 60123 OS file writes, 36358 OS fsyncs
  403. 0.00 reads/s, 0 avg bytes/read, 0.57 writes/s, 0.36 fsyncs/s
  404. -------------------------------------
  405. INSERT BUFFER AND ADAPTIVE HASH INDEX
  406. -------------------------------------
  407. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  408. merged operations:
  409.  insert 0, delete mark 0, delete 0
  410. discarded operations:
  411.  insert 0, delete mark 0, delete 0
  412. Hash table size 276707, node heap has 17 buffer(s)
  413. 0.14 hash searches/s, 2.14 non-hash searches/s
  414. ---
  415. LOG
  416. ---
  417. Log sequence number 967081693
  418. Log flushed up to   967081693
  419. Last checkpoint at  967081253
  420. 0 pending log writes, 0 pending chkp writes
  421. 28949 log i/o''s done, 0.21 log i/o''s/second
  422. ----------------------
  423. BUFFER POOL AND MEMORY
  424. ----------------------
  425. Total memory allocated 137363456; in additional pool allocated 0
  426. Dictionary memory allocated 2214728
  427. Buffer pool size   8192
  428. Free buffers       4892
  429. Database pages     3283
  430. Old database pages 1191
  431. Modified db pages  5
  432. Pending reads 0
  433. Pending writes: LRU 0, flush list 0, single page 0
  434. Pages made young 13, not young 0
  435. 0.00 youngs/s, 0.00 non-youngs/s
  436. Pages read 1195, created 2088, written 38575
  437. 0.00 reads/s, 0.00 creates/s, 0.36 writes/s
  438. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  439. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  440. LRU len: 3283, unzip_LRU len: 0
  441. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  442. --------------
  443. ROW OPERATIONS
  444. --------------
  445. 0 queries inside InnoDB, 0 queries in queue
  446. 2 read views open inside InnoDB
  447. Main thread id 4531425280, state: sleeping
  448. Number of rows inserted 27985, updated 19463, deleted 12255, read 37938453
  449. 0.00 inserts/s, 0.14 updates/s, 0.00 deletes/s, 1.71 reads/s
  450. ----------------------------
  451. END OF INNODB MONITOR OUTPUT
  452. ============================
  453. '
create a new version of this paste RAW Paste Data