dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Hi Liem,

Try adjusting the effective_cache_size and shared buffers and see.

Alex

On Thu, Apr 23, 2015 at 12:06 PM, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
wrote:

> Hi Alex,
>
> I already followed that this my  morning but still problem. The attachment
> here is my configuration file
>
> It run fine in 30 minutes practicing continuously then the new problem
> relating to database connection performance issue I already sent in another
> mail thread. Please have a look on it and help me so
>
> Thank you
>
>
> On Thu, Apr 23, 2015 at 3:29 PM, Alex Tumwesigye <atumwesigye@xxxxxxxxx>
> wrote:
>
>> Dear Liem,
>>
>> I have encountered such scenarios before. You may need to optimize your
>> database.
>> Go to postgresql conf and optimize it as per guidelines in
>> https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e469
>>
>> It seems your queries are taking long to get processed. Increasing
>> buffers may assist.
>>
>> Alex
>>
>>
>>
>>
>> On Thu, Apr 23, 2015 at 5:07 AM, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
>> wrote:
>>
>>> Thank you for your kindness, Thuy!. I am happy and will remember that
>>>
>>> @Alex, I tried your option with Serra Leon database, at the first time
>>> it more quicker and can do some actions. However, after several actions,
>>> may be 2-3, I just navigated to dashboard, messages then moved to profile,
>>> the response become slowly as so far. Seem the system hang up
>>>
>>> And the Tomcat still take a lot of PC time about more 80% although my
>>> Tomcat is fresh with only DHIS2 web
>>>
>>> Best regards
>>>
>>> On Wed, Apr 22, 2015 at 5:19 PM, Thuy Nguyen <thuy.hispvietnam@xxxxxxxxx
>>> > wrote:
>>>
>>>> I am happy that you can run the DHIS in your computer now. I am Thuy
>>>> from HISP Vietnam. If you need more support in learning DHIS 2 function and
>>>> build database in it. I will be happy to help you.
>>>> Vào 22-04-2015 17:05, "Michael Mwebaze" <michael.mwebaze@xxxxxxxxx> đã
>>>> viết:
>>>>
>>>> Hi Liem,
>>>>>
>>>>> I am glad I was of help.
>>>>>
>>>>> Cheers
>>>>>
>>>>> On 22 April 2015 at 06:01, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> Hi Michael & Alex,
>>>>>>
>>>>>> It's MAGIC!, the DHIS2 support to generate new database from hql
>>>>>> schema?
>>>>>>
>>>>>> I tried with new database and it run more faster, some actions can be
>>>>>> tested as first time I see
>>>>>>
>>>>>> I also will try the option as Alex suggested by tomorrow and report
>>>>>> you. I have to leave now
>>>>>>
>>>>>> I am very appreciated to your help!
>>>>>>
>>>>>> Thank you all a lot!
>>>>>> Best regards
>>>>>> Liem
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, Apr 22, 2015 at 4:47 PM, Alex Tumwesigye <
>>>>>> atumwesigye@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> Hi Liem,
>>>>>>>
>>>>>>> Please try this tomcat setting.
>>>>>>>
>>>>>>> JAVA_OPTS="-Xmx2000m -XX:MaxPermSize=800m"
>>>>>>>
>>>>>>> Alex
>>>>>>>
>>>>>>> On Wed, Apr 22, 2015 at 12:45 PM, Liem Le Duy <
>>>>>>> liem.leduy@xxxxxxxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> Hi Nieker,
>>>>>>>>
>>>>>>>> Could you please create another thread for your issue? :)
>>>>>>>>
>>>>>>>> Thank you
>>>>>>>> Liem
>>>>>>>>
>>>>>>>> On Wed, Apr 22, 2015 at 4:41 PM, Alex Tumwesigye <
>>>>>>>> atumwesigye@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>> Dear Niekerk,
>>>>>>>>>
>>>>>>>>> Please visit https://www.dhis2.org/downloads for DHIS2 software.
>>>>>>>>> For documentation, please visit
>>>>>>>>> https://www.dhis2.org/documentation
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Alex
>>>>>>>>>
>>>>>>>>> On Wed, Apr 22, 2015 at 12:36 PM, Niekerk, AK, Mnr <
>>>>>>>>> akniekerk@xxxxxxxxx> <akniekerk@xxxxxxxxx> wrote:
>>>>>>>>>
>>>>>>>>>>  Good Day All,
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> I am new to the forum and I have identified that DHIS2 is a tool
>>>>>>>>>> that could be used to monitor patient outcome indicators but I have no idea
>>>>>>>>>> how to go about requesting access to it. I know where to download the tool
>>>>>>>>>> and the resource documents but creating or requesting access is what I seem
>>>>>>>>>> to be having difficulty with.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Is anyone able to direct/assist me?
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Kind Regards,
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> *Ashley Niekerk*
>>>>>>>>>>
>>>>>>>>>> Programme Data Manager
>>>>>>>>>>
>>>>>>>>>> *South to South Program for Comprehensive Family HIV Care &
>>>>>>>>>> Treatment *
>>>>>>>>>>
>>>>>>>>>> Department of Paediatrics and Child Health, Faculty of Medicine
>>>>>>>>>> and Health Sciences, Stellenbosch University | 3rd Floor, Teaching Block,
>>>>>>>>>> Tygerberg Campus , Francie van Zyl Drive, Tygerberg 7505 | Tel +27
>>>>>>>>>> 021 938 9972 | Fax +27  021 938 9972 |
>>>>>>>>>>
>>>>>>>>>> Toll free 0800 050 050 | Email: akniekerk@xxxxxxxxx |
>>>>>>>>>> www.sun.ac.za/southtosouth
>>>>>>>>>>
>>>>>>>>>> [image: cid:image002.jpg@01CE98CD.649BE8E0]
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> *From:* Dhis2-users [mailto:dhis2-users-bounces+akniekerk=
>>>>>>>>>> sun.ac.za@xxxxxxxxxxxxxxxxxxx] *On Behalf Of *Liem Le Duy
>>>>>>>>>> *Sent:* 22 April 2015 11:34 AM
>>>>>>>>>> *To:* Michael Mwebaze
>>>>>>>>>> *Cc:* dhis2-users
>>>>>>>>>> *Subject:* Re: [Dhis2-users] Please help me for a blank run-able
>>>>>>>>>> DHIS2 database
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Hi Michael,
>>>>>>>>>>
>>>>>>>>>> I downloaded version 2.18 from this site
>>>>>>>>>> https://www.dhis2.org/downloads. I just a newbie in this domain
>>>>>>>>>> for 2 days and don't know where is better resource
>>>>>>>>>>
>>>>>>>>>> Best
>>>>>>>>>>
>>>>>>>>>> Liem
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Apr 22, 2015 at 4:29 PM, Michael Mwebaze <
>>>>>>>>>> michael.mwebaze@xxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>   Liem,
>>>>>>>>>>
>>>>>>>>>> are you using the war downloaded from the dhis portal? I remember
>>>>>>>>>> having issues with it so I had to checkout the source code and do a fresh
>>>>>>>>>> maven build and was then able to deploy it. I am hoping you don't have to
>>>>>>>>>> go that far.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>>
>>>>>>>>>> Michael
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On 22 April 2015 at 05:23, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>    Hi Michael,
>>>>>>>>>>
>>>>>>>>>> Thank for your response
>>>>>>>>>>
>>>>>>>>>> Here below is my pc information
>>>>>>>>>>
>>>>>>>>>> RAM: 8gb
>>>>>>>>>> JAVA_OPTS='-Xmx1024m -Xms1024m -XX:PermSize=512m
>>>>>>>>>> -XX:MaxPermSize=1024m'
>>>>>>>>>>
>>>>>>>>>> TOMCAT: 8.0.21
>>>>>>>>>>
>>>>>>>>>> Java 7
>>>>>>>>>>
>>>>>>>>>> DHIS 2.18
>>>>>>>>>>
>>>>>>>>>> Psql 9.4
>>>>>>>>>>
>>>>>>>>>> If you want I will start TeamViewer so you can remote access
>>>>>>>>>>
>>>>>>>>>> Thank you a lot
>>>>>>>>>>
>>>>>>>>>> Liem
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Apr 22, 2015 at 4:18 PM, Michael Mwebaze <
>>>>>>>>>> michael.mwebaze@xxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>    Hi Liem,
>>>>>>>>>>
>>>>>>>>>> How much RAM does your system have? My laptop has 4GB of RAM and
>>>>>>>>>> I am able to run the DHIS2 (with Sierra Leone DB) without any problem with
>>>>>>>>>> the following settings:
>>>>>>>>>>
>>>>>>>>>> JAVA_OPTS  -Xmx512m -XX:MaxPermSize=256m
>>>>>>>>>>
>>>>>>>>>> Tomcat : 8.0.15
>>>>>>>>>>
>>>>>>>>>> Java 7
>>>>>>>>>>
>>>>>>>>>> DHIS 2.18
>>>>>>>>>>
>>>>>>>>>> Psql 9.3
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> What version of the DHIS2 have you deployed?
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>>
>>>>>>>>>> Michael
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On 22 April 2015 at 04:59, Liem Le Duy <liem.leduy@xxxxxxxxxxxxxx>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>  Hi everyone,
>>>>>>>>>>
>>>>>>>>>>   1. Using command-line to start Tomcat to see error, I can not
>>>>>>>>>> see any error thrown out on screen. But I see into the log file, there is a
>>>>>>>>>> message "No Spring WebApplicationInitializer types detected on classpath"
>>>>>>>>>>
>>>>>>>>>> 2. To change JAVA_OPTS
>>>>>>>>>>
>>>>>>>>>> I already try some values, you can see some values in the SEV
>>>>>>>>>> image below that start by REM. But performance still slow
>>>>>>>>>>
>>>>>>>>>> 3. In the performance image, I captured the %CPU that Tomcat
>>>>>>>>>> process take (at the first line)
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Please correct me if any my mistake of configuration
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Apr 22, 2015 at 3:44 PM, Liem Le Duy <
>>>>>>>>>> liem.leduy@xxxxxxxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>   It's very slow on my pc now, I will try to follow all your
>>>>>>>>>> suggest and report later
>>>>>>>>>>
>>>>>>>>>> thank you all a lot
>>>>>>>>>>
>>>>>>>>>> Best
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Apr 22, 2015 at 3:24 PM, John Lewis <
>>>>>>>>>> johnlewis.hisp@xxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>  Hi Liem,
>>>>>>>>>>
>>>>>>>>>> you need to set memory for tomcat.
>>>>>>>>>>
>>>>>>>>>> JAVA_OPTS="-Xmx1024m -Xms1024m -XX:PermSize=512m
>>>>>>>>>> -XX:MaxPermSize=1024m"
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Apr 22, 2015 at 3:19 PM, Liem Le Duy <
>>>>>>>>>> liem.leduy@xxxxxxxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>    Hi Michael,
>>>>>>>>>>
>>>>>>>>>> Yes, correctly, I have checked the Tomcat process always take
>>>>>>>>>> more than 80% CPU
>>>>>>>>>>
>>>>>>>>>> I will try to start manually to see what happened
>>>>>>>>>>
>>>>>>>>>> Thank you a lot
>>>>>>>>>>
>>>>>>>>>> Liem
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Apr 22, 2015 at 3:09 PM, Michael Mwebaze <
>>>>>>>>>> michael.mwebaze@xxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>   Hi Liem,
>>>>>>>>>>
>>>>>>>>>> if you deployed the war into tomcat, you might also want to
>>>>>>>>>> increase the memory allocation to your tomcat. This will help
>>>>>>>>>> significantly. Also if possible, start Tomcat from the command line so you
>>>>>>>>>> are able to see if any exceptions are being thrown so you can troubleshoot.
>>>>>>>>>> I hope this helps.
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>>
>>>>>>>>>> Michael
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On 22 April 2015 at 04:03, John Lewis <johnlewis.hisp@xxxxxxxxx>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>  Hi Liem,
>>>>>>>>>>
>>>>>>>>>> How have you installed dhis2 using dhis2 live or individual
>>>>>>>>>> component.
>>>>>>>>>>
>>>>>>>>>> you can create a database (empty) and use that database name in
>>>>>>>>>> hibernate.properties file.
>>>>>>>>>>
>>>>>>>>>> is it h2 database or postgres.
>>>>>>>>>>
>>>>>>>>>> John
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Wed, Apr 22, 2015 at 3:00 PM, Liem Le Duy <
>>>>>>>>>> liem.leduy@xxxxxxxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>       Dear,
>>>>>>>>>>
>>>>>>>>>> My name is Liem, I am from Viet Nam. I am newbie in DHIS2
>>>>>>>>>>
>>>>>>>>>> I already installed DHIS2 on my pc with Serra Leon data example,
>>>>>>>>>> the web site work but the performance is trouble. I can only log-in, any
>>>>>>>>>> action after log-in successful take long time, I did some actions such as
>>>>>>>>>> "kick profile button".. then waited but the browser always in progress of
>>>>>>>>>> connecting and return nothing for us
>>>>>>>>>>
>>>>>>>>>> I worry about of Serra Leon example data is huge, so that it
>>>>>>>>>> cause performance
>>>>>>>>>>
>>>>>>>>>> Actually I hope to have a blank database version that come up
>>>>>>>>>> with a lit bit data such as user, role,..but can be run-able however with
>>>>>>>>>> more than 320 tables I still not clarified on so I dont know what first
>>>>>>>>>> point to start to have it
>>>>>>>>>>
>>>>>>>>>> So I think to you!, I will be very appreciated if you can send me
>>>>>>>>>> a blank run-able data or suggest me some clues so I can easy to create it
>>>>>>>>>>
>>>>>>>>>> Thank you so much, for reading & understand my condition
>>>>>>>>>>
>>>>>>>>>> I am looking forward to your response
>>>>>>>>>>
>>>>>>>>>> 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
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Alex Tumwesigye
>>>>>>>>>
>>>>>>>>> Technical Advisor - DHIS2 (Consultant),
>>>>>>>>> Ministry of Health/AFENET
>>>>>>>>> Kampala
>>>>>>>>> Uganda
>>>>>>>>>
>>>>>>>>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>>>>>>>>
>>>>>>>>> IT Specialist (Servers, Networks and Security, Health Information
>>>>>>>>> Systems - DHIS2 ) & Solar Consultant
>>>>>>>>>
>>>>>>>>> +256 774149 775, + 256 759 800161
>>>>>>>>>
>>>>>>>>> "I don't want to be anything other than what I have been - one
>>>>>>>>> tree hill "
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> 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
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Alex Tumwesigye
>>>>>>>
>>>>>>> Technical Advisor - DHIS2 (Consultant),
>>>>>>> Ministry of Health/AFENET
>>>>>>> Kampala
>>>>>>> Uganda
>>>>>>>
>>>>>>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>>>>>>
>>>>>>> IT Specialist (Servers, Networks and Security, Health Information
>>>>>>> Systems - DHIS2 ) & Solar Consultant
>>>>>>>
>>>>>>> +256 774149 775, + 256 759 800161
>>>>>>>
>>>>>>> "I don't want to be anything other than what I have been - one tree
>>>>>>> hill "
>>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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
>>>
>>>
>>
>>
>> --
>> Alex Tumwesigye
>>
>> Technical Advisor - DHIS2 (Consultant),
>> Ministry of Health/AFENET
>> Kampala
>> Uganda
>>
>> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>>
>> IT Specialist (Servers, Networks and Security, Health Information Systems
>> - DHIS2 ) & Solar Consultant
>>
>> +256 774149 775, + 256 759 800161
>>
>> "I don't want to be anything other than what I have been - one tree hill "
>>
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "