[wp-edu] Email Users plugin causes mysql to hang

[Joseph Ugoretz]

I'm not sure if this is specific in some way to our install, but I thought I'd share because it caused me so much pain before we fixed the problem.

We've been using the plugin "Email Users" on many of our class sites in our fairly large network for a couple of years.  It's always worked very well, even though it's officially not tested on a multisite install.

Then sometime a couple of weeks ago, probably about the time we passed the 2000-user mark as the new semester began, we started having mysql failures several times a day.  Intermittently, at odd times, mysql CPU usage would jump way up--as far as 205%, so it would stop responding until restarted from the command line.  

I tried a lot of different troubleshooting steps, looked at the mysql slow queries log, and found that most of those times the cause was a query to the wp-usermeta table. But other times queries to that same table were going through quickly with no problem. But I could not figure out (my skills are not strong enough) anything beyond that. 

Finally on Wednesday we had someone notice that every time she tried to email all students in her class using the Email Users plugin, that triggered the problem (we only noticed because she tried the email, mysql hung, I restarted mysql, she tried again, and it hung again.)

I deleted that plugin, nobody is using it anymore, and the problem is completely solved.  No more issues and the site is fast and responsive and stable again.

So if you're using this plugin, beware.  It seems to have problems with large installs. 
-- 
Joseph Ugoretz, PhD
Associate Dean of Teaching, Learning and Technology
Macaulay Honors College - CUNY
35 West 67th St.
New York, NY 10023
212.729.2920
http://macaulay.cuny.edu