API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 5th, 2020
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.81 KB | None | 0 0
raw download clone embed print report
  1. #mysql mysql 'SHOW FULL PROCESSLIST'
  2. Id User Host db Command Time State Info Progress
  3. 1 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
  4. 2 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
  5. 4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
  6. 3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
  7. 5 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000
  8. 31793371 manifold localhost ava Sleep 4833 NULL 0.000
  9. 31874617 abb localhost abb Sleep 9 NULL 0.000
  10. 31874629 sjh localhost:46030 sjh Sleep 4 NULL 0.000
  11. 31874636 ph2 localhost:46038 ph2 Sleep 4 NULL 0.000
  12. 31874648 abb localhost:46056 abb Sleep 58 NULL 0.000
  13. 31874649 abb localhost:46058 abb Sleep 58 NULL 0.000
  14. 31874650 stn localhost stn Sleep 8 NULL 0.000
  15. 31874651 abb localhost:46060 abb Sleep 58 NULL 0.000
  16. 31874652 abb localhost:46062 abb Sleep 58 NULL 0.000
  17. 31874658 abb localhost:46074 abb Sleep 58 NULL 0.000
  18. 31874659 abb localhost abb Sleep 8 NULL 0.000
  19. 31874665 abb localhost:46086 abb Sleep 58 NULL 0.000
  20. 31874670 abb localhost:46096 abb Sleep 57 NULL 0.000
  21. 31874673 abb localhost:46102 abb Sleep 57 NULL 0.000
  22. 31874676 abb localhost:46108 abb Sleep 57 NULL 0.000
  23. 31874683 abb localhost:46120 abb Sleep 56 NULL 0.000
  24. 31874685 abb localhost:46124 abb Sleep 56 NULL 0.000
  25. 31874686 abb localhost:46126 abb Sleep 1 NULL 0.000
  26. 31874687 abb localhost:46128 abb Sleep 56 NULL 0.000
  27. 31874688 mei localhost mei Sleep 6 NULL 0.000
  28. 31874689 abb localhost:46130 abb Sleep 56 NULL 0.000
  29. 31874690 abb localhost:46132 abb Sleep 56 NULL 0.000
  30. 31874694 abb localhost:46136 abb Sleep 56 NULL 0.000
  31. 31874695 abb localhost:46138 abb Sleep 56 NULL 0.000
  32. 31874696 abb localhost:46140 abb Sleep 56 NULL 0.000
  33. 31874698 abb localhost:46142 abb Sleep 56 NULL 0.000
  34. 31874699 abb localhost:46144 abb Sleep 56 NULL 0.000
  35. 31874704 abb localhost:46148 abb Sleep 55 NULL 0.000
  36. 31874706 abb localhost:46150 abb Sleep 55 NULL 0.000
  37. 31874707 abb localhost:46152 abb Sleep 55 NULL 0.000
  38. 31874710 mei localhost mei Sleep 5 NULL 0.000
  39. 31874727 abb localhost:46160 abb Sleep 53 NULL 0.000
  40. 31874728 abb localhost:46162 abb Sleep 53 NULL 0.000
  41. 31874741 stn localhost stn Sleep 2 NULL 0.000
  42. 31874750 abb localhost:46178 abb Sleep 51 NULL 0.000
  43. 31874755 sts localhost:46184 sts Sleep 1 NULL 0.000
  44. 31874784 mei localhost mei Sleep 9 NULL 0.000
  45. 31874788 abb localhost:46238 abb Sleep 4 NULL 0.000
  46. 31874793 bri localhost:46246 bri Sleep 4 NULL 0.000
  47. 31874811 pha localhost:46276 pha Sleep 49 NULL 0.000
  48. 31874821 sts localhost:46294 sts Sleep 48 NULL 0.000
  49. 31874824 hol localhost:46298 hol Sleep 48 NULL 0.000
  50. 31874855 acs localhost acs Sleep 5 NULL 0.000
  51. 31874861 sts localhost:46334 sts Sleep 44 NULL 0.000
  52. 31874862 sts localhost:46336 sts Sleep 44 NULL 0.000
  53. 31874874 pha localhost:46356 pha Sleep 3 NULL 0.000
  54. 31874880 abb localhost abb Sleep 3 NULL 0.000
  55. 31874888 mei localhost mei Sleep 2 NULL 0.000
  56. 31874889 mei localhost mei Sleep 2 NULL 0.000
  57. 31874907 mll localhost:46378 mll Sleep 0 NULL 0.000
  58. 31874915 bri localhost:46390 bri Sleep 0 NULL 0.000
  59. 31874922 mei localhost mei Sleep 9 NULL 0.000
  60. 31874955 sts localhost:46446 sts Sleep 36 NULL 0.000
  61. 31874977 mll localhost:46486 mll Sleep 0 NULL 0.000
  62. 31874987 sts localhost:46496 sts Sleep 35 NULL 0.000
  63. 31875006 ph2 localhost:46532 ph2 Sleep 34 NULL 0.000
  64. 31875007 mll localhost:46534 mll Sleep 4 NULL 0.000
  65. 31875008 bri localhost:46536 bri Sleep 4 NULL 0.000
  66. 31875015 abb localhost:46546 abb Sleep 4 NULL 0.000
  67. 31875023 mei localhost mei Sleep 34 NULL 0.000
  68. 31875024 ava localhost:46558 ava Sleep 34 NULL 0.000
  69. 31875054 mei localhost:46602 mei Sleep 32 NULL 0.000
  70. 31875055 mei localhost:46604 mei Sleep 32 NULL 0.000
  71. 31875056 mei localhost:46606 mei Sleep 32 NULL 0.000
  72. 31875057 mei localhost:46608 mei Sleep 32 NULL 0.000
  73. 31875058 mei localhost:46610 mei Sleep 32 NULL 0.000
  74. 31875059 mei localhost:46612 mei Sleep 32 NULL 0.000
  75. 31875060 mei localhost:46614 mei Sleep 32 NULL 0.000
  76. 31875061 mei localhost:46616 mei Sleep 32 NULL 0.000
  77. 31875064 mei localhost:46622 mei Sleep 32 NULL 0.000
  78. 31875082 mei localhost:46648 mei Sleep 31 NULL 0.000
  79. 31875083 mei localhost:46650 mei Sleep 31 NULL 0.000
  80. 31875084 mei localhost:46652 mei Sleep 31 NULL 0.000
  81. 31875087 mei localhost:46654 mei Sleep 30 NULL 0.000
  82. 31875089 mei localhost:46658 mei Sleep 30 NULL 0.000
  83. 31875094 mei localhost:46664 mei Sleep 30 NULL 0.000
  84. 31875097 mei localhost:46666 mei Sleep 29 NULL 0.000
  85. 31875099 mei localhost mei Sleep 9 NULL 0.000
  86. 31875102 mei localhost:46670 mei Sleep 29 NULL 0.000
  87. 31875103 abb localhost abb Sleep 9 NULL 0.000
  88. 31875104 mei localhost:46672 mei Sleep 29 NULL 0.000
  89. 31875112 abb localhost abb Sleep 8 NULL 0.000
  90. 31875113 mei localhost:46682 mei Sleep 28 NULL 0.000
  91. 31875115 mei localhost:46686 mei Sleep 28 NULL 0.000
  92. 31875122 mei localhost:46696 mei Sleep 27 NULL 0.000
  93. 31875123 mei localhost:46698 mei Sleep 27 NULL 0.000
  94. 31875126 mei localhost:46702 mei Sleep 27 NULL 0.000
  95. 31875127 mei localhost:46704 mei Sleep 27 NULL 0.000
  96. 31875161 mei localhost mei Sleep 6 NULL 0.000
  97. 31875206 bri localhost:46822 bri Sleep 22 NULL 0.000
  98. 31875216 bri localhost:46826 bri Sleep 22 NULL 0.000
  99. 31875223 bri localhost:46838 bri Sleep 21 NULL 0.000
  100. 31875265 mei localhost mei Sleep 0 NULL 0.000
  101. 31875287 mei localhost mei Sleep 9 NULL 0.000
  102. 31875313 hhx localhost:46994 hhx Sleep 18 NULL 0.000
  103. 31875321 mei localhost mei Sleep 7 NULL 0.000
  104. 31875323 ph2 localhost:47004 ph2 Sleep 2 NULL 0.000
  105. 31875346 bri localhost:47026 bri Sleep 16 NULL 0.000
  106. 31875347 bri localhost:47028 bri Sleep 16 NULL 0.000
  107. 31875356 ph2 localhost:47042 ph2 Sleep 0 NULL 0.000
  108. 31875370 bri localhost:47054 bri Sleep 14 NULL 0.000
  109. 31875373 mei localhost:47060 mei Sleep 13 NULL 0.000
  110. 31875374 abb localhost abb Sleep 3 NULL 0.000
  111. 31875375 mei localhost mei Sleep 1 NULL 0.000
  112. 31875376 pha localhost:47062 pha Sleep 13 NULL 0.000
  113. 31875414 mll localhost:47118 mll Sleep 12 NULL 0.000
  114. 31875417 sjh localhost:47120 sjh Sleep 1 NULL 0.000
  115. 31875421 abb localhost abb Sleep 1 NULL 0.000
  116. 31875432 pha localhost:47140 pha Sleep 11 NULL 0.000
  117. 31875434 mei localhost mei Sleep 0 NULL 0.000
  118. 31875439 abb localhost abb Sleep 0 NULL 0.000
  119. 31875443 pha localhost:47154 pha Sleep 10 NULL 0.000
  120. 31875470 mei localhost mei Sleep 0 NULL 0.000
  121. 31875472 bri localhost bri Sleep 0 NULL 0.000
  122. 31875474 pha localhost:47182 pha Sleep 8 NULL 0.000
  123. 31875475 pha localhost:47184 pha Sleep 7 NULL 0.000
  124. 31875479 pha localhost:47186 pha Sleep 6 NULL 0.000
  125. 31875480 mei localhost mei Sleep 5 NULL 0.000
  126. 31875482 bri localhost bri Sleep 5 NULL 0.000
  127. 31875483 bri localhost bri Sleep 1 NULL 0.000
  128. 31875489 abb localhost abb Sleep 4 NULL 0.000
  129. 31875515 abb localhost abb Sleep 2 NULL 0.000
  130. 31875516 abb localhost abb Sleep 2 NULL 0.000
  131. 31875519 abb localhost abb Sleep 2 NULL 0.000
  132. 31875531 mll localhost:47256 mll Sleep 1 NULL 0.000
  133. 31875533 abb localhost abb Sleep 1 NULL 0.000
  134. 31875555 bri localhost bri Sleep 1 NULL 0.000
  135. 31875557 abb localhost:47304 abb Sleep 1 NULL 0.000
  136. 31875567 rem localhost:47324 rem Sleep 1 NULL 0.000
  137. 31875569 mei localhost mei Sleep 0 NULL 0.000
  138. 31875571 mll localhost mll Sleep 0 NULL 0.000
  139. 31875578 abb localhost:47340 abb Query 0 Sending data (SELECT 'REDACTED'type, a.REDACTED id, GROUP_CONCAT(REDACTED.beginDate)start, GROUP_CONCAT(REDACTED.endDate)stop, GROUP_CONCAT(REDACTED.timeless)timeless, a.REDACTED, 0 repeating, (SELECT REDACTED FROM REDACTED WHERE REDACTEDID = a.REDACTEDID) REDACTED, b.REDACTED, b.REDACTED, CONCAT(if(a.REDACTED<>'',a.REDACTED,b.REDACTED2),' - ',b.REDACTED3) area, a.text, (REDACTED > 0 or (SELECT 1 FROM REDACTED WHERE REDACTED = a.REDACTED limit 1) IS NOT NULL) REDACTED, a.REDACTED, a.REDACTED, a.REDACTED, (select REDACTED from REDACTED where REDACTED = a.REDACTED and type = '' limit 1) status2, null `accessible`, (select REDACTED from REDACTED where REDACTEDID=a.REDACTEDID)nomm, a.stype FROM REDACTED a left join REDACTED b on b.REDACTEDID=a.REDACTEDID left join REDACTED on REDACTED.doc=a.REDACTEDID WHERE a.REDACTED = 'Some Type' and REDACTED.beginDate >= '2020-05-31 00:00:00.0' AND REDACTED.beginDate < '2020-06-07 00:00:00.0' group by doc) union all (SELECT 'dbbb'type, id, start, stop, '0', tech, repeating<>0 and (select 1 from REDACTED where REDACTED=a.REDACTED and start>a.start limit 1), null, null, null, null, notes, start<date(now()) - interval 2 week, null, null, null, null, null `accessible`, null REDACTED, null stype from REDACTED a where start>='2020-05-31 00:00:00.0' and start<'2020-06-07 00:00:00.0') ORDER BY start, stop DESC, type, id/*1590897600000;1590897600000,1591502400000*/ 0.000
  140. 31875580 hhx localhost:47342 hhx Sleep 0 NULL 0.000
  141. 31875581 abb localhost abb Sleep 0 NULL 0.000
  142. 31875583 ph2 localhost:47344 ph2 Sleep 0 NULL 0.000
  143. 31875585 root localhost mysql Query 0 Init SHOW FULL PROCESSLIST 0.000
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!