Nov 24
While debugging an application, MySQL was crashing and the log was sent over to me. There were hundreds of the same SELECT query (that wasn’t tuned too).
After hunting it down, this query was run for every RSS query, calculating the last time the event was updated.
We changed this value to be cached (in-memory speed for lookup on each request) and the issue died.