API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
122
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 55.87 KB | None | 0 0
raw download clone embed print report
  1. | InnoDB | |
  2. =====================================
  3. 2018-06-25 15:33:51 7f78247b7700 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 46 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 2100235 srv_active, 0 srv_shutdown, 14425 srv_idle
  10. srv_master_thread log flush and writes: 2114633
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 15475221
  15. OS WAIT ARRAY INFO: signal count 1182084829
  16. Mutex spin waits 1279254579, rounds 6746286897, OS waits 5770278
  17. RW-shared spins 323081883, rounds 703855257, OS waits 4063365
  18. RW-excl spins 63460514, rounds 1662368643, OS waits 3848575
  19. Spin rounds per wait: 5.27 mutex, 2.18 RW-shared, 26.20 RW-excl
  20. ------------
  21. TRANSACTIONS
  22. ------------
  23. Trx id counter 12859448095
  24. Purge done for trx's n:o < 12859448070 undo n:o < 0 state: running but idle
  25. History list length 1103
  26. LIST OF TRANSACTIONS FOR EACH SESSION:
  27. ---TRANSACTION 0, not started
  28. MySQL thread id 12086519, OS thread handle 0x7f78247b7700, query id 482844397 localhost root init
  29. SHOW ENGINE INNODB STATUS
  30. ---TRANSACTION 12859448019, not started
  31. MySQL thread id 12087817, OS thread handle 0x7f77f769a700, query id 482844332 localhost mobi_website
  32. ---TRANSACTION 12859447863, not started
  33. MySQL thread id 12087816, OS thread handle 0x7f7824366700, query id 482844187 localhost myinstar_ranker
  34. ---TRANSACTION 12859447763, not started
  35. MySQL thread id 12087814, OS thread handle 0x7f78050e1700, query id 482844096 localhost myinstar_ranker
  36. ---TRANSACTION 12859447546, not started
  37. MySQL thread id 12087813, OS thread handle 0x7f780587f700, query id 482843900 localhost myinstar_ranker
  38. ---TRANSACTION 12859447537, not started
  39. MySQL thread id 12087812, OS thread handle 0x7f77f7082700, query id 482843893 localhost myinstar_ranker
  40. ---TRANSACTION 12859447967, not started
  41. MySQL thread id 12087810, OS thread handle 0x7f7805a05700, query id 482844275 localhost mobi_website
  42. ---TRANSACTION 12859447438, not started
  43. MySQL thread id 12087809, OS thread handle 0x7f7804c4f700, query id 482843799 localhost myinstar_ranker
  44. ---TRANSACTION 12859447445, not started
  45. MySQL thread id 12087808, OS thread handle 0x7f7804ac9700, query id 482843807 localhost myinstar_ranker
  46. ---TRANSACTION 12859447362, not started
  47. MySQL thread id 12087807, OS thread handle 0x7f7824429700, query id 482843727 localhost myinstar_ranker
  48. ---TRANSACTION 12859447344, not started
  49. MySQL thread id 12087806, OS thread handle 0x7f782c058700, query id 482843712 localhost myinstar_ranker
  50. ---TRANSACTION 12859447318, not started
  51. MySQL thread id 12087805, OS thread handle 0x7f77f73cf700, query id 482843696 localhost myinstar_ranker
  52. ---TRANSACTION 12859447981, not started
  53. MySQL thread id 12087803, OS thread handle 0x7f78062e8700, query id 482844289 localhost myinstar_ranker
  54. ---TRANSACTION 12859447236, not started
  55. MySQL thread id 12087802, OS thread handle 0x7f77f7eba700, query id 482843623 localhost myinstar_ranker
  56. ---TRANSACTION 12859447441, not started
  57. MySQL thread id 12087801, OS thread handle 0x7f78051a4700, query id 482843802 localhost myinstar_ranker
  58. ---TRANSACTION 12859447524, not started
  59. MySQL thread id 12087800, OS thread handle 0x7f782c0da700, query id 482843881 localhost myinstar_ranker
  60. ---TRANSACTION 12859447225, not started
  61. MySQL thread id 12087799, OS thread handle 0x7f77f5df9700, query id 482843612 localhost myinstar_ranker
  62. ---TRANSACTION 12859447475, not started
  63. MySQL thread id 12087798, OS thread handle 0x7f77f7df7700, query id 482843838 localhost myinstar_ranker
  64. ---TRANSACTION 12859447166, not started
  65. MySQL thread id 12087797, OS thread handle 0x7f78061e4700, query id 482843564 localhost myinstar_ranker
  66. ---TRANSACTION 12859447134, not started
  67. MySQL thread id 12087796, OS thread handle 0x7f77f5d36700, query id 482843534 localhost myinstar_ranker
  68. ---TRANSACTION 12859447558, not started
  69. MySQL thread id 12087795, OS thread handle 0x7f77f6f7e700, query id 482843912 localhost myinstar_ranker
  70. ---TRANSACTION 12859448093, not started
  71. MySQL thread id 12087794, OS thread handle 0x7f77f6209700, query id 482844399 localhost myinstar_ranker
  72. ---TRANSACTION 12859446986, not started
  73. MySQL thread id 12087793, OS thread handle 0x7f77f6aab700, query id 482843402 localhost myinstar_ranker
  74. ---TRANSACTION 12859446960, not started
  75. MySQL thread id 12087792, OS thread handle 0x7f780609f700, query id 482843381 localhost myinstar_ranker
  76. ---TRANSACTION 12859446912, not started
  77. MySQL thread id 12087790, OS thread handle 0x7f780436c700, query id 482843340 localhost myinstar_ranker
  78. ---TRANSACTION 12859446909, not started
  79. MySQL thread id 12087789, OS thread handle 0x7f7824672700, query id 482843336 localhost myinstar_ranker
  80. ---TRANSACTION 12859446882, not started
  81. MySQL thread id 12087788, OS thread handle 0x7f77f5db8700, query id 482843311 localhost myinstar_ranker
  82. ---TRANSACTION 12859446840, not started
  83. MySQL thread id 12087787, OS thread handle 0x7f7804227700, query id 482843271 localhost myinstar_ranker
  84. ---TRANSACTION 12859446826, not started
  85. MySQL thread id 12087786, OS thread handle 0x7f7804060700, query id 482843258 localhost myinstar_ranker
  86. ---TRANSACTION 12859446828, not started
  87. MySQL thread id 12087785, OS thread handle 0x7f78052a8700, query id 482843260 localhost myinstar_ranker
  88. ---TRANSACTION 12859446851, not started
  89. MySQL thread id 12087784, OS thread handle 0x7f78051e5700, query id 482843281 localhost myinstar_ranker
  90. ---TRANSACTION 12859448077, not started
  91. MySQL thread id 12087783, OS thread handle 0x7f7805dd4700, query id 482844381 localhost myinstar_ranker
  92. ---TRANSACTION 12859446200, not started
  93. MySQL thread id 12087781, OS thread handle 0x7f782c21f700, query id 482842680 localhost myinstar_ranker
  94. ---TRANSACTION 12859444589, not started
  95. MySQL thread id 12087773, OS thread handle 0x7f77f6083700, query id 482841228 localhost myinstar_ranker
  96. ---TRANSACTION 12859444489, not started
  97. MySQL thread id 12087771, OS thread handle 0x7f77f5822700, query id 482841134 localhost myinstar_ranker
  98. ---TRANSACTION 12859444439, not started
  99. MySQL thread id 12087770, OS thread handle 0x7f77f6619700, query id 482841091 localhost myinstar_ranker
  100. ---TRANSACTION 12859444460, not started
  101. MySQL thread id 12087769, OS thread handle 0x7f77f7451700, query id 482841110 localhost myinstar_ranker
  102. ---TRANSACTION 12859447683, not started
  103. MySQL thread id 12087768, OS thread handle 0x7f78040a1700, query id 482844024 localhost myinstar_ranker
  104. ---TRANSACTION 12859447979, not started
  105. MySQL thread id 12087767, OS thread handle 0x7f77f6ebb700, query id 482844287 localhost myinstar_ranker
  106. ---TRANSACTION 12859447187, not started
  107. MySQL thread id 12087765, OS thread handle 0x7f77f5c32700, query id 482843582 localhost myinstar_ranker
  108. ---TRANSACTION 12859447079, not started
  109. MySQL thread id 12087764, OS thread handle 0x7f7806121700, query id 482843485 localhost myinstar_ranker
  110. ---TRANSACTION 12859444204, not started
  111. MySQL thread id 12087760, OS thread handle 0x7f7806676700, query id 482840886 localhost myinstar_ranker
  112. ---TRANSACTION 12859447582, not started
  113. MySQL thread id 12087759, OS thread handle 0x7f7805163700, query id 482843936 localhost myinstar_ranker
  114. ---TRANSACTION 12859444205, not started
  115. MySQL thread id 12087758, OS thread handle 0x7f77f6fbf700, query id 482840887 localhost myinstar_ranker
  116. ---TRANSACTION 12859448020, not started
  117. MySQL thread id 12087756, OS thread handle 0x7f7806329700, query id 482844333 localhost myinstar_ranker
  118. ---TRANSACTION 12859447103, not started
  119. MySQL thread id 12087749, OS thread handle 0x7f78066f8700, query id 482843507 localhost myinstar_ranker
  120. ---TRANSACTION 12859447852, not started
  121. MySQL thread id 12087746, OS thread handle 0x7f77f71c7700, query id 482844177 localhost myinstar_ranker
  122. ---TRANSACTION 12859447799, not started
  123. MySQL thread id 12087745, OS thread handle 0x7f780473b700, query id 482844131 localhost myinstar_ranker
  124. ---TRANSACTION 12859448079, not started
  125. MySQL thread id 12087744, OS thread handle 0x7f78042ea700, query id 482844384 localhost myinstar_ranker
  126. ---TRANSACTION 12859446719, not started
  127. MySQL thread id 12087737, OS thread handle 0x7f7805a87700, query id 482843167 localhost myinstar_ranker
  128. ---TRANSACTION 12859447081, not started
  129. MySQL thread id 12087736, OS thread handle 0x7f78246f4700, query id 482843488 localhost myinstar_ranker
  130. ---TRANSACTION 12859446759, not started
  131. MySQL thread id 12087735, OS thread handle 0x7f77f7410700, query id 482843200 localhost myinstar_ranker
  132. ---TRANSACTION 12859447608, not started
  133. MySQL thread id 12087733, OS thread handle 0x7f780601d700, query id 482843961 localhost myinstar_ranker
  134. ---TRANSACTION 12859441532, not started
  135. MySQL thread id 12087726, OS thread handle 0x7f780546f700, query id 482838476 localhost myinstar_ranker
  136. ---TRANSACTION 12859447245, not started
  137. MySQL thread id 12087722, OS thread handle 0x7f7805e97700, query id 482843631 localhost myinstar_ranker
  138. ---TRANSACTION 12859441516, not started
  139. MySQL thread id 12087721, OS thread handle 0x7f782c2a1700, query id 482838460 localhost myinstar_ranker
  140. ---TRANSACTION 12859447882, not started
  141. MySQL thread id 12087719, OS thread handle 0x7f77f7000700, query id 482844200 localhost myinstar_ranker
  142. ---TRANSACTION 12859447167, not started
  143. MySQL thread id 12087718, OS thread handle 0x7f7804880700, query id 482843565 localhost myinstar_ranker
  144. ---TRANSACTION 12859447990, not started
  145. MySQL thread id 12087717, OS thread handle 0x7f7804d12700, query id 482844298 localhost myinstar_ranker
  146. ---TRANSACTION 12859448031, not started
  147. MySQL thread id 12087715, OS thread handle 0x7f77f5b2e700, query id 482844344 localhost myinstar_ranker
  148. ---TRANSACTION 12859442804, not started
  149. MySQL thread id 12087714, OS thread handle 0x7f7805b4a700, query id 482839645 localhost myinstar_ranker
  150. ---TRANSACTION 12859440885, not started
  151. MySQL thread id 12087713, OS thread handle 0x7f77f6e7a700, query id 482837898 localhost myinstar_ranker
  152. ---TRANSACTION 12859447194, not started
  153. MySQL thread id 12087712, OS thread handle 0x7f77f7659700, query id 482843588 localhost myinstar_ranker
  154. ---TRANSACTION 12859448068, not started
  155. MySQL thread id 12087708, OS thread handle 0x7f77f7492700, query id 482844376 localhost myinstar_ranker
  156. ---TRANSACTION 12859446545, not started
  157. MySQL thread id 12087707, OS thread handle 0x7f7806635700, query id 482843011 localhost myinstar_ranker
  158. ---TRANSACTION 12859440634, not started
  159. MySQL thread id 12087704, OS thread handle 0x7f78063ec700, query id 482837691 localhost myinstar_ranker
  160. ---TRANSACTION 12859447693, not started
  161. MySQL thread id 12087703, OS thread handle 0x7f77f6042700, query id 482844035 localhost myinstar_ranker
  162. ---TRANSACTION 12859447668, not started
  163. MySQL thread id 12087702, OS thread handle 0x7f78043ee700, query id 482844011 localhost myinstar_ranker
  164. ---TRANSACTION 12859440492, not started
  165. MySQL thread id 12087701, OS thread handle 0x7f7805d52700, query id 482837559 localhost myinstar_ranker
  166. ---TRANSACTION 12859446713, not started
  167. MySQL thread id 12087700, OS thread handle 0x7f7805226700, query id 482843161 localhost myinstar_ranker
  168. ---TRANSACTION 12859448021, not started
  169. MySQL thread id 12087699, OS thread handle 0x7f77f6411700, query id 482844334 localhost myinstar_ranker
  170. ---TRANSACTION 12859448056, not started
  171. MySQL thread id 12087698, OS thread handle 0x7f77f5f7f700, query id 482844364 localhost myinstar_ranker
  172. ---TRANSACTION 12859446659, not started
  173. MySQL thread id 12087696, OS thread handle 0x7f782c099700, query id 482843108 localhost myinstar_ranker
  174. ---TRANSACTION 12859444556, not started
  175. MySQL thread id 12087694, OS thread handle 0x7f78065f4700, query id 482841198 localhost myinstar_ranker
  176. ---TRANSACTION 12859447424, not started
  177. MySQL thread id 12087692, OS thread handle 0x7f77f63d0700, query id 482843789 localhost myinstar_ranker
  178. ---TRANSACTION 12859447389, not started
  179. MySQL thread id 12087684, OS thread handle 0x7f780432b700, query id 482843750 localhost myinstar_ranker
  180. ---TRANSACTION 12859446878, not started
  181. MySQL thread id 12087683, OS thread handle 0x7f78067fc700, query id 482843306 localhost myinstar_ranker
  182. ---TRANSACTION 12859448013, not started
  183. MySQL thread id 12087682, OS thread handle 0x7f77f6187700, query id 482844321 localhost myinstar_ranker
  184. ---TRANSACTION 12859448062, not started
  185. MySQL thread id 12087676, OS thread handle 0x7f78245f0700, query id 482844370 localhost myinstar_ranker
  186. ---TRANSACTION 12859439267, not started
  187. MySQL thread id 12087672, OS thread handle 0x7f7804a47700, query id 482836468 localhost myinstar_ranker
  188. ---TRANSACTION 12859447630, not started
  189. MySQL thread id 12087671, OS thread handle 0x7f77f69e8700, query id 482843982 localhost myinstar_ranker
  190. ---TRANSACTION 12859447817, not started
  191. MySQL thread id 12087663, OS thread handle 0x7f77f64d4700, query id 482844149 localhost myinstar_ranker
  192. ---TRANSACTION 12859447853, not started
  193. MySQL thread id 12087658, OS thread handle 0x7f77f7596700, query id 482844178 localhost myinstar_ranker
  194. ---TRANSACTION 12859448058, not started
  195. MySQL thread id 12087652, OS thread handle 0x7f77f6e39700, query id 482844366 localhost myinstar_ranker
  196. ---TRANSACTION 12859447552, not started
  197. MySQL thread id 12087647, OS thread handle 0x7f77f77df700, query id 482843906 localhost myinstar_ranker
  198. ---TRANSACTION 12859447182, not started
  199. MySQL thread id 12087640, OS thread handle 0x7f77f60c4700, query id 482843577 localhost myinstar_ranker
  200. ---TRANSACTION 12859447421, not started
  201. MySQL thread id 12087638, OS thread handle 0x7f7806572700, query id 482843787 localhost myinstar_ranker
  202. ---TRANSACTION 12859448078, not started
  203. MySQL thread id 12087633, OS thread handle 0x7f780501e700, query id 482844383 localhost myinstar_ranker
  204. ---TRANSACTION 12859446847, not started
  205. MySQL thread id 12087632, OS thread handle 0x7f77f679f700, query id 482843277 localhost myinstar_ranker
  206. ---TRANSACTION 12859446636, not started
  207. MySQL thread id 12087626, OS thread handle 0x7f782405a700, query id 482843086 localhost myinstar_ranker
  208. ---TRANSACTION 12859448011, not started
  209. MySQL thread id 12087625, OS thread handle 0x7f780505f700, query id 482844319 localhost myinstar_ranker
  210. ---TRANSACTION 12859446854, not started
  211. MySQL thread id 12087618, OS thread handle 0x7f782411d700, query id 482843284 localhost myinstar_ranker
  212. ---TRANSACTION 12859436194, not started
  213. MySQL thread id 12087610, OS thread handle 0x7f7804e98700, query id 482833288 localhost myinstar_ranker
  214. ---TRANSACTION 12859445723, not started
  215. MySQL thread id 12087609, OS thread handle 0x7f7804268700, query id 482842241 localhost myinstar_ranker
  216. ---TRANSACTION 12859436269, not started
  217. MySQL thread id 12087598, OS thread handle 0x7f77f6df8700, query id 482833355 localhost myinstar_ranker
  218. ---TRANSACTION 12859446525, not started
  219. MySQL thread id 12087597, OS thread handle 0x7f77f675e700, query id 482842992 localhost myinstar_ranker
  220. ---TRANSACTION 12859447978, not started
  221. MySQL thread id 12087593, OS thread handle 0x7f77f57e1700, query id 482844286 localhost myinstar_ranker
  222. ---TRANSACTION 12859448094, not started
  223. MySQL thread id 12087586, OS thread handle 0x7f780536b700, query id 482844400 localhost myinstar_ranker
  224. ---TRANSACTION 12859435338, not started
  225. MySQL thread id 12087583, OS thread handle 0x7f78050a0700, query id 482832478 localhost myinstar_ranker
  226. ---TRANSACTION 12859447410, not started
  227. MySQL thread id 12087580, OS thread handle 0x7f782c3e6700, query id 482843776 localhost myinstar_ranker
  228. ---TRANSACTION 12859447820, not started
  229. MySQL thread id 12087579, OS thread handle 0x7f77f5fc0700, query id 482844152 localhost myinstar_ranker
  230. ---TRANSACTION 12859447160, not started
  231. MySQL thread id 12087564, OS thread handle 0x7f77f6493700, query id 482843559 localhost myinstar_ranker
  232. ---TRANSACTION 12859447566, not started
  233. MySQL thread id 12087562, OS thread handle 0x7f7804a88700, query id 482843920 localhost myinstar_ranker
  234. ---TRANSACTION 12859447691, not started
  235. MySQL thread id 12087559, OS thread handle 0x7f78057bc700, query id 482844031 localhost myinstar_ranker
  236. ---TRANSACTION 12859446755, not started
  237. MySQL thread id 12087556, OS thread handle 0x7f77f6452700, query id 482843196 localhost myinstar_ranker
  238. ---TRANSACTION 12859447746, not started
  239. MySQL thread id 12087553, OS thread handle 0x7f77f6b6e700, query id 482844081 localhost myinstar_ranker
  240. ---TRANSACTION 12859447141, not started
  241. MySQL thread id 12087552, OS thread handle 0x7f78246b3700, query id 482843541 localhost myinstar_ranker
  242. ---TRANSACTION 12859447993, not started
  243. MySQL thread id 12087546, OS thread handle 0x7f77f5b6f700, query id 482844301 localhost myinstar_ranker
  244. ---TRANSACTION 12859447605, not started
  245. MySQL thread id 12087544, OS thread handle 0x7f77f6efc700, query id 482843958 localhost myinstar_ranker
  246. ---TRANSACTION 12859448040, not started
  247. MySQL thread id 12087542, OS thread handle 0x7f780477c700, query id 482844353 localhost myinstar_ranker
  248. ---TRANSACTION 12859448057, not started
  249. MySQL thread id 12087541, OS thread handle 0x7f77f7e38700, query id 482844365 localhost myinstar_ranker
  250. ---TRANSACTION 12859448060, not started
  251. MySQL thread id 12087538, OS thread handle 0x7f77f72cb700, query id 482844368 localhost myinstar_ranker
  252. ---TRANSACTION 12859447450, not started
  253. MySQL thread id 12087536, OS thread handle 0x7f77f7924700, query id 482843814 localhost myinstar_ranker
  254. ---TRANSACTION 12859445911, not started
  255. MySQL thread id 12087523, OS thread handle 0x7f77f6966700, query id 482842410 localhost myinstar_ranker
  256. ---TRANSACTION 12859447749, not started
  257. MySQL thread id 12087519, OS thread handle 0x7f78243a7700, query id 482844084 localhost myinstar_ranker
  258. ---TRANSACTION 12859432478, not started
  259. MySQL thread id 12087515, OS thread handle 0x7f780483f700, query id 482829843 localhost myinstar_ranker
  260. ---TRANSACTION 12859447534, not started
  261. MySQL thread id 12087513, OS thread handle 0x7f77f7514700, query id 482843890 localhost myinstar_ranker
  262. ---TRANSACTION 12859448036, not started
  263. MySQL thread id 12087512, OS thread handle 0x7f7804943700, query id 482844349 localhost myinstar_ranker
  264. ---TRANSACTION 12859447488, not started
  265. MySQL thread id 12087510, OS thread handle 0x7f882d564700, query id 482843851 localhost myinstar_ranker
  266. ---TRANSACTION 12859447406, not started
  267. MySQL thread id 12087509, OS thread handle 0x7f7805d11700, query id 482843772 localhost myinstar_ranker
  268. ---TRANSACTION 12859448030, not started
  269. MySQL thread id 12087505, OS thread handle 0x7f7804984700, query id 482844343 localhost myinstar_ranker
  270. ---TRANSACTION 12859447270, not started
  271. MySQL thread id 12087504, OS thread handle 0x7f78041e6700, query id 482843651 localhost myinstar_ranker
  272. ---TRANSACTION 12859447804, not started
  273. MySQL thread id 12087498, OS thread handle 0x7f77f5cf5700, query id 482844136 localhost myinstar_ranker
  274. ---TRANSACTION 12859431982, not started
  275. MySQL thread id 12087495, OS thread handle 0x7f7824776700, query id 482829402 localhost myinstar_ranker
  276. ---TRANSACTION 12859447310, not started
  277. MySQL thread id 12087494, OS thread handle 0x7f77f68a3700, query id 482843688 localhost myinstar_ranker
  278. ---TRANSACTION 12859448032, not started
  279. MySQL thread id 12087493, OS thread handle 0x7f77f7bef700, query id 482844345 localhost myinstar_ranker
  280. ---TRANSACTION 12859447188, not started
  281. MySQL thread id 12087491, OS thread handle 0x7f78057fd700, query id 482843583 localhost myinstar_ranker
  282. ---TRANSACTION 12859448065, not started
  283. MySQL thread id 12087479, OS thread handle 0x7f7804e16700, query id 482844373 localhost myinstar_ranker
  284. ---TRANSACTION 12859448018, not started
  285. MySQL thread id 12087478, OS thread handle 0x7f78058c0700, query id 482844331 localhost myinstar_ranker
  286. ---TRANSACTION 12859447682, not started
  287. MySQL thread id 12087466, OS thread handle 0x7f78053ed700, query id 482844022 localhost myinstar_ranker
  288. ---TRANSACTION 12859447244, not started
  289. MySQL thread id 12087465, OS thread handle 0x7f77f734d700, query id 482843630 localhost myinstar_ranker
  290. ---TRANSACTION 12859446676, not started
  291. MySQL thread id 12087464, OS thread handle 0x7f78059c4700, query id 482843124 localhost myinstar_ranker
  292. ---TRANSACTION 12859440369, not started
  293. MySQL thread id 12087462, OS thread handle 0x7f882d523700, query id 482837453 localhost myinstar_ranker
  294. ---TRANSACTION 12859430509, not started
  295. MySQL thread id 12087460, OS thread handle 0x7f7805983700, query id 482828098 localhost myinstar_ranker
  296. ---TRANSACTION 12859447717, not started
  297. MySQL thread id 12087447, OS thread handle 0x7f77f7aeb700, query id 482844054 localhost myinstar_ranker
  298. ---TRANSACTION 12859430063, not started
  299. MySQL thread id 12087444, OS thread handle 0x7f77f67e0700, query id 482827702 localhost myinstar_ranker
  300. ---TRANSACTION 12859445948, not started
  301. MySQL thread id 12087442, OS thread handle 0x7f7805f5a700, query id 482842446 localhost myinstar_ranker
  302. ---TRANSACTION 12859447976, not started
  303. MySQL thread id 12087439, OS thread handle 0x7f7804d53700, query id 482844284 localhost myinstar_ranker
  304. ---TRANSACTION 12859447687, not started
  305. MySQL thread id 12087431, OS thread handle 0x7f7805532700, query id 482844027 localhost myinstar_ranker
  306. ---TRANSACTION 12859446496, not started
  307. MySQL thread id 12087430, OS thread handle 0x7f77f70c3700, query id 482842970 localhost myinstar_ranker
  308. ---TRANSACTION 12859448063, not started
  309. MySQL thread id 12087426, OS thread handle 0x7f7804902700, query id 482844371 localhost myinstar_ranker
  310. ---TRANSACTION 12859447772, not started
  311. MySQL thread id 12087425, OS thread handle 0x7f78064f0700, query id 482844107 localhost myinstar_ranker
  312. ---TRANSACTION 12859445746, not started
  313. MySQL thread id 12087422, OS thread handle 0x7f78244ab700, query id 482842260 localhost myinstar_ranker
  314. ---TRANSACTION 12859445750, not started
  315. MySQL thread id 12087417, OS thread handle 0x7f77f6c31700, query id 482842264 localhost myinstar_ranker
  316. ---TRANSACTION 12859446971, not started
  317. MySQL thread id 12087415, OS thread handle 0x7f77f6821700, query id 482843391 localhost myinstar_ranker
  318. ---TRANSACTION 12859447308, not started
  319. MySQL thread id 12087413, OS thread handle 0x7f77f7965700, query id 482843686 localhost myinstar_ranker
  320. ---TRANSACTION 12859445896, not started
  321. MySQL thread id 12087412, OS thread handle 0x7f7805f9b700, query id 482842394 localhost myinstar_ranker
  322. ---TRANSACTION 12859447580, not started
  323. MySQL thread id 12087409, OS thread handle 0x7f77f7a69700, query id 482843934 localhost myinstar_ranker
  324. ---TRANSACTION 12859446795, not started
  325. MySQL thread id 12087407, OS thread handle 0x7f78247f8700, query id 482843228 localhost myinstar_ranker
  326. ---TRANSACTION 12859446770, not started
  327. MySQL thread id 12087405, OS thread handle 0x7f77f771c700, query id 482843210 localhost myinstar_ranker
  328. ---TRANSACTION 12859447786, not started
  329. MySQL thread id 12087402, OS thread handle 0x7f78241e0700, query id 482844117 localhost myinstar_ranker
  330. ---TRANSACTION 12859447886, not started
  331. MySQL thread id 12087398, OS thread handle 0x7f77f5cb4700, query id 482844205 localhost myinstar_ranker
  332. ---TRANSACTION 12859446652, not started
  333. MySQL thread id 12087396, OS thread handle 0x7f77f74d3700, query id 482843101 localhost myinstar_ranker
  334. ---TRANSACTION 12859447119, not started
  335. MySQL thread id 12087392, OS thread handle 0x7f78049c5700, query id 482843519 localhost myinstar_ranker
  336. ---TRANSACTION 12859446904, not started
  337. MySQL thread id 12087379, OS thread handle 0x7f78041a5700, query id 482843332 localhost myinstar_ranker
  338. ---TRANSACTION 12859446917, not started
  339. MySQL thread id 12087377, OS thread handle 0x7f78067bb700, query id 482843343 localhost myinstar_ranker
  340. ---TRANSACTION 12859448067, not started
  341. MySQL thread id 12087372, OS thread handle 0x7f77f7db6700, query id 482844375 localhost myinstar_ranker
  342. ---TRANSACTION 12859447681, not started
  343. MySQL thread id 12087370, OS thread handle 0x7f780636a700, query id 482844021 localhost myinstar_ranker
  344. ---TRANSACTION 12859443849, not started
  345. MySQL thread id 12087368, OS thread handle 0x7f7804cd1700, query id 482840559 localhost myinstar_ranker
  346. ---TRANSACTION 12859443328, not started
  347. MySQL thread id 12087364, OS thread handle 0x7f78242e4700, query id 482840109 localhost myinstar_ranker
  348. ---TRANSACTION 12859446597, not started
  349. MySQL thread id 12087363, OS thread handle 0x7f7806739700, query id 482843056 localhost myinstar_ranker
  350. ---TRANSACTION 12859447071, not started
  351. MySQL thread id 12087362, OS thread handle 0x7f77f7d75700, query id 482843478 localhost myinstar_ranker
  352. ---TRANSACTION 12859443318, not started
  353. MySQL thread id 12087358, OS thread handle 0x7f77f61c8700, query id 482840100 localhost myinstar_ranker
  354. ---TRANSACTION 12859447759, not started
  355. MySQL thread id 12087355, OS thread handle 0x7f77f7555700, query id 482844092 localhost myinstar_ranker
  356. ---TRANSACTION 12859426714, not started
  357. MySQL thread id 12087354, OS thread handle 0x7f782c364700, query id 482824674 localhost myinstar_ranker
  358. ---TRANSACTION 12859447941, not started
  359. MySQL thread id 12087348, OS thread handle 0x7f7804637700, query id 482844248 localhost myinstar_ranker
  360. ---TRANSACTION 12859447588, not started
  361. MySQL thread id 12087347, OS thread handle 0x7f77f6556700, query id 482843941 localhost myinstar_ranker
  362. ---TRANSACTION 12859447391, not started
  363. MySQL thread id 12087334, OS thread handle 0x7f78243e8700, query id 482843752 localhost myinstar_ranker
  364. ---TRANSACTION 12859447554, not started
  365. MySQL thread id 12087328, OS thread handle 0x7f7804f5b700, query id 482843908 localhost myinstar_ranker
  366. ---TRANSACTION 12859447463, not started
  367. MySQL thread id 12087323, OS thread handle 0x7f782452d700, query id 482843827 localhost myinstar_ranker
  368. ---TRANSACTION 12859447359, not started
  369. MySQL thread id 12087312, OS thread handle 0x7f7806162700, query id 482843725 localhost myinstar_ranker
  370. ---TRANSACTION 12859447774, not started
  371. MySQL thread id 12087288, OS thread handle 0x7f7804b4b700, query id 482844109 localhost myinstar_ranker
  372. ---TRANSACTION 12859447303, not started
  373. MySQL thread id 12087268, OS thread handle 0x7f77f6c72700, query id 482843682 localhost myinstar_ranker
  374. ---TRANSACTION 12859446524, not started
  375. MySQL thread id 12087267, OS thread handle 0x7f78062a7700, query id 482842991 localhost myinstar_ranker
  376. ---TRANSACTION 12859447378, not started
  377. MySQL thread id 12087259, OS thread handle 0x7f7804574700, query id 482843741 localhost myinstar_ranker
  378. ---TRANSACTION 12859447292, not started
  379. MySQL thread id 12087256, OS thread handle 0x7f78052e9700, query id 482843673 localhost myinstar_ranker
  380. ---TRANSACTION 12859446825, not started
  381. MySQL thread id 12087254, OS thread handle 0x7f780542e700, query id 482843257 localhost myinstar_ranker
  382. ---TRANSACTION 12859447854, not started
  383. MySQL thread id 12087253, OS thread handle 0x7f77f7618700, query id 482844179 localhost myinstar_ranker
  384. ---TRANSACTION 12859445814, not started
  385. MySQL thread id 12087251, OS thread handle 0x7f7804e57700, query id 482842322 localhost myinstar_ranker
  386. ---TRANSACTION 12859446677, not started
  387. MySQL thread id 12087248, OS thread handle 0x7f77f6862700, query id 482843125 localhost myinstar_ranker
  388. ---TRANSACTION 12859447766, not started
  389. MySQL thread id 12087247, OS thread handle 0x7f77f7cb2700, query id 482844099 localhost myinstar_ranker
  390. ---TRANSACTION 12859447467, not started
  391. MySQL thread id 12087236, OS thread handle 0x7f7805bcc700, query id 482843831 localhost myinstar_ranker
  392. ---TRANSACTION 12859447260, not started
  393. MySQL thread id 12087234, OS thread handle 0x7f7805cd0700, query id 482843643 localhost myinstar_ranker
  394. ---TRANSACTION 12859447883, not started
  395. MySQL thread id 12087224, OS thread handle 0x7f77f62cc700, query id 482844202 localhost myinstar_ranker
  396. ---TRANSACTION 12859438452, not started
  397. MySQL thread id 12087206, OS thread handle 0x7f77f7186700, query id 482835708 localhost myinstar_ranker
  398. ---TRANSACTION 12859447865, not started
  399. MySQL thread id 12087183, OS thread handle 0x7f78045f6700, query id 482844189 localhost myinstar_ranker
  400. ---TRANSACTION 12859448039, not started
  401. MySQL thread id 12087166, OS thread handle 0x7f77f78e3700, query id 482844352 localhost myinstar_ranker
  402. ---TRANSACTION 12859444559, not started
  403. MySQL thread id 12087159, OS thread handle 0x7f780605e700, query id 482841201 localhost myinstar_ranker
  404. ---TRANSACTION 12859447286, not started
  405. MySQL thread id 12087153, OS thread handle 0x7f77f6a29700, query id 482843668 localhost myinstar_ranker
  406. ---TRANSACTION 12859448029, not started
  407. MySQL thread id 12087151, OS thread handle 0x7f77f669b700, query id 482844342 localhost myinstar_ranker
  408. ---TRANSACTION 12859448037, not started
  409. MySQL thread id 12087139, OS thread handle 0x7f77f6d35700, query id 482844350 localhost myinstar_ranker
  410. ---TRANSACTION 12859441570, not started
  411. MySQL thread id 12087124, OS thread handle 0x7f782c11b700, query id 482838507 localhost myinstar_ranker
  412. ---TRANSACTION 12859447491, not started
  413. MySQL thread id 12087114, OS thread handle 0x7f77f78a2700, query id 482843854 localhost myinstar_ranker
  414. ---TRANSACTION 12859447743, not started
  415. MySQL thread id 12087108, OS thread handle 0x7f77f5926700, query id 482844078 localhost myinstar_ranker
  416. ---TRANSACTION 12859447416, not started
  417. MySQL thread id 12087107, OS thread handle 0x7f77f7bae700, query id 482843782 localhost myinstar_ranker
  418. ---TRANSACTION 12859440371, not started
  419. MySQL thread id 12087103, OS thread handle 0x7f77f6d76700, query id 482837455 localhost myinstar_ranker
  420. ---TRANSACTION 12859447497, not started
  421. MySQL thread id 12087094, OS thread handle 0x7f77f671d700, query id 482843860 localhost myinstar_ranker
  422. ---TRANSACTION 12859447923, not started
  423. MySQL thread id 12087092, OS thread handle 0x7f7805e56700, query id 482844236 localhost myinstar_ranker
  424. ---TRANSACTION 12859447971, not started
  425. MySQL thread id 12087090, OS thread handle 0x7f77f738e700, query id 482844279 localhost myinstar_ranker
  426. ---TRANSACTION 12859447986, not started
  427. MySQL thread id 12087083, OS thread handle 0x7f7804b8c700, query id 482844294 localhost myinstar_ranker
  428. ---TRANSACTION 12859448066, not started
  429. MySQL thread id 12087073, OS thread handle 0x7f7804ed9700, query id 482844374 localhost myinstar_ranker
  430. ---TRANSACTION 12859447793, not started
  431. MySQL thread id 12087071, OS thread handle 0x7f7805ac8700, query id 482844125 localhost myinstar_ranker
  432. ---TRANSACTION 12859447871, not started
  433. MySQL thread id 12087069, OS thread handle 0x7f7805c4e700, query id 482844193 localhost myinstar_ranker
  434. ---TRANSACTION 12859447522, not started
  435. MySQL thread id 12087009, OS thread handle 0x7f780442f700, query id 482843879 localhost myinstar_ranker
  436. ---TRANSACTION 12859445577, not started
  437. MySQL thread id 12087007, OS thread handle 0x7f77f59a8700, query id 482842113 localhost myinstar_ranker
  438. ---TRANSACTION 12859447812, not started
  439. MySQL thread id 12086982, OS thread handle 0x7f77f5967700, query id 482844144 localhost myinstar_ranker
  440. ---TRANSACTION 12859445780, not started
  441. MySQL thread id 12086974, OS thread handle 0x7f78042a9700, query id 482842294 localhost myinstar_ranker
  442. ---TRANSACTION 12859447295, not started
  443. MySQL thread id 12086954, OS thread handle 0x7f77f5863700, query id 482843676 localhost myinstar_ranker
  444. ---TRANSACTION 12859443233, not started
  445. MySQL thread id 12086931, OS thread handle 0x7f77f7fff700, query id 482840023 localhost myinstar_ranker
  446. ---TRANSACTION 12859448015, not started
  447. MySQL thread id 12086871, OS thread handle 0x7f78242a3700, query id 482844323 localhost myinstar_ranker
  448. ---TRANSACTION 12859447798, not started
  449. MySQL thread id 12086844, OS thread handle 0x7f77f7f7d700, query id 482844130 localhost myinstar_ranker
  450. ---TRANSACTION 12859447942, not started
  451. MySQL thread id 12086834, OS thread handle 0x7f7805d93700, query id 482844249 localhost myinstar_ranker
  452. ---TRANSACTION 12859447835, not started
  453. MySQL thread id 12086809, OS thread handle 0x7f77f79a6700, query id 482844164 localhost myinstar_ranker
  454. ---TRANSACTION 12859436239, not started
  455. MySQL thread id 12086797, OS thread handle 0x7f77f6146700, query id 482833328 localhost myinstar_ranker
  456. ---TRANSACTION 12859439365, not started
  457. MySQL thread id 12086766, OS thread handle 0x7f78244ec700, query id 482836564 localhost myinstar_ranker
  458. ---TRANSACTION 12859447581, not started
  459. MySQL thread id 12086739, OS thread handle 0x7f77f779e700, query id 482843935 localhost myinstar_ranker
  460. ---TRANSACTION 12859447302, not started
  461. MySQL thread id 12086691, OS thread handle 0x7f77f7820700, query id 482843681 localhost myinstar_ranker
  462. ---TRANSACTION 12859430565, not started
  463. MySQL thread id 12086681, OS thread handle 0x7f77f5bb0700, query id 482828148 localhost myinstar_ranker
  464. ---TRANSACTION 12859447726, not started
  465. MySQL thread id 12086659, OS thread handle 0x7f7805942700, query id 482844062 localhost myinstar_ranker
  466. ---TRANSACTION 12859447712, not started
  467. MySQL thread id 12086648, OS thread handle 0x7f77f58e5700, query id 482844050 localhost myinstar_ranker
  468. ---TRANSACTION 12859447576, not started
  469. MySQL thread id 12086554, OS thread handle 0x7f77f728a700, query id 482843930 localhost myinstar_ranker
  470. ---TRANSACTION 12859446765, not started
  471. MySQL thread id 12086539, OS thread handle 0x7f7824631700, query id 482843206 localhost myinstar_ranker
  472. ---TRANSACTION 12859447751, not started
  473. MySQL thread id 12086538, OS thread handle 0x7f7806225700, query id 482844086 localhost myinstar_ranker
  474. ---TRANSACTION 12859447590, not started
  475. MySQL thread id 12086501, OS thread handle 0x7f782c323700, query id 482843943 localhost myinstar_ranker
  476. ---TRANSACTION 12859447358, not started
  477. MySQL thread id 12086492, OS thread handle 0x7f7804164700, query id 482843724 localhost myinstar_ranker
  478. ---TRANSACTION 12859437609, not started
  479. MySQL thread id 12086461, OS thread handle 0x7f78054f1700, query id 482834599 localhost myinstar_ranker
  480. ---TRANSACTION 12859447650, not started
  481. MySQL thread id 12086445, OS thread handle 0x7f77f7145700, query id 482843999 localhost myinstar_ranker
  482. ---TRANSACTION 12859445771, not started
  483. MySQL thread id 12086425, OS thread handle 0x7f780642d700, query id 482842285 localhost myinstar_ranker
  484. ---TRANSACTION 12859448089, not started
  485. MySQL thread id 12086405, OS thread handle 0x7f7804123700, query id 482844394 localhost myinstar_ranker
  486. ---TRANSACTION 12859438475, not started
  487. MySQL thread id 12086332, OS thread handle 0x7f78043ad700, query id 482835729 localhost myinstar_ranker
  488. ---TRANSACTION 12859431030, not started
  489. MySQL thread id 12086292, OS thread handle 0x7f7805ed8700, query id 482828542 localhost myinstar_ranker
  490. ---TRANSACTION 12859447684, not started
  491. MySQL thread id 12086266, OS thread handle 0x7f7804dd5700, query id 482844025 localhost myinstar_ranker
  492. ---TRANSACTION 12859447731, not started
  493. MySQL thread id 12086239, OS thread handle 0x7f77f7f3c700, query id 482844066 localhost myinstar_ranker
  494. ---TRANSACTION 12859447220, not started
  495. MySQL thread id 12086157, OS thread handle 0x7f77f638f700, query id 482843607 localhost myinstar_ranker
  496. ---TRANSACTION 12859447600, not started
  497. MySQL thread id 12086086, OS thread handle 0x7f7804f1a700, query id 482843953 localhost myinstar_ranker
  498. ---TRANSACTION 12859448017, not started
  499. MySQL thread id 12086082, OS thread handle 0x7f77f6aec700, query id 482844325 localhost myinstar_ranker
  500. ---TRANSACTION 12859445601, not started
  501. MySQL thread id 12086076, OS thread handle 0x7f77f6001700, query id 482842132 localhost myinstar_ranker
  502. ---TRANSACTION 12859447992, not started
  503. MySQL thread id 12086052, OS thread handle 0x7f7804b0a700, query id 482844300 localhost myinstar_ranker
  504. ---TRANSACTION 12859447599, not started
  505. MySQL thread id 12086035, OS thread handle 0x7f77f634e700, query id 482843952 localhost myinstar_ranker
  506. ---TRANSACTION 12859447895, not started
  507. MySQL thread id 12086021, OS thread handle 0x7f782c19d700, query id 482844214 localhost myinstar_ranker
  508. ---TRANSACTION 12859447789, not started
  509. MySQL thread id 12085999, OS thread handle 0x7f782409b700, query id 482844121 localhost myinstar_ranker
  510. ---TRANSACTION 12859447381, not started
  511. MySQL thread id 12085995, OS thread handle 0x7f78046fa700, query id 482843744 localhost myinstar_ranker
  512. ---TRANSACTION 12859447983, not started
  513. MySQL thread id 12085945, OS thread handle 0x7f782419f700, query id 482844291 localhost myinstar_ranker
  514. ---TRANSACTION 12859447436, not started
  515. MySQL thread id 12085920, OS thread handle 0x7f7805b09700, query id 482843797 localhost myinstar_ranker
  516. ---TRANSACTION 12859448035, not started
  517. MySQL thread id 12085882, OS thread handle 0x7f7804fdd700, query id 482844348 localhost myinstar_ranker
  518. ---TRANSACTION 12859437919, not started
  519. MySQL thread id 12085868, OS thread handle 0x7f78063ab700, query id 482835243 localhost myinstar_ranker
  520. ---TRANSACTION 12859446010, not started
  521. MySQL thread id 12085867, OS thread handle 0x7f7805a46700, query id 482842508 localhost myinstar_ranker
  522. ---TRANSACTION 12859445928, not started
  523. MySQL thread id 12085865, OS thread handle 0x7f77f7c71700, query id 482842427 localhost myinstar_ranker
  524. ---TRANSACTION 12859448085, not started
  525. MySQL thread id 12085855, OS thread handle 0x7f77f624a700, query id 482844390 localhost myinstar_ranker
  526. ---TRANSACTION 12859447587, not started
  527. MySQL thread id 12085820, OS thread handle 0x7f77f5aed700, query id 482843940 localhost myinstar_ranker
  528. ---TRANSACTION 12859448091, not started
  529. MySQL thread id 12085686, OS thread handle 0x7f7805677700, query id 482844396 localhost myinstar_ranker
  530. ---TRANSACTION 12859447480, not started
  531. MySQL thread id 12085674, OS thread handle 0x7f7824735700, query id 482843843 localhost myinstar_ranker
  532. ---TRANSACTION 12859440192, not started
  533. MySQL thread id 12085662, OS thread handle 0x7f77f69a7700, query id 482837296 localhost myinstar_ranker
  534. ---TRANSACTION 12859447374, not started
  535. MySQL thread id 12085656, OS thread handle 0x7f7805c0d700, query id 482843737 localhost myinstar_ranker
  536. ---TRANSACTION 12859445910, not started
  537. MySQL thread id 12085650, OS thread handle 0x7f782c260700, query id 482842409 localhost myinstar_ranker
  538. ---TRANSACTION 12859448014, not started
  539. MySQL thread id 12085649, OS thread handle 0x7f7805b8b700, query id 482844322 localhost myinstar_ranker
  540. ---TRANSACTION 12859447440, not started
  541. MySQL thread id 12085630, OS thread handle 0x7f7805573700, query id 482843801 localhost myinstar_ranker
  542. ---TRANSACTION 12859447914, not started
  543. MySQL thread id 12085622, OS thread handle 0x7f78056b8700, query id 482844227 localhost myinstar_ranker
  544. ---TRANSACTION 12859447824, not started
  545. MySQL thread id 12085570, OS thread handle 0x7f77f7cf3700, query id 482844155 localhost myinstar_ranker
  546. ---TRANSACTION 12859448003, not started
  547. MySQL thread id 12085448, OS thread handle 0x7f782c2e2700, query id 482844311 localhost myinstar_ranker
  548. ---TRANSACTION 12859447503, not started
  549. MySQL thread id 12085417, OS thread handle 0x7f78044f2700, query id 482843863 localhost myinstar_ranker
  550. ---TRANSACTION 12859447493, not started
  551. MySQL thread id 12085409, OS thread handle 0x7f77f7104700, query id 482843856 localhost myinstar_ranker
  552. ---TRANSACTION 12859448055, not started
  553. MySQL thread id 12085324, OS thread handle 0x7f7805c8f700, query id 482844363 localhost myinstar_ranker
  554. ---TRANSACTION 12859447598, not started
  555. MySQL thread id 12085089, OS thread handle 0x7f782415e700, query id 482843951 localhost myinstar_ranker
  556. ---TRANSACTION 12859447568, not started
  557. MySQL thread id 12084958, OS thread handle 0x7f78044b1700, query id 482843922 localhost myinstar_ranker
  558. ---TRANSACTION 12859447572, not started
  559. MySQL thread id 12084917, OS thread handle 0x7f780646e700, query id 482843926 localhost myinstar_ranker
  560. ---TRANSACTION 12859447313, not started
  561. MySQL thread id 12084811, OS thread handle 0x7f77f5a6b700, query id 482843692 localhost myinstar_ranker
  562. ---TRANSACTION 12859447629, not started
  563. MySQL thread id 12084705, OS thread handle 0x7f77f6baf700, query id 482843981 localhost myinstar_ranker
  564. ---TRANSACTION 12859448061, not started
  565. MySQL thread id 12084692, OS thread handle 0x7f77f7b6d700, query id 482844369 localhost myinstar_ranker
  566. ---TRANSACTION 12859448034, not started
  567. MySQL thread id 12084676, OS thread handle 0x7f77f6db7700, query id 482844347 localhost myinstar_ranker
  568. ---TRANSACTION 12859447733, not started
  569. MySQL thread id 12084672, OS thread handle 0x7f77f5e3a700, query id 482844068 localhost myinstar_ranker
  570. ---TRANSACTION 12859446643, not started
  571. MySQL thread id 12084580, OS thread handle 0x7f77f5c73700, query id 482843092 localhost myinstar_ranker
  572. ---TRANSACTION 12859442530, not started
  573. MySQL thread id 12084449, OS thread handle 0x7f782c15c700, query id 482839403 localhost myinstar_ranker
  574. ---TRANSACTION 12859447634, not started
  575. MySQL thread id 12084355, OS thread handle 0x7f780573a700, query id 482843986 localhost myinstar_ranker
  576. ---TRANSACTION 12859447254, not started
  577. MySQL thread id 12084268, OS thread handle 0x7f77f66dc700, query id 482843639 localhost myinstar_ranker
  578. ---TRANSACTION 12859447490, not started
  579. MySQL thread id 12084262, OS thread handle 0x7f77f75d7700, query id 482843853 localhost myinstar_ranker
  580. ---TRANSACTION 12859440775, not started
  581. MySQL thread id 12083886, OS thread handle 0x7f77f6cb3700, query id 482837803 localhost myinstar_ranker
  582. ---TRANSACTION 12859447659, not started
  583. MySQL thread id 12083786, OS thread handle 0x7f7805f19700, query id 482844004 localhost myinstar_ranker
  584. ---TRANSACTION 12859447377, not started
  585. MySQL thread id 12083753, OS thread handle 0x7f782446a700, query id 482843740 localhost myinstar_ranker
  586. ---TRANSACTION 12859447862, not started
  587. MySQL thread id 12083618, OS thread handle 0x7f77f7b2c700, query id 482844186 localhost myinstar_ranker
  588. ---TRANSACTION 12859447612, not started
  589. MySQL thread id 12083330, OS thread handle 0x7f77f7041700, query id 482843965 localhost myinstar_ranker
  590. ---TRANSACTION 12859448083, not started
  591. MySQL thread id 12083265, OS thread handle 0x7f77f775d700, query id 482844388 localhost myinstar_ranker
  592. ---TRANSACTION 12859447354, not started
  593. MySQL thread id 12083243, OS thread handle 0x7f78061a3700, query id 482843720 localhost myinstar_ranker
  594. ---TRANSACTION 12859447495, not started
  595. MySQL thread id 12083189, OS thread handle 0x7f78065b3700, query id 482843857 localhost myinstar_ranker
  596. ---TRANSACTION 12859447671, not started
  597. MySQL thread id 12083104, OS thread handle 0x7f782456e700, query id 482844015 localhost myinstar_ranker
  598. ---TRANSACTION 12859447186, not started
  599. MySQL thread id 12082714, OS thread handle 0x7f78060e0700, query id 482843581 localhost myinstar_ranker
  600. ---TRANSACTION 12859446771, not started
  601. MySQL thread id 12082640, OS thread handle 0x7f77f5efd700, query id 482843211 localhost myinstar_ranker
  602. ---TRANSACTION 12859447982, not started
  603. MySQL thread id 12082025, OS thread handle 0x7f78066b7700, query id 482844290 localhost myinstar_ranker
  604. ---TRANSACTION 12859448082, not started
  605. MySQL thread id 12081913, OS thread handle 0x7f7824221700, query id 482844387 localhost myinstar_ranker
  606. ---TRANSACTION 12859447153, not started
  607. MySQL thread id 12081577, OS thread handle 0x7f78053ac700, query id 482843552 localhost myinstar_ranker
  608. ---TRANSACTION 12859448009, not started
  609. MySQL thread id 12081272, OS thread handle 0x7f77f6cf4700, query id 482844317 localhost myinstar_ranker
  610. ---TRANSACTION 12859447765, not started
  611. MySQL thread id 12080239, OS thread handle 0x7f7804c0e700, query id 482844098 localhost myinstar_ranker
  612. ---TRANSACTION 12859448075, not started
  613. MySQL thread id 12019829, OS thread handle 0x7f7804678700, query id 482844380 localhost myinstar_ranker
  614. ---TRANSACTION 12859447477, not started
  615. MySQL thread id 12017542, OS thread handle 0x7f78047bd700, query id 482843840 localhost myinstar_ranker
  616. ---TRANSACTION 12859447516, not started
  617. MySQL thread id 9740837, OS thread handle 0x7f7804f9c700, query id 482843873 localhost myinstar_ranker
  618. ---TRANSACTION 12859437191, not started
  619. MySQL thread id 9740768, OS thread handle 0x7f7805fdc700, query id 482834217 localhost myinstar_ranker
  620. ---TRANSACTION 12859434205, not started
  621. MySQL thread id 9740767, OS thread handle 0x7f78055b4700, query id 482831366 localhost myinstar_ranker
  622. --------
  623. FILE I/O
  624. --------
  625. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  626. I/O thread 1 state: waiting for completed aio requests (log thread)
  627. I/O thread 2 state: waiting for completed aio requests (read thread)
  628. I/O thread 3 state: waiting for completed aio requests (read thread)
  629. I/O thread 4 state: waiting for completed aio requests (read thread)
  630. I/O thread 5 state: waiting for completed aio requests (read thread)
  631. I/O thread 6 state: waiting for completed aio requests (write thread)
  632. I/O thread 7 state: waiting for completed aio requests (write thread)
  633. I/O thread 8 state: waiting for completed aio requests (write thread)
  634. I/O thread 9 state: waiting for completed aio requests (write thread)
  635. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  636. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  637. Pending flushes (fsync) log: 0; buffer pool: 0
  638. 1423954 OS file reads, 164146278 OS file writes, 109860498 OS fsyncs
  639. 0.00 reads/s, 0 avg bytes/read, 221.82 writes/s, 107.41 fsyncs/s
  640. -------------------------------------
  641. INSERT BUFFER AND ADAPTIVE HASH INDEX
  642. -------------------------------------
  643. Ibuf: size 1, free list len 341802, seg size 341804, 33709 merges
  644. merged operations:
  645. insert 33275, delete mark 53955, delete 3779
  646. discarded operations:
  647. insert 0, delete mark 0, delete 0
  648. Hash table size 127498171, node heap has 80577 buffer(s)
  649. 113162.17 hash searches/s, 10072.02 non-hash searches/s
  650. ---
  651. LOG
  652. ---
  653. Log sequence number 2166023775461
  654. Log flushed up to 2166023775461
  655. Pages flushed up to 2166023711598
  656. Last checkpoint at 2166023398231
  657. 0 pending log writes, 0 pending chkp writes
  658. 93360798 log i/o's done, 54.24 log i/o's/second
  659. ----------------------
  660. BUFFER POOL AND MEMORY
  661. ----------------------
  662. Total memory allocated 65934458880; in additional pool allocated 0
  663. Dictionary memory allocated 17471969
  664. Buffer pool size 3932144
  665. Free buffers 2022690
  666. Database pages 1828877
  667. Old database pages 674789
  668. Modified db pages 246
  669. Pending reads 0
  670. Pending writes: LRU 0, flush list 0, single page 0
  671. Pages made young 41964, not young 0
  672. 0.07 youngs/s, 0.00 non-youngs/s
  673. Pages read 1420753, created 408124, written 63709204
  674. 0.00 reads/s, 0.30 creates/s, 144.84 writes/s
  675. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  676. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  677. LRU len: 1828877, unzip_LRU len: 0
  678. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  679. ----------------------
  680. INDIVIDUAL BUFFER POOL INFO
  681. ----------------------
  682. ---BUFFER POOL 0
  683. Buffer pool size 245759
  684. Free buffers 122982
  685. Database pages 117733
  686. Old database pages 43440
  687. Modified db pages 93
  688. Pending reads 0
  689. Pending writes: LRU 0, flush list 0, single page 0
  690. Pages made young 2776, not young 0
  691. 0.00 youngs/s, 0.00 non-youngs/s
  692. Pages read 90092, created 27641, written 17035505
  693. 0.00 reads/s, 0.00 creates/s, 59.89 writes/s
  694. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  695. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  696. LRU len: 117733, unzip_LRU len: 0
  697. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  698. ---BUFFER POOL 1
  699. Buffer pool size 245759
  700. Free buffers 127110
  701. Database pages 113585
  702. Old database pages 41908
  703. Modified db pages 5
  704. Pending reads 0
  705. Pending writes: LRU 0, flush list 0, single page 0
  706. Pages made young 2555, not young 0
  707. 0.00 youngs/s, 0.00 non-youngs/s
  708. Pages read 88528, created 25057, written 2196942
  709. 0.00 reads/s, 0.00 creates/s, 2.83 writes/s
  710. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  711. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  712. LRU len: 113585, unzip_LRU len: 0
  713. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  714. ---BUFFER POOL 2
  715. Buffer pool size 245759
  716. Free buffers 125462
  717. Database pages 115268
  718. Old database pages 42530
  719. Modified db pages 2
  720. Pending reads 0
  721. Pending writes: LRU 0, flush list 0, single page 0
  722. Pages made young 2546, not young 0
  723. 0.00 youngs/s, 0.00 non-youngs/s
  724. Pages read 89724, created 25544, written 2081684
  725. 0.00 reads/s, 0.00 creates/s, 2.61 writes/s
  726. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  727. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  728. LRU len: 115268, unzip_LRU len: 0
  729. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  730. ---BUFFER POOL 3
  731. Buffer pool size 245759
  732. Free buffers 125797
  733. Database pages 114932
  734. Old database pages 42407
  735. Modified db pages 54
  736. Pending reads 0
  737. Pending writes: LRU 0, flush list 0, single page 0
  738. Pages made young 2753, not young 0
  739. 0.00 youngs/s, 0.00 non-youngs/s
  740. Pages read 88983, created 25949, written 8054848
  741. 0.00 reads/s, 0.00 creates/s, 22.67 writes/s
  742. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  743. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  744. LRU len: 114932, unzip_LRU len: 0
  745. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  746. ---BUFFER POOL 4
  747. Buffer pool size 245759
  748. Free buffers 126924
  749. Database pages 113786
  750. Old database pages 41983
  751. Modified db pages 44
  752. Pending reads 0
  753. Pending writes: LRU 0, flush list 0, single page 0
  754. Pages made young 2715, not young 0
  755. 0.00 youngs/s, 0.00 non-youngs/s
  756. Pages read 88809, created 24977, written 7364196
  757. 0.00 reads/s, 0.00 creates/s, 19.50 writes/s
  758. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  759. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  760. LRU len: 113786, unzip_LRU len: 0
  761. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  762. ---BUFFER POOL 5
  763. Buffer pool size 245759
  764. Free buffers 126969
  765. Database pages 113714
  766. Old database pages 41956
  767. Modified db pages 12
  768. Pending reads 0
  769. Pending writes: LRU 0, flush list 0, single page 0
  770. Pages made young 2537, not young 0
  771. 0.02 youngs/s, 0.00 non-youngs/s
  772. Pages read 88422, created 25292, written 2654912
  773. 0.00 reads/s, 0.04 creates/s, 4.37 writes/s
  774. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  775. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  776. LRU len: 113714, unzip_LRU len: 0
  777. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  778. ---BUFFER POOL 6
  779. Buffer pool size 245759
  780. Free buffers 126327
  781. Database pages 114415
  782. Old database pages 42215
  783. Modified db pages 0
  784. Pending reads 0
  785. Pending writes: LRU 0, flush list 0, single page 0
  786. Pages made young 2738, not young 0
  787. 0.00 youngs/s, 0.00 non-youngs/s
  788. Pages read 89795, created 24620, written 2543853
  789. 0.00 reads/s, 0.00 creates/s, 2.96 writes/s
  790. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  791. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  792. LRU len: 114415, unzip_LRU len: 0
  793. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  794. ---BUFFER POOL 7
  795. Buffer pool size 245759
  796. Free buffers 125780
  797. Database pages 114970
  798. Old database pages 42420
  799. Modified db pages 3
  800. Pending reads 0
  801. Pending writes: LRU 0, flush list 0, single page 0
  802. Pages made young 2529, not young 0
  803. 0.02 youngs/s, 0.00 non-youngs/s
  804. Pages read 89880, created 25090, written 2774016
  805. 0.00 reads/s, 0.02 creates/s, 3.76 writes/s
  806. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  807. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  808. LRU len: 114970, unzip_LRU len: 0
  809. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  810. ---BUFFER POOL 8
  811. Buffer pool size 245759
  812. Free buffers 125547
  813. Database pages 115073
  814. Old database pages 42458
  815. Modified db pages 2
  816. Pending reads 0
  817. Pending writes: LRU 0, flush list 0, single page 0
  818. Pages made young 2759, not young 0
  819. 0.00 youngs/s, 0.00 non-youngs/s
  820. Pages read 88846, created 26227, written 2624692
  821. 0.00 reads/s, 0.00 creates/s, 2.96 writes/s
  822. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  823. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  824. LRU len: 115073, unzip_LRU len: 0
  825. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  826. ---BUFFER POOL 9
  827. Buffer pool size 245759
  828. Free buffers 126607
  829. Database pages 114139
  830. Old database pages 42113
  831. Modified db pages 8
  832. Pending reads 0
  833. Pending writes: LRU 0, flush list 0, single page 0
  834. Pages made young 2666, not young 0
  835. 0.00 youngs/s, 0.00 non-youngs/s
  836. Pages read 88518, created 25621, written 2726967
  837. 0.00 reads/s, 0.07 creates/s, 3.57 writes/s
  838. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  839. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  840. LRU len: 114139, unzip_LRU len: 0
  841. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  842. ---BUFFER POOL 10
  843. Buffer pool size 245759
  844. Free buffers 126638
  845. Database pages 114116
  846. Old database pages 42104
  847. Modified db pages 4
  848. Pending reads 0
  849. Pending writes: LRU 0, flush list 0, single page 0
  850. Pages made young 2574, not young 0
  851. 0.00 youngs/s, 0.00 non-youngs/s
  852. Pages read 88872, created 25244, written 2293310
  853. 0.00 reads/s, 0.00 creates/s, 2.35 writes/s
  854. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  855. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  856. LRU len: 114116, unzip_LRU len: 0
  857. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  858. ---BUFFER POOL 11
  859. Buffer pool size 245759
  860. Free buffers 126252
  861. Database pages 114415
  862. Old database pages 42215
  863. Modified db pages 6
  864. Pending reads 0
  865. Pending writes: LRU 0, flush list 0, single page 0
  866. Pages made young 2710, not young 0
  867. 0.02 youngs/s, 0.00 non-youngs/s
  868. Pages read 87445, created 26970, written 2832249
  869. 0.00 reads/s, 0.15 creates/s, 5.15 writes/s
  870. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  871. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  872. LRU len: 114415, unzip_LRU len: 0
  873. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  874. ---BUFFER POOL 12
  875. Buffer pool size 245759
  876. Free buffers 125773
  877. Database pages 114964
  878. Old database pages 42417
  879. Modified db pages 0
  880. Pending reads 0
  881. Pending writes: LRU 0, flush list 0, single page 0
  882. Pages made young 2582, not young 0
  883. 0.00 youngs/s, 0.00 non-youngs/s
  884. Pages read 89109, created 25855, written 2046838
  885. 0.00 reads/s, 0.00 creates/s, 2.30 writes/s
  886. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  887. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  888. LRU len: 114964, unzip_LRU len: 0
  889. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  890. ---BUFFER POOL 13
  891. Buffer pool size 245759
  892. Free buffers 126591
  893. Database pages 114176
  894. Old database pages 42127
  895. Modified db pages 2
  896. Pending reads 0
  897. Pending writes: LRU 0, flush list 0, single page 0
  898. Pages made young 2524, not young 0
  899. 0.00 youngs/s, 0.00 non-youngs/s
  900. Pages read 89755, created 24421, written 1995149
  901. 0.00 reads/s, 0.02 creates/s, 2.52 writes/s
  902. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  903. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  904. LRU len: 114176, unzip_LRU len: 0
  905. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  906. ---BUFFER POOL 14
  907. Buffer pool size 245759
  908. Free buffers 132766
  909. Database pages 108036
  910. Old database pages 39860
  911. Modified db pages 10
  912. Pending reads 0
  913. Pending writes: LRU 0, flush list 0, single page 0
  914. Pages made young 2397, not young 0
  915. 0.00 youngs/s, 0.00 non-youngs/s
  916. Pages read 84378, created 23658, written 2525101
  917. 0.00 reads/s, 0.00 creates/s, 4.65 writes/s
  918. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  919. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  920. LRU len: 108036, unzip_LRU len: 0
  921. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  922. ---BUFFER POOL 15
  923. Buffer pool size 245759
  924. Free buffers 125165
  925. Database pages 115555
  926. Old database pages 42636
  927. Modified db pages 1
  928. Pending reads 0
  929. Pending writes: LRU 0, flush list 0, single page 0
  930. Pages made young 2603, not young 0
  931. 0.00 youngs/s, 0.00 non-youngs/s
  932. Pages read 89597, created 25958, written 1958942
  933. 0.00 reads/s, 0.00 creates/s, 2.76 writes/s
  934. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  935. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  936. LRU len: 115555, unzip_LRU len: 0
  937. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  938. --------------
  939. ROW OPERATIONS
  940. --------------
  941. 0 queries inside InnoDB, 0 queries in queue
  942. 2 read views open inside InnoDB
  943. Main thread process no. 65768, id 140154157319936, state: sleeping
  944. Number of rows inserted 16149610, updated 67523766, deleted 8501768, read 716835423505
  945. 9.17 inserts/s, 39.11 updates/s, 5.24 deletes/s, 478212.30 reads/s
  946. ----------------------------
  947. END OF INNODB MONITOR OUTPUT
  948. ============================
  949. |
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!