Improving Redmine query performance.

Added by Ben Osheroff almost 5 years ago

I'm working on a new OSS project that aims to speed up web apps with large databases. Redmine is one of our first target codebases. Our initial tests look promising, but in order to really get a good idea of what queries are problems for Remind, we need some information about how big the tables grow in production.

Would any kind soul with access to a redmine database be willing to dump me index statistics from their installation? Specifically I'd need the output of this:

mysql -ABe 'select * from information_schema.statistics where table_schema = "redmine_production"' > schema_stats.tsv

Thanks for your time!

-Ben Osheroff