| Thread Previous • Date Previous • Date Next • Thread Next |
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 " >
Attachment:
postgresql.conf
Description: Binary data
| Thread Previous • Date Previous • Date Next • Thread Next |
