API tools faq
paste
Guest User

Untitled

a guest
Jun 12th, 2018
216
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.64 KB | None | 0 0
raw download clone embed print report
  1. mysql> show processlist;
  2. +--------+-------------+--------------------+------+---------+--------+----------------------------------+------------------------------------------------------------------------------------------------------+
  3. | Id | User | Host | db | Command | Time | State | Info |
  4. +--------+-------------+--------------------+------+---------+--------+----------------------------------+------------------------------------------------------------------------------------------------------+
  5. | 1 | system user | | NULL | Connect | 226953 | Waiting for master to send event | NULL |
  6. | 2 | system user | | v3 | Connect | 35042 | Locked | update postings a
  7. left join cities b on b.id=a.job_city_id
  8. left join states h on h.id=b.stat |
  9. | 313888 | irnadmin | 172.19.0.239:40136 | v3 | Sleep | 0 | | NULL |
  10. | 314075 | irnadmin | 172.19.0.239:41113 | v3 | Sleep | 0 | | NULL |
  11. | 314118 | irnadmin | 172.19.0.239:41282 | v3 | Query | 34978 | freeing items | SELECT id, screen_name, type, active, bound, LastLogin, robotno, protocol FROM accounts WHERE email_ |
  12. | 314686 | irnadmin | 172.19.0.239:43251 | v3 | Sleep | 0 | | NULL |
  13. | 314732 | irnadmin | 172.19.0.239:43436 | v3 | Query | 34978 | freeing items | SELECT id, screen_name, type, active, bound, LastLogin, robotno, protocol FROM accounts WHERE email_ |
  14. | 314984 | irnadmin | 172.19.0.239:44366 | v3 | Sleep | 2 | | NULL |
  15. | 315051 | irnadmin | 172.19.0.239:44713 | v3 | Query | 0 | NULL | NULL |
  16. | 315198 | irnadmin | 172.19.0.239:51569 | v3 | Sleep | 2 | | NULL |
  17. | 315280 | irnadmin | 172.19.0.239:51849 | v3 | Query | 34978 | freeing items | SELECT id, email_address, type, closed, robotno FROM accounts WHERE screen_name = 'ShantanuS' |
  18. | 315320 | irnadmin | 172.19.0.239:52045 | v3 | Query | 34978 | freeing items | SELECT id, screen_name, type, active, bound, LastLogin, robotno, protocol FROM accounts WHERE email_ |
  19. | 315384 | irnadmin | 172.19.0.239:52463 | v3 | Sleep | 1 | | NULL |
  20. | 452248 | irnadmin | 172.19.0.28:54899 | v3 | Query | 34978 | freeing items | SELECT id, email_address, type, closed, robotno FROM accounts WHERE screen_name = 'LIZW0218' |
  21. | 452291 | irnadmin | 172.19.0.28:55045 | v3 | Sleep | 1 | | NULL |
  22. | 452316 | irnadmin | 172.19.0.28:55144 | v3 | Sleep | 0 | | NULL |
  23. | 452353 | irnadmin | 172.19.0.28:55278 | v3 | Sleep | 0 | | NULL |
  24. | 452382 | irnadmin | 172.19.0.28:55371 | v3 | Query | 34978 | freeing items | SELECT o.account_id FROM online o JOIN accounts a ON a.id=o.account_id WHERE o.server_id IS NULL AND |
  25. | 452413 | irnadmin | 172.19.0.28:55479 | v3 | Sleep | 1 | | NULL |
  26. | 452541 | irnadmin | 172.19.0.28:55946 | v3 | Query | 34978 | freeing items | SELECT o.account_id FROM online o JOIN accounts a ON a.id=o.account_id WHERE o.server_id IS NULL AND |
  27. | 452626 | irnadmin | 172.19.0.28:56215 | v3 | Sleep | 2 | | NULL |
  28. | 452711 | irnadmin | 172.19.0.28:39916 | v3 | Sleep | 0 | | NULL |
  29. | 452781 | irnadmin | 172.19.0.28:40161 | v3 | Sleep | 1 | | NULL |
  30. | 452904 | irnadmin | 172.19.0.28:40955 | v3 | Query | 34978 | freeing items | select a.id, aa.screen_name, i.requester from interview_requests i left join accounts aa on aa.id=i. |
  31. | 453014 | irnadmin | 172.19.0.28:41291 | v3 | Query | 34978 | freeing items | SELECT o.account_id FROM online o JOIN accounts a ON a.id=o.account_id WHERE o.server_id IS NULL AND |
  32. | 453057 | irnadmin | 172.19.0.28:41377 | v3 | Query | 34978 | freeing items | select a.id, aa.screen_name, i.requester from interview_requests i left join accounts aa on aa.id=i. |
  33. | 453084 | irnadmin | 172.19.0.28:41441 | v3 | Sleep | 0 | | NULL |
  34. | 453112 | irnadmin | 172.19.0.28:41536 | v3 | Sleep | 0 | | NULL |
  35. | 453156 | irnadmin | 172.19.0.28:41653 | v3 | Query | 34978 | freeing items | SELECT protocol FROM accounts WHERE email_address= 'caroline.rosch40gmail.com@gtalk.jabber.jobirn.c |
  36. | 453214 | irnadmin | 172.19.0.28:41800 | v3 | Sleep | 5 | | NULL |
  37. | 453243 | irnadmin | 172.19.0.28:41991 | v3 | Sleep | 0 | | NULL |
  38. | 453313 | irnadmin | 172.19.0.28:42255 | v3 | Query | 34978 | freeing items | SELECT o.account_id FROM online o JOIN accounts a ON a.id=o.account_id WHERE o.server_id IS NULL AND |
  39. | 453396 | irnadmin | 172.19.0.28:53718 | v3 | Sleep | 2 | | NULL |
  40. | 453476 | irnadmin | 172.19.0.28:54019 | v3 | Sleep | 0 | | NULL |
  41. | 453561 | irnadmin | 172.19.0.28:54352 | v3 | Sleep | 3 | | NULL |
  42. | 453594 | irnadmin | 172.19.0.28:54456 | v3 | Sleep | 0 | | NULL |
  43. | 453727 | irnadmin | 172.19.0.28:55166 | v3 | Query | 34978 | freeing items | SELECT id, screen_name, type, active, bound, LastLogin, robotno, protocol FROM accounts WHERE email_ |
  44. | 453786 | irnadmin | 172.19.0.28:55320 | v3 | Sleep | 4 | | NULL |
  45. | 610140 | irnadmin | 172.19.0.28:33848 | v3 | Query | 34978 | freeing items | select a.id, aa.screen_name, i.requester from interview_requests i left join accounts aa on aa.id=i. |
  46. | 685119 | irnadmin | 172.19.0.27:37251 | v3 | Query | 34980 | Sending data | select postings.id id,category, job_desc_title,
  47. IF(c1.name is not null,c1.name,IF(c2.name is not n |
  48. | 685226 | irnadmin | 172.19.0.139:57274 | v3 | Query | 34735 | Locked | SELECT job_desc_title,job_desc,job_state_name,job_city_name,company_categories.name,postings.categor |
  49. | 685229 | irnadmin | 172.19.0.139:57278 | v3 | Query | 34735 | Locked | SELECT job_desc_title,job_desc,job_state_name,job_city_name,company_categories.name,postings.categor |
  50. | 685232 | irnadmin | 172.19.0.139:57283 | v3 | Query | 34734 | Locked | select job_desc_title,job_desc from postings where id=287650 |
  51. | 685233 | irnadmin | 172.19.0.139:57286 | v3 | Query | 34734 | Locked | SELECT accounts.screen_name,postings.url url, accounts.type owner_type, postings.id ID, postings.job |
  52. | 685235 | irnadmin | 172.19.0.28:37502 | v3 | Query | 34734 | Locked | SELECT accounts.screen_name,postings.url url, accounts.type owner_type, postings.id ID, postings.job |
  53. | 686496 | irnadmin | 172.19.0.239:33306 | v3 | Query | 32589 | Locked | SELECT accounts.screen_name,postings.url url, accounts.type owner_type, postings.id ID, postings.job |
  54. | 686503 | irnadmin | 172.19.0.28:54051 | v3 | Query | 32588 | Locked | SELECT job_desc_title, job_desc, IF(postings.category IS NOT NULL, postings.category, job_categories |
  55. | 709550 | root | localhost | v3 | Query | 0 | NULL | show processlist |
  56. | 710084 | irnadmin | 172.19.0.27:53285 | NULL | Query | 0 | removing tmp table | show status where Variable_name='Threads_running' |
  57. +--------+-------------+--------------------+------+---------+--------+----------------------------------+------------------------------------------------------------------------------------------------------+
  58. 49 rows in set (0.00 sec)
  59.  
  60. SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
  61.  
  62. SELECT VERSION()
  63.  
  64. mysql show processlist
  65. | grep -v '^+--'
  66. | grep -v '^| Id'
  67. | sort -n -k12
  68.  
  69. mysql show processlist
  70. | grep -v '^+--'
  71. | grep -v '^| Id'
  72. | grep -v '^[0-9][0-9]* rows in set '
  73. | grep -v '^ '
  74. | sort -n -k12
  75.  
  76. host=maindb
  77.  
  78. echo "show full processlistG" | mysql -h$host | grep -B 6 -A 1 Locked
  79.  
  80. host=maindb
  81.  
  82. echo "show full processlistG" | mysql -h$host | grep -B 6 -A 1 Sleep
  83.  
  84. host=maindb
  85.  
  86. user=me
  87.  
  88. password=mycoolpassword
  89.  
  90. echo "show full processlistG" | mysql -h$host -u$user -p$password | grep -B 6 -A 1 Locked
Add Comment
Please, Sign In to add comment
Public Pastes
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!