Guest User

Untitled

a guest
Jul 16th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.43 KB | None | 0 0
  1. [jcarroll@cactusjack ~]$ mysql -uroot mt4 -e 'show full processlist;' |fgrep -v Sleep
  2. Id User Host db Command Time State Info
  3. 1 system user NULL Connect 752108 Waiting for master to send event NULL
  4. 2 system user NULL Connect 0 Has read all relay log; waiting for the slave I/O thread to update it NULL
  5. 956885 mt4 mt-prod-sphinx-4.host.cdc.advance.net:55231 mt4 Query 0 Sending data SELECT entry_id, CRC32(blog_meta_vchar_idx) FROM mt_entry, mt_blog_meta WHERE entry_blog_id = blog_meta_blog_id AND blog_meta_type = 'type' and entry_id >= 709782 and entry_id <= 809781 and entry_status = 2 and entry_class = 'entry' and entry_modified_on > date_sub(NOW(), INTERVAL 36 HOUR)
  6. 956886 mt4 mt-prod-sphinx-3.host.cdc.advance.net:60963 mt4 Query 18 Sending data SELECT entry_id, CRC32(blog_meta_vchar_idx) FROM mt_entry, mt_blog_meta WHERE entry_blog_id = blog_meta_blog_id AND blog_meta_type = 'type' and entry_id >= 3609782 and entry_id <= 3709781 and entry_status = 2 and entry_class = 'entry' and entry_modified_on > date_sub(NOW(), INTERVAL 36 HOUR)
  7. 956887 mt4 mt-prod-sphinx-2.host.cdc.advance.net:50660 mt4 Query 16 Sending data SELECT entry_id, CRC32(blog_meta_vchar_idx) FROM mt_entry, mt_blog_meta WHERE entry_blog_id = blog_meta_blog_id AND blog_meta_type = 'type' and entry_id >= 3609782 and entry_id <= 3709781 and entry_status = 2 and entry_class = 'entry' and entry_modified_on > date_sub(NOW(), INTERVAL 36 HOUR)
  8. 956888 mt4 mt-prod-sphinx-7.host.cdc.advance.net:52831 mt4 Query 17 Sending data SELECT entry_id, CRC32(blog_meta_vchar_idx) FROM mt_entry, mt_blog_meta WHERE entry_blog_id = blog_meta_blog_id AND blog_meta_type = 'type' and entry_id >= 3609782 and entry_id <= 3709781 and entry_status = 2 and entry_class = 'entry' and entry_modified_on > date_sub(NOW(), INTERVAL 36 HOUR)
  9. 956889 mt4 mt-prod-sphinx-5.host.cdc.advance.net:45007 mt4 Query 21 Sending data SELECT entry_id, CRC32(blog_meta_vchar_idx) FROM mt_entry, mt_blog_meta WHERE entry_blog_id = blog_meta_blog_id AND blog_meta_type = 'type' and entry_id >= 209782 and entry_id <= 309781 and entry_status = 2 and entry_class = 'entry' and entry_modified_on > date_sub(NOW(), INTERVAL 36 HOUR)
  10. 956903 root localhost mt4 Query 0 NULL show full processlist
  11. [jcarroll@cactusjack ~]$
Add Comment
Please, Sign In to add comment