TTRSS - MySQL Partitioning for really *BIG* tables

Tiny Tiny RSS Development
1

Hello All,

I am running an experiment in mini-datawarehousing - so no data purge - with ttrss and several rss feeds.
My DB is now growing about 8GB in a month (give or take), and mysql is starting to feel sluggish:
In mysql, as in oracle, there is the possibility of partitioning of a db table, and my question is it possible to do the same to the ttrss_enclosures table? How would someone go about it?

Can any of the developers help?

Thanks for a kick ass piece of very nifty software!!

2

my suggestion would be dropping slow-as-molasses innodb and using partitioning on postgresql.

  1. read the documentation re: table partitioning
  2. alter the schema accordingly
  3. figure out a way to create partitions as needed (before insert trigger or w/e)

this isn’t really related to tt-rss.

3

Yes i now. I was wondering if there was code already written about it (i am not a programmer and dont know how to go about .3).
Anyway, thanks for your input.