Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [jcarroll@cactusjack ~]$ mysql -uroot mt4 -e 'show full processlist;' |fgrep -v Sleep
- Id User Host db Command Time State Info
- 1 system user NULL Connect 752108 Waiting for master to send event NULL
- 2 system user NULL Connect 0 Has read all relay log; waiting for the slave I/O thread to update it NULL
- 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)
- 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)
- 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)
- 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)
- 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)
- 956903 root localhost mt4 Query 0 NULL show full processlist
- [jcarroll@cactusjack ~]$
Add Comment
Please, Sign In to add comment