We are also experiencing the same issue on DSpace 6.2 at https://repositorio.ufsc.br. The access to /community-list takes minutes to complete. Turning on the item counter (strength) makes things much worse. We have hundreds of communities and more than 100K items.
On Wednesday, January 31, 2018 at 7:07:39 PM UTC-2, Ying Jin wrote: > > Hi Bill, > > We are experiencing the same performance issue with 6.2. Although our > community pages load OK, but still much slower than v5.x. Some of our > collections will time out to load or take several minutes to load. They are > not big collections, one of them only have 20 items, but each items > contains 100+ bitstreams. The postgresql left so many "idle in transaction" > processes that will slow down the overall site. The tomcat begin to take > most of the CPU time too. > > We used to use 16G of memory for tomcat under v5.x, and the performance > has been ok. Now, even I increased to 64G(half of our server memory) under > 6.2, the performance didn't improve. > > BTW, we are using Tomcat 8.0.13, Java 1.8, Redhat Linux 6.7, and XMLUI. We > have about 80+ communities, 280+ collections, 60,000+ items and 490,000 > bitstreams. > > Is this a common issue with 6.2? > > Best, > Ying > > > > On Thursday, January 25, 2018 at 9:46:28 AM UTC-6, Bill T wrote: >> >> I am recently experimenting with v6.2 as well, and I am experiencing the >> same problems with community pages. This is possibly not the best layout, >> but we essentially have 1 top level community which contains all other >> collections and communities which number about 1000. Performance loading >> this community was satisfactory in version 5.x, but has become extremely >> slow in v6.x. Anonymous users see a load time of approximately 20 seconds. >> Admin users see a somewhat faster load time, approximately 18 seconds. >> Non-admin logged in users see a page load time of over 1 minute. Any of >> these times prohibit us from going into production with DSpace 6. >> >> Other community pages are faster, depending on the number of sub >> collections/communities, but still too slow for production and much slower >> than v5.x >> >> Our setup is >> RHEL 7 >> 8 cores, 32 GB >> java 1.8.0, tomcat 8.5.14 >> postgresql 9.6.2 >> >> This should be more than enough in terms of hardware and software, and >> ran DSpace 5 successfully. >> >> Is there anybody in the community with a similarly sized instance (1000 >> communities and collections, 60,000 item records) running DSpace 6? >> >> Tom Desair addressed an even worse problem in the 'select collection' >> page of the submission form about a year ago; Is there a similar problem >> on the community pages? (Sorry to pick on you Tom, that's what you get for >> being helpful). >> >> Any questions/comments/suggestions will be appreciated. We would love to >> upgrade, but just can't with the performance I'm seeing. >> >> Thanks! >> Bill >> >> On Tuesday, September 19, 2017 at 10:22:24 AM UTC-5, christian criollo >> wrote: >>> >>> Hi Tim >>> >>> Thanks for the answer in the initial instaaltion the logs shown the >>> migration was successfully and the table schema_version too, this is not >>> the only problem what i have had >>> <https://lh3.googleusercontent.com/-yMoggKNRTqk/WcE14nI2BnI/AAAAAAAAFjM/DO6WeLg10BUkvIicHF7AIjYnVZjviW9QgCLcBGAs/s1600/schema-version%2BDspace.PNG> >>> >>> >>> >>> <https://lh3.googleusercontent.com/-yMoggKNRTqk/WcE14nI2BnI/AAAAAAAAFjM/DO6WeLg10BUkvIicHF7AIjYnVZjviW9QgCLcBGAs/s1600/schema-version%2BDspace.PNG> >>> >>> >>> >>> <https://lh3.googleusercontent.com/-yMoggKNRTqk/WcE14nI2BnI/AAAAAAAAFjM/DO6WeLg10BUkvIicHF7AIjYnVZjviW9QgCLcBGAs/s1600/schema-version%2BDspace.PNG> >>> >>> >>> <https://lh3.googleusercontent.com/-yMoggKNRTqk/WcE14nI2BnI/AAAAAAAAFjM/DO6WeLg10BUkvIicHF7AIjYnVZjviW9QgCLcBGAs/s1600/schema-version%2BDspace.PNG> >>> >>> >>> >>> >>> El martes, 19 de septiembre de 2017, 9:31:23 (UTC-5), Tim Donohue >>> escribió: >>>> >>>> All, >>>> >>>> Just verifying that these indexes are supposed to be created >>>> automatically (for either Oracle or Postgres) as they exist in the 6.0 >>>> database migration scripts: >>>> >>>> https://github.com/DSpace/DSpace/blob/dspace-6_x/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/oracle/V6.0_2015.03.07__DS-2701_Hibernate_migration.sql#L368 >>>> >>>> It sounds like the migrations may not have all completed successfully. >>>> Not sure why that would be. The logs from the initial installation may >>>> have >>>> provided more information as to whether the >>>> "V6.0_2015.03.07__DS-2701_Hibernate_migration" migration succeeded or not. >>>> >>>> You also could double check that your database reports successful >>>> migrations by running [dspace]/bin/dspace database info (This command >>>> reports the current database status, and a larger table that lists all >>>> database migrations and whether each has run successfully on the database.) >>>> >>>> Good luck, >>>> >>>> Tim >>>> >>>> >>>> On Tue, Sep 19, 2017 at 1:25 AM Alan Orth <alan...@gmail.com> wrote: >>>> >>>>> Good to know, Christian. I don't use Oracle so I'm not sure, but I >>>>> assume that these indexes were supposed to be created by DSpace during >>>>> installation. Must be a bug. >>>>> >>>>> Regards, >>>>> >>>>> On Tue, Sep 19, 2017 at 12:50 AM christian criollo <ccrio...@gmail.com> >>>>> wrote: >>>>> >>>>>> Hi Alan >>>>>> >>>>>> I find the reason of slowly and the problem it was indexes database >>>>>> in the table metadatavalue that strangely not executed the scripts are >>>>>> the >>>>>> next: >>>>>> >>>>>> CREATE INDEX metadatavalue_object on metadatavalue(dspace_object_id); >>>>>> CREATE INDEX metadatavalue_field_object on >>>>>> metadatavalue(metadata_field_id, dspace_object_id); >>>>>> >>>>>> I executed this scripts and the performance of the application >>>>>> improve noticeably already respond in seconds that is the normal >>>>>> >>>>>> thanks for your attention and help >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> El jueves, 14 de septiembre de 2017, 1:28:55 (UTC-5), Alan Orth >>>>>> escribió: >>>>>> >>>>>>> Hello, >>>>>>> >>>>>>> Your server should have enough power to run DSpace well. Is there >>>>>>> anything else running on the server? How much of the machine's RAM is >>>>>>> dedicated to the Java JVM heap? You can look in the "Java Information" >>>>>>> section of the control panel when logged into DSpace as an >>>>>>> administrator. >>>>>>> Also, is your DSpace a clean installation or is there a lot of content >>>>>>> submitted in it? >>>>>>> >>>>>>> Regards, >>>>>>> >>>>>> >>>>>>> On Wed, Sep 13, 2017 at 7:37 PM christian criollo < >>>>>>> ccrio...@gmail.com> wrote: >>>>>>> >>>>>>>> >>>>>>>> Hi Alan >>>>>>>> >>>>>>>> this is my configuration >>>>>>>> >>>>>>>> - Operating system version R/ SUSE Linux Enterprise Server 11 >>>>>>>> (x86_64) >>>>>>>> - PostgreSQL version R/ the database is Oracle Database 11g Release >>>>>>>> 11.2.0.3.0 - 64bit >>>>>>>> - Java version R/ java version "1.7.0_45" >>>>>>>> - Tomcat version R/ 7.0.50 >>>>>>>> - Hardware specifications of your server, like RAM and CPU R/ *three >>>>>>>> proccesors* Intel(R) Xeon(R) CPU E5-2690 v4 @ 2.60GHz *RAM * >>>>>>>> 5994588 kB >>>>>>>> >>>>>>>> I hope htis help >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> El miércoles, 13 de septiembre de 2017, 7:43:56 (UTC-5), Alan Orth >>>>>>>> escribió: >>>>>>>> >>>>>>>>> Hello, Christian. >>>>>>>>> >>>>>>>>> You need to give us more information before we would be able to >>>>>>>>> help you. For example: >>>>>>>>> >>>>>>>>> - Operating system version >>>>>>>>> - PostgreSQL version >>>>>>>>> - Java version >>>>>>>>> - Tomcat version >>>>>>>>> - Hardware specifications of your server, like RAM and CPU >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> >>>>>>>>> On Tue, Sep 12, 2017 at 6:02 PM christian criollo < >>>>>>>>> ccrio...@gmail.com> wrote: >>>>>>>>> >>>>>>>> Hi all >>>>>>>>>> >>>>>>>>>> Recently I installed Dspace 6.2 when I give click in a community, >>>>>>>>>> collection or item it takes too long to respond normally it should >>>>>>>>>> be a few >>>>>>>>>> seconds what t could be happenning ? >>>>>>>>>> >>>>>>>>>> thanks for the help >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>> Google Groups "DSpace Technical Support" group. >>>>>>>>>> >>>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>>>> send an email to dspace-tech...@googlegroups.com. >>>>>>>>>> To post to this group, send email to dspac...@googlegroups.com. >>>>>>>>> >>>>>>>>> >>>>>>>>>> Visit this group at https://groups.google.com/group/dspace-tech. >>>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>>> >>>>>>>>> -- >>>>>>>>> >>>>>>>>> Alan Orth >>>>>>>>> alan...@gmail.com >>>>>>>>> >>>>>>>> >>>>>>>>> https://picturingjordan.com >>>>>>>>> https://englishbulgaria.net >>>>>>>>> https://mjanja.ch >>>>>>>>> >>>>>>>> -- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "DSpace Technical Support" group. >>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>> send an email to dspace-tech...@googlegroups.com. >>>>>>>> To post to this group, send email to dspac...@googlegroups.com. >>>>>>>> Visit this group at https://groups.google.com/group/dspace-tech. >>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> -- >>>>>>> >>>>>>> Alan Orth >>>>>>> alan...@gmail.com >>>>>>> https://picturingjordan.com >>>>>>> https://englishbulgaria.net >>>>>>> https://mjanja.ch >>>>>>> >>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "DSpace Technical Support" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to dspace-tech...@googlegroups.com. >>>>>> To post to this group, send email to dspac...@googlegroups.com. >>>>>> Visit this group at https://groups.google.com/group/dspace-tech. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> -- >>>>> >>>>> Alan Orth >>>>> alan...@gmail.com >>>>> >>>>> >>>>> https://picturingjordan.com >>>>> https://englishbulgaria.net >>>>> https://mjanja.ch >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "DSpace Technical Support" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to dspace-tech...@googlegroups.com. >>>>> To post to this group, send email to dspac...@googlegroups.com. >>>>> Visit this group at https://groups.google.com/group/dspace-tech. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>>> >>>> Tim Donohue >>>> Technical Lead for DSpace & DSpaceDirect >>>> DuraSpace.org | DSpace.org | DSpaceDirect.org >>>> >>>> -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
