← Back to team overview

dhis2-users team mailing list archive

Re: long period of analytics

 

Just to confirm,

_Categoryoptioncomboname: 437689 rows

You would seem to have an extraordinary number of category combos. Is this
correct?

On Wed, Oct 12, 2016, 14:35 Knut Staring <knutst@xxxxxxxxx> wrote:

> Maybe also test an upgrade?
>
> On 12 Oct 2016 14:22, "Uwe Wahser" <uwe@xxxxxxxxx> wrote:
>
> Hi Abdul,
>
> I saw that you posted this already a few months ago - without success, as
> it
> seems. So let me just take a lucky guess, of what else you could try
> (that's
> what I'd try):
>
> - in catalina.out, can you identify a specific phase of the analytics run
> where
> most of the time is spent or is everything taking longer. Maybe with that
> detail
> info the DEV team can help you further.
> - can you try to list the available database indexes in your installation
> and
> compare with a fresh install of DHIS2.22 if any are missing?
> - can you try to rebuild/repair all the indexes in your installation (never
> tried this in PostgreSQL myself, though)
>
> Don't know if this makes sense, but better than nothing :-)
>
> Regards, Uwe
>
>
> > Abdul karim Jaafar <abdulkarim.jaafar87@xxxxxxxxx> hat am 12. Oktober
> 2016 um
> > 12:22 geschrieben:
> >
> >
> > Dears all,
> >
> >
> >
> > I’ve been facing a problem with analytic period for over than two months,
> >
> >
> >
> > And I didn’t find any solution for this problem.
> >
> >
> >
> > I did a tuning for Postgres and every week I did maintains from data
> > administration, also there is no problems in data integrity.
> >
> >
> >
> > But the analytic period is increasing gradually for over than 20 hours
> >
> >
> >
> > I don’t know what are thing that increase the period for analytics table
> > update.
> >
> >
> >
> > we have:
> >
> > Tracked entity instance: 97358
> >
> > Tracked entity data value: 1872790
> >
> > Tracked entity attribute data value: 1217314
> >
> > Data value: 614956
> >
> >
> >
> > Also I have these rows in table below:
> >
> > _Categoryoptioncomboname: 437689 rows
> >
> > Categoryombos_optioncombos: 669471 rows
> >
> >
> >
> > We did hosting in our own server kindly look for information below:
> >
> > DHIS2, Database and hosting information:
> >
> > Version: 2.22
> >
> > Build revision: 22090
> >
> > Environment variable:DHIS2_HOME
> >
> > External configuration directory:/home/dhis/config
> >
> > File store provider: filesystem
> >
> > Database type: PostgreSQL
> >
> > Database name: dhis2
> >
> > Database user: dhis
> >
> > Java opts: -Xmx16000m -Xms8000m
> >
> > Java home: /usr/lib/jvm/java-8-oracle/jre
> >
> > Java temporary directory: /home/dhis/tomcat-dhis/temp
> >
> > Java version: 1.8.0_101
> >
> > Java vendor: Oracle Corporation
> >
> > OS name: Linux
> >
> > OS architecture: amd64
> >
> > OS version: 4.4.0-34-generic
> >
> > Server memory: Mem Total in JVM: 10237 Free in JVM: 8507 Max Limit: 14222
> >
> > CPU cores:12
> >
> > Users information:
> >
> > There are: 63 users
> >
> > User role: 13
> >
> >
> >
> > I think this volume data not too much to effects the analytics.
> >
> >
> >
> > Any solutions please?
> >
> >
> >
> >
> >
> > Best regards,
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-users
> > Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > More help   : https://help.launchpad.net/ListHelp
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References