I'm the manager of framanews.org, a new public instance of Tiny Tiny Rss and we've got a scalabilty problem.
Here's the hardware and software situation :
- Ubuntu 12.04.2 LTS
- Tiny Tiny Rss 1.7.9
- Mysql 5.5.29
- 24Go RAM
- proc i7 4x2,80GHz
As you can see, we don't have shitty hardware
We have 300 users now, with 23 131 feeds (16 994 distincts).
The problem is the update daemon. I can't have all the threads updated in the last half hour (default setting).
My update daemon uses 7 threads, with an interval of 1.
Is there some magic trick I didn't see ? Will using Postgresql help me ? (I have already tuned mysql a lot, it was my first bottleneck, due to disk access).