Ever since I upgraded to the new UTW plugin (version 3.14159265), there has been an increased amount of processes being sent to my MySQL server, which eventually causes my server to crash completely. This happens every time a post goes live on my site.
It seems that the issue is that SQL connections are being opened in the plugin, but are never closed. Therefore, SQL processes are running in excess of 5 or 10 minutes before finally breaking, and returning the site to normal. Imagine how many SQL connections get opened on a high-traffic site!
Is anyone else out there having this issue?
Hi, bgswm1.
I don't know if it is related, but after I installed UTW, i am not able to search my posts. Are you able to search? The problem is described in this thread but there is no solution yet. :-/
Best of luck.
Hi Simsen -
Thanks for the comment, however I don't think this is a related issue. I am not having issues with WP's search function, but am just having issues with the UTW plugin overloading the server due to open SQL connections.
I am positive this is the issue because when I activate the plugin and am monitoring the MySQL processes in phpMyAdmin, I see the UTW-specific queries popup and the process timer keeps on counting next to each one until they eventually die at around 5 or 10 minutes. It looks like everytime someone loads a page it opens up one of these queries and leaves it open. Here is one of the queries that is a problem child:
SELECT SQL_CALC_FOUND_ROWS wp_posts . *
FROM wp_posts
LEFT JOIN wp_post2tag p2t ON wp_posts.ID = p2t
Has anyone else had this issue?
bgswm1
simsen