Skip to content

Instantly share code, notes, and snippets.

@rfay

rfay/processlist.txt

Created April 17, 2012 18:40
Show Gist options
  • Save rfay/2408107 to your computer and use it in GitHub Desktop.
Save rfay/2408107 to your computer and use it in GitHub Desktop.
Download ZIP
Warmshowers show full processlist
Raw
processlist.txt
Id User Host db Command Time State Info
803590 rfay_db localhost warmshowers Query 24 Copying to tmp table SELECT ncs.last_comment_timestamp, IF (ncs.last_comment_uid != 0, u2.name, ncs.last_comment_name) AS last_comment_name, ncs.last_comment_uid FROM node n INNER JOIN users u1 ON n.uid = u1.uid INNER JOIN term_node tn ON n.vid = tn.vid INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u2 ON ncs.last_comment_uid=u2.uid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND tn.tid = 6 )ORDER BY ncs.last_comment_timestamp DESC LIMIT 0, 1
803611 rfay_db localhost warmshowers Query 552 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803621 rfay_db localhost warmshowers Query 518 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803631 rfay_db localhost warmshowers Query 497 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'es' WHERE (n.language ='es' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803635 rfay_db localhost warmshowers Query 489 Copying to tmp table SELECT tid, COUNT(nid) AS topic_count, SUM(nid_comment_count) AS comment_count\n FROM (\n SELECT r.tid AS tid, n.nid AS nid, l.comment_count AS nid_comment_count\n FROM node n\n INNER JOIN node_comment_statistics l ON n.nid = l.nid\n INNER JOIN term_node r ON n.vid = r.vid\n LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1\n )GROUP BY r.tid, n.nid, l.comment_count) AS forum_content_list\n GROUP BY tid
803637 rfay_db localhost warmshowers Query 446 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'pt-br' WHERE (n.language ='pt-br' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803649 rfay_db localhost warmshowers Query 437 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803688 rfay_db localhost warmshowers Query 322 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803698 rfay_db localhost warmshowers Query 291 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'es' WHERE (n.language ='es' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803723 rfay_db localhost warmshowers Query 177 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'es' WHERE (n.language ='es' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803748 rfay_db localhost warmshowers Query 138 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'es' WHERE (n.language ='es' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803749 rfay_db localhost warmshowers Query 107 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'es' WHERE (n.language ='es' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803752 rfay_db localhost warmshowers Query 104 Copying to tmp table SELECT n.nid, n.title, l.comment_count FROM node n INNER JOIN term_node tn ON tn.vid = n.vid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_comment_statistics l ON n.nid = l.nid LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'es' WHERE (n.language ='es' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 AND td.vid = 4 )ORDER BY n.nid DESC LIMIT 0, 5
803781 rfay_db localhost warmshowers Query 41 Copying to tmp table SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 10 LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 )ORDER BY n.sticky DESC, l.last_comment_timestamp DESC
803799 rfay_db localhost warmshowers Query 2 Copying to tmp table SELECT n.nid, n.title, n.sticky, l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid AND r.tid = 6 LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'fr' WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL OR n.language = 'en-working' AND i18n.nid IS NULL) AND ( n.status = 1 )ORDER BY n.sticky DESC, l.last_comment_timestamp DESC
803800 rfay_db localhost warmshowers Sleep 0 NULL
803801 root localhost NULL Query 0 NULL show full processlist
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment