continuum-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brent N Atkinson (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CONTINUUM-2759) Document how to tune performance for installations with large databases
Date Thu, 30 Apr 2015 20:40:06 GMT

     [ https://issues.apache.org/jira/browse/CONTINUUM-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Brent N Atkinson updated CONTINUUM-2759:
----------------------------------------
    Description: 
For users wishing to run Continuum in scenarios where the data set will grow to a large scale,
instructions on how to go about tuning the database should be documented.

Continuum 1.5 addresses multiple performance and stability issues. The net result is that
it should now be possible to run Continuum with much larger databases if properly tuned. Ideally,
this tuning would be automatic. However, this is not generally possible due to supporting
multiple deployment scenarios and databases.

The following should be documented:
  * How to configure Continuum to use derbynet data sources
  * How to enable derby query execution plan logging
  * How to upgrade derby databases to gain optimizer statistics
  * Common bottlenecks and tuning advice:
  ** Creating/rebuilding indexes for long queries/large tables
  ** Updating statistics


  was:
For users wishing to run Continuum in scenarios where the data set will grow to a large scale,
instructions on how to go about tuning the database should be documented.

Continuum 1.5 addresses multiple performance and stability issues. The net result is that
it should now be possible to run Continuum with much larger databases if properly tuned. Ideally,
this tuning would be automatic. However, this is not generally possible due to supporting
multiple deployment scenarios and databases.

The following should be documented:
  * How to configure Continuum to use derbynet data sources
  * How to enable derby query execution plan logging
  * How to upgrade derby databases to gain optimizer statistics
  * Common bottlenecks and tuning advice:
    * Creating/rebuilding indexes for long queries/large tables
    * Updating statistics



> Document how to tune performance for installations with large databases
> -----------------------------------------------------------------------
>
>                 Key: CONTINUUM-2759
>                 URL: https://issues.apache.org/jira/browse/CONTINUUM-2759
>             Project: Continuum
>          Issue Type: Task
>            Reporter: Brent N Atkinson
>            Assignee: Brent N Atkinson
>             Fix For: 1.5.0
>
>
> For users wishing to run Continuum in scenarios where the data set will grow to a large
scale, instructions on how to go about tuning the database should be documented.
> Continuum 1.5 addresses multiple performance and stability issues. The net result is
that it should now be possible to run Continuum with much larger databases if properly tuned.
Ideally, this tuning would be automatic. However, this is not generally possible due to supporting
multiple deployment scenarios and databases.
> The following should be documented:
>   * How to configure Continuum to use derbynet data sources
>   * How to enable derby query execution plan logging
>   * How to upgrade derby databases to gain optimizer statistics
>   * Common bottlenecks and tuning advice:
>   ** Creating/rebuilding indexes for long queries/large tables
>   ** Updating statistics



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message