MySQL Performance

by bekoehn, Wednesday, September 11, 2013, 17:26 (4238 days ago) @ bekoehn

I was asked to provide some context for my issue, so here:

1.7 GB RAM (Amazon EC2 Small Instance)
Mysql 5.5.32
PHP 5.4.9
Apache 2.2.22
mod-fcgid 2.3.7
SO 2.8

I stripped out a bunch of inactive feeds, but SO is still using all CPU between PHP and MySQL for about 30 seconds during updates. I'm not sure how to diagnose the issue; I'm a very experienced developer but not with PHP or MySQL.

I'm running the update via cron:
*/5 * * * * php /var/www/selfoss/update.php