API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 21st, 2014
511
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.22 KB | None | 0 0
raw download clone embed print report
  1. *************************** 1. row ***************************
  2. now(): 2014-07-21 04:06:01
  3. *************************** 1. row ***************************
  4. Id: 2336222
  5. User: dlh
  6. Host: DLH03:35538
  7. db: dlhbe
  8. Command: Sleep
  9. Time: 4
  10. State:
  11. Info: NULL
  12. *************************** 2. row ***************************
  13. Id: 2337424
  14. User: dlh
  15. Host: dlh-vip:54202
  16. db: dlhbe
  17. Command: Sleep
  18. Time: 9
  19. State:
  20. Info: NULL
  21. *************************** 3. row ***************************
  22. Id: 3749630
  23. User: repl
  24. Host: DLH03:38959
  25. db: NULL
  26. Command: Binlog Dump
  27. Time: 1929524
  28. State: Master has sent all binlog to slave; waiting for binlog to be updated
  29. Info: NULL
  30. *************************** 4. row ***************************
  31. Id: 6149757
  32. User: dlh
  33. Host: dlh-vip:50788
  34. db: dlhbe
  35. Command: Query
  36. Time: 51
  37. State: Waiting for table flush
  38. Info: insert into db_external_notification (...
  39. *************************** 5. row ***************************
  40. Id: 6152220
  41. User: dlh
  42. Host: DLH03:39252
  43. db: dlhbe
  44. Command: Query
  45. Time: 53
  46. State: Waiting for table flush
  47. Info: insert into db_external_notification (...
  48. *************************** 6. row ***************************
  49. Id: 6152552
  50. User: dlh
  51. Host: dlh-vip:59600
  52. db: dlhbe
  53. Command: Query
  54. Time: 53
  55. State: Waiting for table flush
  56. Info: insert into db_external_notification (...
  57. *************************** 7. row ***************************
  58. Id: 6153654
  59. User: dlh
  60. Host: DLH03:42901
  61. db: dlhbe
  62. Command: Query
  63. Time: 53
  64. State: Waiting for table flush
  65. Info: insert into db_external_notification (...
  66. *************************** 8. row ***************************
  67. Id: 6153956
  68. User: dlh
  69. Host: DLH03:43325
  70. db: dlhbe
  71. Command: Query
  72. Time: 53
  73. State: Waiting for table flush
  74. Info: insert into db_external_notification (...
  75. *************************** 9. row ***************************
  76. Id: 6153959
  77. User: dlh
  78. Host: DLH03:43331
  79. db: dlhbe
  80. Command: Query
  81. Time: 53
  82. State: Waiting for table flush
  83. Info: insert into db_external_notification (...
  84. *************************** 10. row ***************************
  85. Id: 6154058
  86. User: dlh
  87. Host: dlh-vip:36630
  88. db: dlhbe
  89. Command: Query
  90. Time: 51
  91. State: Waiting for table flush
  92. Info: insert into db_external_notification (...
  93. *************************** 11. row ***************************
  94. Id: 6154184
  95. User: dlh
  96. Host: DLH03:43794
  97. db: dlhbe
  98. Command: Query
  99. Time: 53
  100. State: Waiting for table flush
  101. Info: insert into db_external_notification (...
  102. *************************** 12. row ***************************
  103. Id: 6154213
  104. User: dlh
  105. Host: DLH03:43803
  106. db: dlhbe
  107. Command: Query
  108. Time: 54
  109. State: Waiting for table flush
  110. Info: insert into db_external_notification (...
  111. *************************** 13. row ***************************
  112. Id: 6154235
  113. User: dlh
  114. Host: dlh-vip:36998
  115. db: dlhbe
  116. Command: Query
  117. Time: 51
  118. State: Waiting for table flush
  119. Info: insert into db_external_notification (...
  120. *************************** 14. row ***************************
  121. Id: 6154239
  122. User: dlh
  123. Host: dlh-vip:37003
  124. db: dlhbe
  125. Command: Query
  126. Time: 54
  127. State: Waiting for table flush
  128. Info: insert into db_external_notification (...
  129. *************************** 15. row ***************************
  130. Id: 6154242
  131. User: dlh
  132. Host: dlh-vip:37007
  133. db: dlhbe
  134. Command: Query
  135. Time: 51
  136. State: Waiting for table flush
  137. Info: insert into db_external_notification (...
  138. *************************** 16. row ***************************
  139. Id: 6154246
  140. User: dlh
  141. Host: dlh-vip:37010
  142. db: dlhbe
  143. Command: Query
  144. Time: 51
  145. State: Waiting for table flush
  146. Info: insert into db_external_notification (...
  147. *************************** 17. row ***************************
  148. Id: 6154247
  149. User: dlh
  150. Host: dlh-vip:37012
  151. db: dlhbe
  152. Command: Query
  153. Time: 51
  154. State: Waiting for table flush
  155. Info: insert into db_external_notification (...
  156. *************************** 18. row ***************************
  157. Id: 6154250
  158. User: dlh
  159. Host: dlh-vip:37016
  160. db: dlhbe
  161. Command: Query
  162. Time: 54
  163. State: Waiting for table flush
  164. Info: insert into db_external_notification (...
  165. *************************** 19. row ***************************
  166. Id: 6154251
  167. User: dlh
  168. Host: dlh-vip:37017
  169. db: dlhbe
  170. Command: Query
  171. Time: 53
  172. State: Waiting for table flush
  173. Info: insert into db_external_notification (...
  174. *************************** 20. row ***************************
  175. Id: 6154252
  176. User: dlh
  177. Host: dlh-vip:37018
  178. db: dlhbe
  179. Command: Query
  180. Time: 53
  181. State: Waiting for table flush
  182. Info: insert into db_external_notification (...
  183. *************************** 21. row ***************************
  184. Id: 6154265
  185. User: dlh
  186. Host: DLH03:43822
  187. db: dlhbe
  188. Command: Query
  189. Time: 51
  190. State: Waiting for table flush
  191. Info: insert into db_external_notification (...
  192. *************************** 22. row ***************************
  193. Id: 6154269
  194. User: dlh
  195. Host: DLH03:43824
  196. db: dlhbe
  197. Command: Query
  198. Time: 53
  199. State: Waiting for table flush
  200. Info: insert into db_external_notification (...
  201. *************************** 23. row ***************************
  202. Id: 6155315
  203. User: root
  204. Host: localhost
  205. db: dlhbe
  206. Command: Query
  207. Time: 1204
  208. State: Sending data
  209. Info: SELECT /*!40001 SQL_NO_CACHE */ * FROM `db_external_notification`
  210. *************************** 24. row ***************************
  211. Id: 6156544
  212. User: dlh
  213. Host: DLH03:44437
  214. db: dlhbe
  215. Command: Query
  216. Time: 53
  217. State: Waiting for table flush
  218. Info: insert into db_external_notification (...
  219. *************************** 25. row ***************************
  220. Id: 6156612
  221. User: dlh
  222. Host: dlh-vip:42326
  223. db: dlhbe
  224. Command: Query
  225. Time: 53
  226. State: Waiting for table flush
  227. Info: insert into db_external_notification (...
  228. *************************** 26. row ***************************
  229. Id: 6158068
  230. User: dlh
  231. Host: DLH03:44972
  232. db: dlhbe
  233. Command: Query
  234. Time: 53
  235. State: Waiting for table flush
  236. Info: insert into db_external_notification (...
  237. *************************** 27. row ***************************
  238. Id: 6158069
  239. User: dlh
  240. Host: DLH03:44973
  241. db: dlhbe
  242. Command: Query
  243. Time: 53
  244. State: Waiting for table flush
  245. Info: insert into db_external_notification (...
  246. *************************** 28. row ***************************
  247. Id: 6158070
  248. User: dlh
  249. Host: DLH03:44974
  250. db: dlhbe
  251. Command: Query
  252. Time: 51
  253. State: Waiting for table flush
  254. Info: insert into db_external_notification (...
  255. *************************** 29. row ***************************
  256. Id: 6158073
  257. User: dlh
  258. Host: DLH03:44975
  259. db: dlhbe
  260. Command: Query
  261. Time: 51
  262. State: Waiting for table flush
  263. Info: insert into db_external_notification (...
  264. *************************** 30. row ***************************
  265. Id: 6158074
  266. User: dlh
  267. Host: DLH03:44976
  268. db: dlhbe
  269. Command: Query
  270. Time: 51
  271. State: Waiting for table flush
  272. Info: insert into db_external_notification (...
  273. *************************** 31. row ***************************
  274. Id: 6158075
  275. User: dlh
  276. Host: DLH03:44977
  277. db: dlhbe
  278. Command: Query
  279. Time: 51
  280. State: Waiting for table flush
  281. Info: insert into db_external_notification (...
  282. *************************** 32. row ***************************
  283. Id: 6158076
  284. User: dlh
  285. Host: DLH03:44978
  286. db: dlhbe
  287. Command: Query
  288. Time: 51
  289. State: Waiting for table flush
  290. Info: insert into db_external_notification (...
  291. *************************** 33. row ***************************
  292. Id: 6158077
  293. User: dlh
  294. Host: DLH03:44979
  295. db: dlhbe
  296. Command: Query
  297. Time: 51
  298. State: Waiting for table flush
  299. Info: insert into db_external_notification (...
  300. *************************** 34. row ***************************
  301. Id: 6158078
  302. User: dlh
  303. Host: dlh-vip:45727
  304. db: dlhbe
  305. Command: Query
  306. Time: 51
  307. State: Waiting for table flush
  308. Info: insert into db_external_notification (...
  309. *************************** 35. row ***************************
  310. Id: 6158079
  311. User: dlh
  312. Host: dlh-vip:45728
  313. db: dlhbe
  314. Command: Query
  315. Time: 0
  316. State: Waiting for table flush
  317. Info: insert into db_external_notification (...
  318. *************************** 36. row ***************************
  319. Id: 6158080
  320. User: dlh
  321. Host: DLH03:44980
  322. db: dlhbe
  323. Command: Query
  324. Time: 1
  325. State: Waiting for table flush
  326. Info: insert into db_external_notification (...
  327. *************************** 37. row ***************************
  328. Id: 6158081
  329. User: dlh
  330. Host: dlh-vip:45729
  331. db: dlhbe
  332. Command: Sleep
  333. Time: 27
  334. State:
  335. Info: NULL
  336. *************************** 38. row ***************************
  337. Id: 6158082
  338. User: dlh
  339. Host: dlh-vip:45730
  340. db: dlhbe
  341. Command: Query
  342. Time: 0
  343. State: Waiting for table flush
  344. Info: insert into db_external_notification (...
  345. *************************** 39. row ***************************
  346. Id: 6158083
  347. User: dlh
  348. Host: dlh-vip:45731
  349. db: dlhbe
  350. Command: Query
  351. Time: 0
  352. State: Waiting for table flush
  353. Info: insert into db_external_notification (...
  354. *************************** 40. row ***************************
  355. Id: 6158087
  356. User: dlh
  357. Host: DLH03:44986
  358. db: dlhbe
  359. Command: Query
  360. Time: 1
  361. State: Waiting for table flush
  362. Info: insert into db_external_notification (...
  363. *************************** 41. row ***************************
  364. Id: 6158089
  365. User: dlh
  366. Host: dlh-vip:45742
  367. db: dlhbe
  368. Command: Sleep
  369. Time: 27
  370. State:
  371. Info: NULL
  372. *************************** 42. row ***************************
  373. Id: 6158090
  374. User: dlh
  375. Host: dlh-vip:45743
  376. db: dlhbe
  377. Command: Query
  378. Time: 0
  379. State: Waiting for table flush
  380. Info: insert into db_external_notification (...
  381. *************************** 43. row ***************************
  382. Id: 6158091
  383. User: dlh
  384. Host: dlh-vip:45744
  385. db: dlhbe
  386. Command: Sleep
  387. Time: 0
  388. State:
  389. Info: NULL
  390. *************************** 44. row ***************************
  391. Id: 6158092
  392. User: dlh
  393. Host: dlh-vip:45745
  394. db: dlhbe
  395. Command: Sleep
  396. Time: 27
  397. State:
  398. Info: NULL
  399. *************************** 45. row ***************************
  400. Id: 6158093
  401. User: dlh
  402. Host: dlh-vip:45746
  403. db: dlhbe
  404. Command: Sleep
  405. Time: 27
  406. State:
  407. Info: NULL
  408. *************************** 46. row ***************************
  409. Id: 6158094
  410. User: dlh
  411. Host: dlh-vip:45747
  412. db: dlhbe
  413. Command: Sleep
  414. Time: 27
  415. State:
  416. Info: NULL
  417. *************************** 47. row ***************************
  418. Id: 6158095
  419. User: dlh
  420. Host: dlh-vip:45748
  421. db: dlhbe
  422. Command: Query
  423. Time: 0
  424. State: Waiting for table flush
  425. Info: insert into db_external_notification (...
  426. *************************** 48. row ***************************
  427. Id: 6158096
  428. User: dlh
  429. Host: dlh-vip:45749
  430. db: dlhbe
  431. Command: Sleep
  432. Time: 28
  433. State:
  434. Info: NULL
  435. *************************** 49. row ***************************
  436. Id: 6158097
  437. User: dlh
  438. Host: dlh-vip:45750
  439. db: dlhbe
  440. Command: Sleep
  441. Time: 27
  442. State:
  443. Info: NULL
  444. *************************** 50. row ***************************
  445. Id: 6158100
  446. User: dlh
  447. Host: DLH03:44990
  448. db: dlhbe
  449. Command: Query
  450. Time: 0
  451. State: Waiting for table flush
  452. Info: insert into db_external_notification (...
  453. *************************** 51. row ***************************
  454. Id: 6158101
  455. User: root
  456. Host: localhost
  457. db: NULL
  458. Command: Query
  459. Time: 0
  460. State: init
  461. Info: show full processlist
  462. *************************** 1. row ***************************
  463. Type: InnoDB
  464. Name:
  465. Status:
  466. =====================================
  467. 2014-07-21 04:06:01 861e4b70 INNODB MONITOR OUTPUT
  468. =====================================
  469. Per second averages calculated from the last 60 seconds
  470. -----------------
  471. BACKGROUND THREAD
  472. -----------------
  473. srv_master_thread loops: 3456521 srv_active, 0 srv_shutdown, 1196243 srv_idle
  474. srv_master_thread log flush and writes: 4652764
  475. ----------
  476. SEMAPHORES
  477. ----------
  478. OS WAIT ARRAY INFO: reservation count 49923667
  479. OS WAIT ARRAY INFO: signal count 63709458
  480. Mutex spin waits 154026294, rounds 667509484, OS waits 11940078
  481. RW-shared spins 49738202, rounds 1094105577, OS waits 29201229
  482. RW-excl spins 17827968, rounds 400775195, OS waits 7537888
  483. Spin rounds per wait: 4.33 mutex, 22.00 RW-shared, 22.48 RW-excl
  484. ------------------------
  485. LATEST DETECTED DEADLOCK
  486. ------------------------
  487. 2014-07-20 11:50:09 85fe8b70
  488.  
  489. .....
  490.  
  491. ------------
  492. TRANSACTIONS
  493. ------------
  494. Trx id counter 1252628184
  495. Purge done for trx's n:o < 1252538413 undo n:o < 0 state: running but idle
  496. History list length 25142
  497. LIST OF TRANSACTIONS FOR EACH SESSION:
  498. ---TRANSACTION 0, not started
  499. MySQL thread id 6158101, OS thread handle 0x861e4b70, query id 368090598 localhost root init
  500. show engine innodb status
  501. ---TRANSACTION 1252626917, not started
  502. MySQL thread id 6158097, OS thread handle 0x8509db70, query id 368065640 dlh-vip 80.77.222.224 dlh cleaning up
  503. ---TRANSACTION 1252626903, not started
  504. MySQL thread id 6158093, OS thread handle 0x85874b70, query id 368064072 dlh-vip 80.77.222.224 dlh cleaning up
  505. ---TRANSACTION 1252628121, not started
  506. MySQL thread id 6158095, OS thread handle 0x84eceb70, query id 368088537 dlh-vip 80.77.222.224 dlh Waiting for table flush
  507. insert into db_external_notification (...
  508. ---TRANSACTION 1252626916, not started
  509. MySQL thread id 6158094, OS thread handle 0x8607bb70, query id 368065519 dlh-vip 80.77.222.224 dlh cleaning up
  510. ---TRANSACTION 1252626922, not started
  511. MySQL thread id 6158092, OS thread handle 0x85fb7b70, query id 368065550 dlh-vip 80.77.222.224 dlh cleaning up
  512. ---TRANSACTION 1252626947, not started
  513. MySQL thread id 6158090, OS thread handle 0x8636cb70, query id 368090479 dlh-vip 80.77.222.224 dlh Waiting for table flush
  514. insert into db_external_notification (...
  515. ---TRANSACTION 1252626918, not started
  516. MySQL thread id 6158089, OS thread handle 0x85c90b70, query id 368065608 dlh-vip 80.77.222.224 dlh cleaning up
  517. ---TRANSACTION 1252628080, not started
  518. MySQL thread id 6158087, OS thread handle 0x8c9ffb70, query id 368087871 DLH03 80.77.222.221 dlh Waiting for table flush
  519. insert into db_external_notification (...
  520. ---TRANSACTION 1252628126, not started
  521. MySQL thread id 6158083, OS thread handle 0x8599ab70, query id 368088717 dlh-vip 80.77.222.224 dlh Waiting for table flush
  522. insert into db_external_notification (...
  523. ---TRANSACTION 1252628082, not started
  524. MySQL thread id 6158082, OS thread handle 0x862a8b70, query id 368088333 dlh-vip 80.77.222.224 dlh Waiting for table flush
  525. insert into db_external_notification (...
  526. ---TRANSACTION 1252626901, not started
  527. MySQL thread id 6158081, OS thread handle 0x85cf2b70, query id 368064364 dlh-vip 80.77.222.224 dlh cleaning up
  528. ---TRANSACTION 1252628083, not started
  529. MySQL thread id 6158080, OS thread handle 0x84e3bb70, query id 368087766 DLH03 80.77.222.221 dlh Waiting for table flush
  530. insert into db_external_notification (...
  531. ---TRANSACTION 1252628144, not started
  532. MySQL thread id 6158079, OS thread handle 0x86277b70, query id 368089342 dlh-vip 80.77.222.224 dlh Waiting for table flush
  533. insert into db_external_notification (...
  534. ---TRANSACTION 1252626745, not started
  535. MySQL thread id 6158078, OS thread handle 0x863ceb70, query id 368055627 dlh-vip 80.77.222.224 dlh Waiting for table flush
  536. insert into db_external_notification (...
  537. ---TRANSACTION 1252626597, not started
  538. MySQL thread id 6158070, OS thread handle 0x85969b70, query id 368054983 DLH03 80.77.222.221 dlh Waiting for table flush
  539. insert into db_external_notification (...
  540. ---TRANSACTION 1252626595, not started
  541. MySQL thread id 6158069, OS thread handle 0x85aa2b70, query id 368054560 DLH03 80.77.222.221 dlh Waiting for table flush
  542. insert into db_external_notification (...
  543. ---TRANSACTION 1252626594, not started
  544. MySQL thread id 6158068, OS thread handle 0x8540ab70, query id 368054518 DLH03 80.77.222.221 dlh Waiting for table flush
  545. insert into db_external_notification (...
  546. ---TRANSACTION 1252622576, not started
  547. MySQL thread id 6156612, OS thread handle 0x8523bb70, query id 368054464 dlh-vip 80.77.222.224 dlh Waiting for table flush
  548. insert into db_external_notification (...
  549. ---TRANSACTION 1252626580, not started
  550. MySQL thread id 6156544, OS thread handle 0x85f42b70, query id 368054087 DLH03 80.77.222.221 dlh Waiting for table flush
  551. insert into db_external_notification (...
  552. ---TRANSACTION 1252625043, not started
  553. MySQL thread id 6154251, OS thread handle 0x858d6b70, query id 368054016 dlh-vip 80.77.222.224 dlh Waiting for table flush
  554. insert into db_external_notification (...
  555. ---TRANSACTION 1252625299, not started
  556. MySQL thread id 6154252, OS thread handle 0x860ddb70, query id 368053836 dlh-vip 80.77.222.224 dlh Waiting for table flush
  557. insert into db_external_notification (...
  558. ---TRANSACTION 1252619213, not started
  559. MySQL thread id 6154269, OS thread handle 0x86019b70, query id 368054387 DLH03 80.77.222.221 dlh Waiting for table flush
  560. insert into db_external_notification (...
  561. ---TRANSACTION 1252626549, not started
  562. MySQL thread id 6154265, OS thread handle 0x8546cb70, query id 368054875 DLH03 80.77.222.221 dlh Waiting for table flush
  563. insert into db_external_notification (...
  564. ---TRANSACTION 1252626539, not started
  565. MySQL thread id 6154250, OS thread handle 0x8656cb70, query id 368053550 dlh-vip 80.77.222.224 dlh Waiting for table flush
  566. insert into db_external_notification (...
  567. ---TRANSACTION 1252626714, not started
  568. MySQL thread id 6154247, OS thread handle 0x8503bb70, query id 368054813 dlh-vip 80.77.222.224 dlh Waiting for table flush
  569. insert into db_external_notification (...
  570. ---TRANSACTION 1252626732, not started
  571. MySQL thread id 6154246, OS thread handle 0x85d85b70, query id 368055235 dlh-vip 80.77.222.224 dlh Waiting for table flush
  572. insert into db_external_notification (...
  573. ---TRANSACTION 1252626724, not started
  574. MySQL thread id 6154242, OS thread handle 0x85a40b70, query id 368055002 dlh-vip 80.77.222.224 dlh Waiting for table flush
  575. insert into db_external_notification (...
  576. ---TRANSACTION 1252626534, not started
  577. MySQL thread id 6154239, OS thread handle 0x850ffb70, query id 368053665 dlh-vip 80.77.222.224 dlh Waiting for table flush
  578. insert into db_external_notification (...
  579. ---TRANSACTION 1252626743, not started
  580. MySQL thread id 6154235, OS thread handle 0x85cc1b70, query id 368055556 dlh-vip 80.77.222.224 dlh Waiting for table flush
  581. insert into db_external_notification (...
  582. ---TRANSACTION 1252626552, not started
  583. MySQL thread id 6154213, OS thread handle 0x8526cb70, query id 368053610 DLH03 80.77.222.221 dlh Waiting for table flush
  584. insert into db_external_notification (...
  585. ---TRANSACTION 1252619256, not started
  586. MySQL thread id 6154184, OS thread handle 0x850ceb70, query id 368054052 DLH03 80.77.222.221 dlh Waiting for table flush
  587. insert into db_external_notification (...
  588. ---TRANSACTION 1252626722, not started
  589. MySQL thread id 6154058, OS thread handle 0x852ceb70, query id 368054928 dlh-vip 80.77.222.224 dlh Waiting for table flush
  590. insert into db_external_notification (...
  591. ---TRANSACTION 1252626591, not started
  592. MySQL thread id 6153959, OS thread handle 0x8506cb70, query id 368054418 DLH03 80.77.222.221 dlh Waiting for table flush
  593. insert into db_external_notification (...
  594. ---TRANSACTION 1252619241, not started
  595. MySQL thread id 6153956, OS thread handle 0x8cd5ab70, query id 368054273 DLH03 80.77.222.221 dlh Waiting for table flush
  596. insert into db_external_notification (...
  597. ---TRANSACTION 1252626553, not started
  598. MySQL thread id 6153654, OS thread handle 0x854ffb70, query id 368053962 DLH03 80.77.222.221 dlh Waiting for table flush
  599. insert into db_external_notification (...
  600. ---TRANSACTION 1252622916, not started
  601. MySQL thread id 6152552, OS thread handle 0x8543bb70, query id 368054234 dlh-vip 80.77.222.224 dlh Waiting for table flush
  602. insert into db_external_notification (...
  603. ---TRANSACTION 1252626587, not started
  604. MySQL thread id 6152220, OS thread handle 0x8653bb70, query id 368054304 DLH03 80.77.222.221 dlh Waiting for table flush
  605. insert into db_external_notification (...
  606. ---TRANSACTION 1252626744, not started
  607. MySQL thread id 6149757, OS thread handle 0x86f99b70, query id 368055585 dlh-vip 80.77.222.224 dlh Waiting for table flush
  608. insert into db_external_notification (...
  609. ---TRANSACTION 1252628183, ACTIVE 0 sec preparing
  610. 11 lock struct(s), heap size 1024, 6 row lock(s), undo log entries 1
  611. MySQL thread id 6158091, OS thread handle 0x85e1cb70, query id 368090599 dlh-vip 80.77.222.224 dlh init
  612. commit
  613. ---TRANSACTION 1252538404, ACTIVE 3358 sec fetching rows
  614. mysql tables in use 1, locked 0
  615. MySQL thread id 6155315, OS thread handle 0x85f11b70, query id 367774810 localhost root Sending data
  616. SELECT /*!40001 SQL_NO_CACHE */ * FROM `db_external_notification`
  617. Trx read view will not see trx with id >= 1252538405, sees < 1252538391
  618. --------
  619. FILE I/O
  620. --------
  621. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  622. I/O thread 1 state: waiting for completed aio requests (log thread)
  623. I/O thread 2 state: waiting for completed aio requests (read thread)
  624. I/O thread 3 state: waiting for completed aio requests (read thread)
  625. I/O thread 4 state: waiting for completed aio requests (read thread)
  626. I/O thread 5 state: waiting for completed aio requests (read thread)
  627. I/O thread 6 state: waiting for completed aio requests (write thread)
  628. I/O thread 7 state: waiting for completed aio requests (write thread)
  629. I/O thread 8 state: waiting for completed aio requests (write thread)
  630. I/O thread 9 state: waiting for completed aio requests (write thread)
  631. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  632. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  633. Pending flushes (fsync) log: 1; buffer pool: 0
  634. 295282936 OS file reads, 473892052 OS file writes, 253451291 OS fsyncs
  635. 1 pending preads, 0 pending pwrites
  636. 293.18 reads/s, 8204 avg bytes/read, 62.32 writes/s, 38.78 fsyncs/s
  637. -------------------------------------
  638. INSERT BUFFER AND ADAPTIVE HASH INDEX
  639. -------------------------------------
  640. Ibuf: size 1, free list len 14072, seg size 14074, 11592456 merges
  641. merged operations:
  642. insert 12336707, delete mark 274853607, delete 28754017
  643. discarded operations:
  644. insert 0, delete mark 0, delete 0
  645. Hash table size 6225619, node heap has 167 buffer(s)
  646. 2606.47 hash searches/s, 1299.91 non-hash searches/s
  647. ---
  648. LOG
  649. ---
  650. Log sequence number 2303987096755
  651. Log flushed up to 2303987096308
  652. Pages flushed up to 2303985880828
  653. Last checkpoint at 2303985880594
  654. 1 pending log writes, 0 pending chkp writes
  655. 133410571 log i/o's done, 23.85 log i/o's/second
  656. ----------------------
  657. BUFFER POOL AND MEMORY
  658. ----------------------
  659. Total memory allocated 1593704448; in additional pool allocated 0
  660. Dictionary memory allocated 647018
  661. Buffer pool size 96000
  662. Free buffers 8007
  663. Database pages 142275
  664. Old database pages 52493
  665. Modified db pages 557
  666. Pending reads 1
  667. Pending writes: LRU 0, flush list 0, single page 0
  668. Pages made young 116941040, not young 2313215399
  669. 1.42 youngs/s, 5589.27 non-youngs/s
  670. Pages read 295282134, created 5440190, written 312659916
  671. 293.18 reads/s, 1.65 creates/s, 33.75 writes/s
  672. Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 266 / 1000
  673. Pages read ahead 0.13/s, evicted without access 0.00/s, Random read ahead 0.00/s
  674. LRU len: 142275, unzip_LRU len: 14375
  675. I/O sum[128304]:cur[760], unzip sum[127808]:cur[760]
  676. ----------------------
  677. INDIVIDUAL BUFFER POOL INFO
  678. ----------------------
  679. ---BUFFER POOL 0
  680. Buffer pool size 12000
  681. Free buffers 958
  682. Database pages 17728
  683. Old database pages 6564
  684. Modified db pages 88
  685. Pending reads 0
  686. Pending writes: LRU 0, flush list 0, single page 0
  687. Pages made young 14883227, not young 1366348819
  688. 0.22 youngs/s, 630.92 non-youngs/s
  689. Pages read 37128920, created 688829, written 46032172
  690. 33.70 reads/s, 0.22 creates/s, 4.90 writes/s
  691. Buffer pool hit rate 983 / 1000, young-making rate 0 / 1000 not 334 / 1000
  692. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  693. LRU len: 17728, unzip_LRU len: 1818
  694. I/O sum[16038]:cur[95], unzip sum[15976]:cur[95]
  695. ---BUFFER POOL 1
  696. Buffer pool size 12000
  697. Free buffers 964
  698. Database pages 17887
  699. Old database pages 6611
  700. Modified db pages 42
  701. Pending reads 0
  702. Pending writes: LRU 0, flush list 0, single page 0
  703. Pages made young 14832036, not young 1347853892
  704. 0.22 youngs/s, 742.89 non-youngs/s
  705. Pages read 37132279, created 671555, written 31068421
  706. 40.28 reads/s, 0.12 creates/s, 2.25 writes/s
  707. Buffer pool hit rate 986 / 1000, young-making rate 0 / 1000 not 266 / 1000
  708. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  709. LRU len: 17887, unzip_LRU len: 1834
  710. I/O sum[16038]:cur[95], unzip sum[15976]:cur[95]
  711. ---BUFFER POOL 2
  712. Buffer pool size 12000
  713. Free buffers 1019
  714. Database pages 17735
  715. Old database pages 6530
  716. Modified db pages 34
  717. Pending reads 1
  718. Pending writes: LRU 0, flush list 0, single page 0
  719. Pages made young 14456926, not young 1361677290
  720. 0.18 youngs/s, 790.47 non-youngs/s
  721. Pages read 37142751, created 694532, written 32566792
  722. 39.77 reads/s, 0.13 creates/s, 2.40 writes/s
  723. Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 235 / 1000
  724. Pages read ahead 0.13/s, evicted without access 0.00/s, Random read ahead 0.00/s
  725. LRU len: 17735, unzip_LRU len: 1785
  726. I/O sum[16038]:cur[95], unzip sum[15976]:cur[95]
  727. ---BUFFER POOL 3
  728. Buffer pool size 12000
  729. Free buffers 1024
  730. Database pages 17805
  731. Old database pages 6552
  732. Modified db pages 51
  733. Pending reads 0
  734. Pending writes: LRU 0, flush list 0, single page 0
  735. Pages made young 14416382, not young 1369851293
  736. 0.25 youngs/s, 738.29 non-youngs/s
  737. Pages read 37127164, created 652209, written 43677577
  738. 37.80 reads/s, 0.62 creates/s, 6.03 writes/s
  739. Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 259 / 1000
  740. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  741. LRU len: 17805, unzip_LRU len: 1785
  742. I/O sum[16038]:cur[95], unzip sum[15976]:cur[95]
  743. ---BUFFER POOL 4
  744. Buffer pool size 12000
  745. Free buffers 1024
  746. Database pages 17775
  747. Old database pages 6544
  748. Modified db pages 124
  749. Pending reads 0
  750. Pending writes: LRU 0, flush list 0, single page 0
  751. Pages made young 14844262, not young 1383000270
  752. 0.10 youngs/s, 644.31 non-youngs/s
  753. Pages read 36638089, created 685866, written 53663045
  754. 33.98 reads/s, 0.13 creates/s, 8.35 writes/s
  755. Buffer pool hit rate 988 / 1000, young-making rate 0 / 1000 not 237 / 1000
  756. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  757. LRU len: 17775, unzip_LRU len: 1782
  758. I/O sum[16038]:cur[95], unzip sum[15976]:cur[95]
  759. ---BUFFER POOL 5
  760. Buffer pool size 12000
  761. Free buffers 970
  762. Database pages 17722
  763. Old database pages 6560
  764. Modified db pages 88
  765. Pending reads 0
  766. Pending writes: LRU 0, flush list 0, single page 0
  767. Pages made young 14147801, not young 1327998846
  768. 0.08 youngs/s, 692.84 non-youngs/s
  769. Pages read 35559278, created 666045, written 36917203
  770. 35.68 reads/s, 0.12 creates/s, 4.52 writes/s
  771. Buffer pool hit rate 990 / 1000, young-making rate 0 / 1000 not 209 / 1000
  772. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  773. LRU len: 17722, unzip_LRU len: 1805
  774. I/O sum[16038]:cur[95], unzip sum[15976]:cur[95]
  775. ---BUFFER POOL 6
  776. Buffer pool size 12000
  777. Free buffers 1024
  778. Database pages 17740
  779. Old database pages 6537
  780. Modified db pages 71
  781. Pending reads 0
  782. Pending writes: LRU 0, flush list 0, single page 0
  783. Pages made young 15062149, not young 1413480455
  784. 0.27 youngs/s, 730.74 non-youngs/s
  785. Pages read 37952905, created 677723, written 33215113
  786. 39.43 reads/s, 0.23 creates/s, 2.83 writes/s
  787. Buffer pool hit rate 985 / 1000, young-making rate 0 / 1000 not 291 / 1000
  788. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  789. LRU len: 17740, unzip_LRU len: 1776
  790. I/O sum[16038]:cur[95], unzip sum[15976]:cur[95]
  791. ---BUFFER POOL 7
  792. Buffer pool size 12000
  793. Free buffers 1024
  794. Database pages 17883
  795. Old database pages 6595
  796. Modified db pages 59
  797. Pending reads 0
  798. Pending writes: LRU 0, flush list 0, single page 0
  799. Pages made young 14298257, not young 1332939126
  800. 0.10 youngs/s, 618.82 non-youngs/s
  801. Pages read 36600748, created 703431, written 35519593
  802. 32.53 reads/s, 0.08 creates/s, 2.47 writes/s
  803. Buffer pool hit rate 980 / 1000, young-making rate 0 / 1000 not 396 / 1000
  804. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  805. LRU len: 17883, unzip_LRU len: 1790
  806. I/O sum[16038]:cur[95], unzip sum[15976]:cur[95]
  807. --------------
  808. ROW OPERATIONS
  809. --------------
  810. 0 queries inside InnoDB, 0 queries in queue
  811. 1 read views open inside InnoDB
  812. Main thread process no. 10583, id 2329414512, state: sleeping
  813. Number of rows inserted 463254282, updated 120516095, deleted 228648646, read 733055259
  814. 97.83 inserts/s, 13.82 updates/s, 9.83 deletes/s, 6805.20 reads/s
  815. ----------------------------
  816. END OF INNODB MONITOR OUTPUT
  817. ============================
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!