Wow! That was super quick!
On 10/08/2013 12:13 AM, Benjamin Lau wrote:
We need to add an index to the stats.db. I mailed Kohsuke privately
that I was looking into this, but it turned out it wasn't to hard to
solve most of the problem with the addition of the following index:
CREATE INDEX plugin_name on plugin (name);
https://github.com/jenkinsci/infra-statistics/pull/1
Enjoy!
Ben
On Mon, Oct 7, 2013 at 9:06 PM, Kohsuke Kawaguchi <[email protected]> wrote:
For a while back, Domi wrote the code [1] that tallies anonymized usage
statistics and parse them into JSON files. This is what drives the plugin
installation count stats in Wiki.
We noticed that some time ago, this started taking very long time to run
[2]. Whereas it used to take an hour or so, now it can run upward of a whole
day!
This is causing a strain on the system, and it blocks other critical
infrastructure jobs from running in a timely fashion.
Can anyone look into the program and see what's causing the problem? Or
perhaps rewrite it so that it can run in a realistic amount of time?
[1] https://github.com/jenkinsci/infra-statistics
[2] https://ci.jenkins-ci.org/job/infra_statistics/buildTimeTrend
--
Kohsuke Kawaguchi
--
You received this message because you are subscribed to the Google Groups
"Jenkins Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
--
Kohsuke Kawaguchi | CloudBees, Inc. | http://cloudbees.com/
Try Jenkins Enterprise, our professional version of Jenkins
--
You received this message because you are subscribed to the Google Groups "Jenkins
Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
