Slow Admin Side

My IT guy said mysql was working harder than it probably should….

The only way anyone is going to be able to help is for you to find out exactly which queries are running long.

We recently updated a several plugins about two days ago…

What plugins?

I think the problem may be related to Follow Up Emails Queries. There are a ton of them each time I try and load a page.

Slow Database Queries (above 0.05s)
Query Caller Time
SELECT comment_approved, COUNT( * ) AS num_comments
FROM wp_comments
WHERE comment_type NOT IN(‘order_note’,’action_log’)
GROUP BY comment_approved
ActionScheduler_wpCommentLogger->filter_comment_count+ 0.3839
SELECT SQL_CALC_FOUND_ROWS id
FROM wp_followup_email_orders
WHERE 1=1
AND email_id IN (‘67124′,’111271’)
FUE_Sending_Scheduler->get_items+ 0.4119
SELECT post_status, COUNT( * ) AS num_posts
FROM wp_posts
WHERE post_type = ‘shop_order’
GROUP BY post_status
wp_count_posts+ 0.1547
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
WHERE 1=1
AND wp_posts.post_type = ‘shop_order’
AND ((wp_posts.post_status = ‘wc-pending’
OR wp_posts.post_status = ‘wc-processing’
OR wp_posts.post_status = ‘wc-on-hold’
OR wp_posts.post_status = ‘wc-completed’
OR wp_posts.post_status = ‘wc-cancelled’
OR wp_posts.post_status = ‘wc-refunded’
OR wp_posts.post_status = ‘wc-failed’))
ORDER BY wp_posts.post_date DESC
LIMIT 0, 20
WP_Query->get_posts+ 0.1880
SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month
FROM wp_posts
WHERE post_type = ‘shop_order’
ORDER BY post_date DESC
WP_List_Table->months_dropdown+ 0.1265
SELECT order_item_id, order_item_name, order_item_type
FROM wp_woocommerce_order_items
WHERE order_id = 259312
AND order_item_type IN ( ‘line_item’ )
ORDER BY order_item_id;
WC_Abstract_Order->get_items+ 0.0532

Deactivate that plugin for a minute and see if admin speeds up. If not, deactivate the other plugin you recently updated.

The Follow Up Emails plugin for WooCommerce is causing all sorts of issues for us. I have deactivated portions of it. I have notified their development team and I believe they are working the issue.

Deactivating the plugin has helped. The admin side is running much faster now. The only issue now is a slow Dashboard for some reason. Now its taking 30-60 seconds to load. Here are the types of queries I am getting now:

SELECT *
FROM wp_comments
LEFT JOIN wp_posts
ON comment_post_ID = wp_posts.ID
WHERE ( ( comment_approved = ‘0’
OR comment_approved = ‘1’ ) )
AND wp_posts.post_type NOT IN (‘shop_order’,’shop_order_refund’,’shop_subscription’)
AND wp_posts.post_type <> ‘shop_webhook’
AND wp_comments.comment_type != ‘action_log’
ORDER BY wp_comments.comment_date_gmt DESC
LIMIT 475,50
WP_Comment_Query->get_comments+ 0.0548

Ton of those now that were not there before.