MySQL Performance
I fixed it in my github fork (https://github.com/koehn/selfoss) and submitted a pull request (https://github.com/SSilence/selfoss/pull/438).
I went from 20,000 mysql queries per update down to 100, and from 100% CPU for 1.5 minutes down to 1% cpu for 8 seconds.
Complete thread:
- MySQL Performance -
bekoehn,
2013-09-06, 05:55
- MySQL Performance - bekoehn, 2013-09-11, 17:26
- MySQL Performance - bekoehn, 2013-10-03, 20:28
- MySQL Performance -
bekoehn,
2013-10-04, 00:51
- MySQL Performance - MidSpeck, 2013-10-04, 02:43