That’s an RSS instigated query – I will need to check which flavour but I am 99% sure it is an RSS feed query. I will find out which one.

Yes – that is the ‘All’ RSS feed query.

It’s not a particularly heavy or complex query and certainly shows no red flags upon monitoring.

On my system it’s runs very heavy.  Have all of your tables been join and index optimized?  How often does this query run?  I have to resolve this issue immediately.  It’s an emergency.  Is there a way to turn off this query or turn off RSS?

# Time: 120821 21:52:45
# Query_time: 26  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT  wp_sfposts.post_id, post_content, DATE_SUB(post_date, INTERVAL 2 HOUR) as post_date, wp_sfposts.topic_id, wp_sfposts.forum_id,
                                                                  wp_sfposts.user_id, guest_name, post_status, post_index, forum_name, forum_slug, group_id,
                                                                  topic_name, topic_slug, wp_sftopics.post_count, display_name FROM wp_sfposts JOIN wp_sfforums ON wp_sfforums.forum$
# User@Host: snffx_www[snffx_www] @ localhost []
# Query_time: 26  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT  wp_sfposts.post_id, post_content, DATE_SUB(post_date, INTERVAL 2 HOUR) as post_date, wp_sfposts.topic_id, wp_sfposts.forum_id,
                                                                  wp_sfposts.user_id, guest_name, post_status, post_index, forum_name, forum_slug, group_id,
                                                                  topic_name, topic_slug, wp_sftopics.post_count, display_name FROM wp_sfposts JOIN wp_sfforums ON wp_sfforums.forum$

# Query_time: 26  Lock_tme: 0  Rows_sent: 0  Rows_examined: 0
SELECT  wp_sfposts.post_id, post_content, DATE_SUB(post_date, INTERVAL 2 HOUR) as post_date, wp_sfposts.topic_id, wp_sfposts.forum_id,
                                                                  wp_sfposts.user_id, guest_name, post_status, post_index, forum_name, forum_slug, group_id,
                                                                  topic_name, topic_slug, wp_sftopics.post_count, display_name FROM wp_sfposts JOIN wp_sfforums ON wp_sfforums.forum$
# Time: 120821 21:52:54
# Query_time: 35  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT  wp_sfposts.post_id, post_content, DATE_SUB(post_date, INTERVAL 2 HOUR) as post_date, wp_sfposts.topic_id, wp_sfposts.forum_id,
                                                                  wp_sfposts.user_id, guest_name, post_status, post_index, forum_name, forum_slug, group_id,
                                                                  topic_name, topic_slug, wp_sftopics.post_count, display_name FROM wp_sfposts JOIN wp_sfforums ON wp_sfforums.forum$

# Query_time: 65  Lock_time: 30  Rows_sent: 0  Rows_examined: 0
SELECT  wp_sfposts.post_id, post_content, DATE_SUB(post_date, INTERVAL 2 HOUR) as post_date, wp_sfposts.topic_id, wp_sfposts.forum_id,
                                                                  wp_sfposts.user_id, guest_name, post_status, post_index, forum_name, forum_slug, group_id,
                                                                  topic_name, topic_slug, wp_sftopics.post_count, display_name FROM wp_sfposts JOIN wp_sfforums ON wp_sfforums.forum$

# Query_time: 35  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT  wp_sfposts.post_id, post_content, DATE_SUB(post_date, INTERVAL 2 HOUR) as post_date, wp_sfposts.topic_id, wp_sfposts.forum_id,
                                                                  wp_sfposts.user_id, guest_name, post_status, post_index, forum_name, forum_slug, group_id,
                                                                  topic_name, topic_slug, wp_sftopics.post_count, display_name FROM wp_sfposts JOIN wp_sfforums ON wp_sfforums.forum$
# Time: 120821 21:53:00
# User@Host: snffx_www[snffx_www] @ localhost []
# Query_time: 41  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT  wp_sfposts.post_id, post_content, DATE_SUB(post_date, INTERVAL 2 HOUR) as post_date, wp_sfposts.topic_id, wp_sfposts.forum_id,
                                                                  wp_sfposts.user_id, guest_name, post_status, post_index, forum_name, forum_slug, group_id,
                                                                  topic_name, topic_slug, wp_sftopics.post_count, display_name FROM wp_sfposts JOIN wp_sfforums ON wp_sfforums.forum$

I might be onto something.  Is your query triggered by cron job? Does this line of code trigger the long running query?

$rss = fetch_feed(‘http://www.fantasyfootballxtreme.com/forums/rss/d3d98b8e-dfd0-40fc-a37e-efc3d05a0743/’);

I have a forum activity module in my page so i can show current activity.  I couldn’t figure out how to do this correctly with your code so i just grabbed it as a feed.  Maybe because i was running this on ever page load, even though i was caching, it was calling your RSS code?  here was my code. Do not try this at home.

include_once(ABSPATH . WPINC . ‘/feed.php’);
            
            function cache_duration( $seconds )
            {
                // change the default feed cache recreation period to 15 minutes
                return 900;
            }

            // Get a SimplePie feed object from the specified feed source while controlling cache time
            add_filter( ‘wp_feed_cache_transient_lifetime’ , ‘cache_duration’ );
            $rss = fetch_feed(‘http://www.fantasyfootballxtreme.com/forums/rss/d3d98b8e-dfd0-40fc-a37e-efc3d05a0743/’);
            remove_filter( ‘wp_feed_cache_transient_lifetime’ , ‘cache_duration’ );
            
            if (!is_wp_error( $rss ) ) : // Checks that the object is created correctly
                // Figure out how many total items there are, but limit it to 5.
                $maxitems = $rss->get_item_quantity(5);

                // Build an array of all the items, starting with element 0 (first element).
                $rss_items = $rss->get_items(0, $maxitems);
            endif;
            ?>

                <ul class=”vertical”>
                    <?php if ($maxitems == 0) echo ‘<li>Trouble loading… Try refreshing the page.</li>’;
                    else
                    // Loop through each feed item and display each item as a hyperlink.
                    foreach ( $rss_items as $item ) : ?>
                    <li class=”cat-item forum-item-“>
                        <a href='<?php echo esc_url( $item->get_permalink() ); ?>’
                        title='<?php echo ‘Posted ‘.$item->get_date(‘j F Y | g:i a’); ?>’>
                        <?php echo esc_html( $item->get_title() ); ?></a>
                    </li>
                    <?php endforeach; ?>
                </ul>
            </div>

It’s not a cron job it is on request but yes – that code will run it. For whatever user that feedkey belongs to.

show current activity?? do you just want to show the latest posts?  we provide multiple template tags for doing that in the template tags plugin…